IBM Connections: Dicas de Queries para o DB2

= Conexão ao DB2 =

db2 catalog tcpip node DB2PRODUCAO remote  server db2 catalog db PEOPLEDB as PEOPLEDB at node DB2PRODUCAO db2 connect to PEOPLEDB user LCUSER using 

= Gerando listagens =

db2 "SELECT prof_source_uid||';'||prof_display_name||';'||prof_given_name||';'||prof_surname as listagem from empinst.employee" > resultado.txt db2 "SELECT prof_key||';'||prof_given_name||';'||prof_surname as listagem from empinst.employee" > resultado.txt db2 "SELECT 'UPDATE EMPINST.EMPLOYEE SET PROF_GIVEN_NAME=#'||prof_given_name||'#, PROF_SURNAME=#'||prof_surname||'# WHERE PROF_KEY=#'||prof_key||'#' as listagem from empinst.employee" > queryupdate.txt db2 "SELECT 'UPDATE EMPINST.EMPLOYEE SET PROF_GIVEN_NAME=#'||prof_given_name||'#, PROF_SURNAME=#'||prof_surname||'# WHERE PROF_KEY=#'||prof_key||'#' as listagem from empinst.employee" > queryupdate.txt db2 "SELECT prof_key||';'||prof_surname as listagem from empinst.surname" > resultadoSURNAMES.txt db2 "SELECT 'UPDATE EMPINST.SURNAME SET PROF_SURNAME=#'||prof_surname||'# WHERE PROF_KEY=#'||prof_key||'#' as listagem from empinst.surname" > queryupdateSURNAME.txt

= Exemplo =

SELECT prof_key,prof_given_name,prof_surname,prof_last_update from empinst.employee where prof_uid='ebasso' ec4130ce-f29b-4486-8550-a1c847889c8b Enio           Basso        2012-07-05 10:43:11.874

SELECT prof_surname from empinst.surname where prof_key='ec4130ce-f29b-4486-8550-a1c847889c8b' basso rubens basso

= Ver também =


 * IBM Connections:Reorg Connections Databases
 * IBM Connections:Limpeza de diretórios


 * Mais Artigos sobre IBM Connections IBM Connections