Result:<\/p>\n\n\n\n
![\"\"](\"https:\/\/www.skillup.cloud\/wp-content\/uploads\/2023\/11\/Actions-help-hint-icon.png\"){kind=icon}
Casi in cui pu\u00f2 essere utile:<\/p>\n\n\n\n
--- \nSCHEMA TABLE_NAME TYPE POS CONSTRAINT_NAME COLUMN_NAME\nMFXDWHF XMI_FGM_0201_01_ABS_DC PRIMARY KEY 1 Q_MFXDWHF_ZDIY020101_GUUID_00001 INT_SVCTRID_GUUID\nMFXDWHF XMI_FGM_0201_01_ABS_DC PRIMARY KEY 2 Q_MFXDWHF_ZDIY020101_GUUID_00001 INT_STRD_GUUID_C\nMFXDWHF XMI_FGM_0201_01_ABS_DC UNIQUE 1 XMI_FGM_0201_01_ABS_DC_CU INT_SVCTRID_GUUID\nMFXDWHF XMI_FGM_0201_01_ABS_DC UNIQUE 2 XMI_FGM_0201_01_ABS_DC_CU CHAIN_CODE\nMFXDWHF XMI_FGM_0201_01_ABS_DC UNIQUE 3 XMI_FGM_0201_01_ABS_DC_CU SUBCHAIN_CODE\nMFXDWHF XMI_FGM_0201_01_ABS_DC UNIQUE 4 XMI_FGM_0201_01_ABS_DC_CU DEST_STORE\nMFXDWHF XMI_FGM_0201_01_ABS_DC UNIQUE 5 XMI_FGM_0201_01_ABS_DC_CU ORIG_STORE\nMFXDWHF XMI_FGM_0201_01_ABS_DC UNIQUE 6 XMI_FGM_0201_01_ABS_DC_CU ORIG_CHAIN_CODE\nMFXDWHF XMI_FGM_0201_01_ABS_DC UNIQUE 7 XMI_FGM_0201_01_ABS_DC_CU ORIG_SUBCHAIN_CODE\nMFXDWHF XMI_FGM_0201_01_ABS_DC UNIQUE 8 XMI_FGM_0201_01_ABS_DC_CU TRANSACTION_DATE\nMFXDWHF XMI_FGM_0201_01_ABS_DC UNIQUE 9 XMI_FGM_0201_01_ABS_DC_CU NUMDOC\nMFXDWHF XMI_FGM_0201_01_ABS_DC UNIQUE 10 XMI_FGM_0201_01_ABS_DC_CU SKU_CODE\nMFXDWHF XMI_FGM_0201_01_ABS_DC UNIQUE 11 XMI_FGM_0201_01_ABS_DC_CU WIDTH_CODE\nMFXDWHF XMI_FGM_0201_01_ABS_DC UNIQUE 12 XMI_FGM_0201_01_ABS_DC_CU WH_SIZE\nMFXDWHF XMI_FGM_0201_01_ABS_DC UNIQUE 13 XMI_FGM_0201_01_ABS_DC_CU ACC_DOC_NUM\nMFXDWHF XMI_FGM_0201_01_ABS_DC UNIQUE 14 XMI_FGM_0201_01_ABS_DC_CU ACC_DOC_DATE\n---<\/pre>\n\n\n\nCome ottenere elenco Routines<\/p>\n\n\n\n
SELECT\n SPECIFIC_SCHEMA,\n SPECIFIC_NAME,\n ROUTINE_SCHEMA,\n ROUTINE_NAME,\n ROUTINE_TYPE\n FROM QSYS2.SYSROUTINES\n WHERE SPECIFIC_SCHEMA='SQLJ'<\/pre>\n\n\n\nResult:<\/p>\n\n\n\n
---\nSPECIFIC_SCHEMA SPECIFIC_NAME ROUTINE_SCHEMA ROUTINE_NAME ROUTINE_TYPE \nSQLJ DB2_INSTALL_JAR SQLJ DB2_INSTALL_JAR PROCEDURE \nSQLJ DB2_REPLACE_JAR SQLJ DB2_REPLACE_JAR PROCEDURE \nSQLJ DB2_UPDATEJARINFO SQLJ DB2_UPDATEJARINFO PROCEDURE \nSQLJ INSTALL_JAR SQLJ INSTALL_JAR PROCEDURE \nSQLJ RECOVERJAR SQLJ RECOVERJAR PROCEDURE \nSQLJ REFRESH_CLASSES SQLJ REFRESH_CLASSES PROCEDURE \nSQLJ REMOVE_JAR SQLJ REMOVE_JAR PROCEDURE \nSQLJ REPLACE_JAR SQLJ REPLACE_JAR PROCEDURE \nSQLJ SQLJ_PROFILE SQLJ SQLJ_PROFILE PROCEDURE \nSQLJ UPDATEJARINFO SQLJ UPDATEJARINFO PROCEDURE \n---<\/pre>\n\n\n\nCome ottenere elenco Trigger<\/p>\n\n\n\n
SELECT\n TRIGGER_SCHEMA,\n TRIGGER_NAME,\n EVENT_MANIPULATION,\n EVENT_OBJECT_SCHEMA,\n EVENT_OBJECT_TABLE\n FROM QSYS2.SYSTRIGGER\n WHERE TRIGGER_SCHEMA='LAKEVIEW'<\/pre>\n\n\n\nResult:<\/p>\n\n\n\n
---\nTRIGGER_SCHEMA TRIGGER_NAME EVENT_MANIPULATION EVENT_OBJECT_SCHEMA EVENT_OBJECT_TABLE \nLAKEVIEW QSYS_TRIG_LAKEVIEW___LM2000P____000001 DELETE LAKEVIEW LM2000P\nLAKEVIEW QSYS_TRIG_LAKEVIEW___LM2000P____000002 INSERT LAKEVIEW LM2000P\nLAKEVIEW QSYS_TRIG_LAKEVIEW___LM2000P____000003 UPDATE LAKEVIEW LM2000P\nLAKEVIEW QSYS_TRIG_LAKEVIEW___CM0200P____000001 DELETE LAKEVIEW CM0200P\nLAKEVIEW QSYS_TRIG_LAKEVIEW___CM0200P____000002 INSERT LAKEVIEW CM0200P\nLAKEVIEW QSYS_TRIG_LAKEVIEW___CM0200P____000003 UPDATE LAKEVIEW CM0200P\nLAKEVIEW QSYS_TRIG_LAKEVIEW___LM3100P____000001 DELETE LAKEVIEW LM3100P\nLAKEVIEW QSYS_TRIG_LAKEVIEW___LM3100P____000002 INSERT LAKEVIEW LM3100P\nLAKEVIEW QSYS_TRIG_LAKEVIEW___LM3100P____000003 UPDATE LAKEVIEW LM3100P\nLAKEVIEW QSYS_TRIG_LAKEVIEW___LM3100P____000004 INSERT LAKEVIEW LM3100P\nLAKEVIEW QSYS_TRIG_LAKEVIEW___LM3100P____000005 UPDATE LAKEVIEW LM3100P\nLAKEVIEW QSYS_TRIG_LAKEVIEW___LM3200P____000001 DELETE LAKEVIEW LM3200P\nLAKEVIEW QSYS_TRIG_LAKEVIEW___LM3200P____000002 INSERT LAKEVIEW LM3200P\nLAKEVIEW QSYS_TRIG_LAKEVIEW___LM3200P____000003 UPDATE LAKEVIEW LM3200P\nLAKEVIEW QSYS_TRIG_LAKEVIEW___LM3300P____000001 DELETE LAKEVIEW LM3300P\nLAKEVIEW QSYS_TRIG_LAKEVIEW___LM3300P____000002 INSERT LAKEVIEW LM3300P\nLAKEVIEW QSYS_TRIG_LAKEVIEW___LM3300P____000003 UPDATE LAKEVIEW LM3300P\nLAKEVIEW QSYS_TRIG_LAKEVIEW___LM3400P____000001 DELETE LAKEVIEW LM3400P\nLAKEVIEW QSYS_TRIG_LAKEVIEW___LM3400P____000002 INSERT LAKEVIEW LM3400P\nLAKEVIEW QSYS_TRIG_LAKEVIEW___LM3400P____000003 UPDATE LAKEVIEW LM3400P\nLAKEVIEW QSYS_TRIG_LAKEVIEW___LM3400P____000004 INSERT LAKEVIEW LM3400P\nLAKEVIEW QSYS_TRIG_LAKEVIEW___LM0110P____000001 DELETE LAKEVIEW LM0110P\nLAKEVIEW QSYS_TRIG_LAKEVIEW___LM0110P____000002 INSERT LAKEVIEW LM0110P\nLAKEVIEW QSYS_TRIG_LAKEVIEW___LM0110P____000003 UPDATE LAKEVIEW LM0110P\nLAKEVIEW QSYS_TRIG_LAKEVIEW___LM3400P____000005 UPDATE LAKEVIEW LM3400P\n---<\/pre>\n\n\n\nCome ottenere elenco Journal<\/p>\n\n\n\n
SELECT\n JOURNAL_NAME,\n JOURNAL_LIBRARY,\n ASP_NUMBER,\n JOURNAL_ASPGRP,\n ATTACHED_JOURNAL_RECEIVER_NAME,\n ATTACHED_JOURNAL_RECEIVER_LIBRARY\n FROM QSYS2.JOURNAL_INFO\n WHERE JOURNAL_LIBRARY='QUSRSYS'<\/pre>\n\n\n\nResult:<\/p>\n\n\n\n
--- \nJOURNAL_NAME JOURNAL_LIBRARY ASP_NUMBER JOURNAL_ASPGRP ATTACHED_JOURNAL_RECEIVER_NAME ATTACHED_JOURNAL_RECEIVER_LIBRARY\nQAOSDIAJRN QUSRSYS 1 *SYSBAS QAOSDI1154 QUSRSYS\nQASOSCFG QUSRSYS 1 *SYSBAS QASOSC1151 QUSRSYS\nQDSNX QUSRSYS 1 *SYSBAS QDSNX1150 QUSRSYS\nQLZALOG QUSRSYS 1 *SYSBAS QLZALO1150 QUSRSYS\nQMAJRN QUSRSYS 1 *SYSBAS QMAJRN1150 QUSRSYS\nQPMCCCAJRN QUSRSYS 1 *SYSBAS QPMCCA0057 QUSRSYS\nQSNADS QUSRSYS 1 *SYSBAS QSNADS1152 QUSRSYS\nQSXJRN QUSRSYS 1 *SYSBAS QSXJRN1366 QUSRSYS\nQSZRAIR QUSRSYS 1 *SYSBAS QSZRAI1150 QUSRSYS\nQTOVDBJRN QUSRSYS 1 *SYSBAS QTOVDB0054 QUSRSYS\nQVPN QUSRSYS 1 *SYSBAS QVPN0145 QUSRSYS\nQZCAJRN QUSRSYS 1 *SYSBAS QZCAJR1150 QUSRSYS\nQZMF QUSRSYS 1 *SYSBAS QZMF1151 QUSRSYS\n---<\/pre>\n\n\n\nCome ottenere Elenco Colonne di una Tabella con il formato<\/p>\n\n\n\n
SELECT\n SYSTEM_TABLE_NAME,\n TABLE_NAME,\n ORDINAL_POSITION \"Op\",\n COLUMN_NAME,\n SYSTEM_COLUMN_NAME,\n CONCAT(DATA_TYPE,CONCAT(CONCAT('(',LENGTH),')')) \"Data_Type\"\n FROM QSYS2.SYSCOLUMNS\n WHERE TABLE_NAME ='GN_DWH_LOG'\n ORDER BY TABLE_NAME, ORDINAL_POSITION<\/pre>\n\n\n\nResult:<\/p>\n\n\n\n
---\nSYSTEM_TABLE_NAME TABLE_NAME Op COLUMN_NAME SYSTEM_COLUMN_NAME Data_Type\nGN_DWH_LOG GN_DWH_LOG 1 GL_ID GL_ID BIGINT(8)\nGN_DWH_LOG GN_DWH_LOG 2 GL_GUUID GL_GUUID VARCHAR(128)\nGN_DWH_LOG GN_DWH_LOG 3 GL_MSG_TYPE GL_MS00001 VARCHAR(20)\nGN_DWH_LOG GN_DWH_LOG 4 GL_INT_ID GL_INT_ID VARCHAR(128)\nGN_DWH_LOG GN_DWH_LOG 5 GL_STEP GL_STEP VARCHAR(128)\nGN_DWH_LOG GN_DWH_LOG 6 GL_MSG GL_MSG VARCHAR(1024)\nGN_DWH_LOG GN_DWH_LOG 7 GL_TS GL_TS TIMESTMP(10)\n---<\/pre>\n","protected":false},"excerpt":{"rendered":"Come ottenere lista colonne primary_key e constraint di una tabella ELECT A.TABLE_SCHEMA “SCHEMA”, A.TABLE_NAME, A.CONSTRAINT_TYPE “TYPE”, C.ORDINAL_POSITION “POS”, A.CONSTRAINT_NAME, C.COLUMN_NAME FROM QSYS2.SYSCST A LEFT OUTER JOIN QSYS2.SYSREFCST B ON A.CONSTRAINT_SCHEMA = B.CONSTRAINT_SCHEMA AND A.CONSTRAINT_NAME = B.CONSTRAINT_NAME LEFT OUTER JOIN QSYS2.SYSKEYCST…<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[16],"tags":[29,31,40,46,85,86,87,88,89,90],"class_list":["post-3910","post","type-post","status-publish","format-standard","hentry","category-iniziamo-con-alcuni-esempi","tag-as400","tag-db2","tag-iseries","tag-sql","tag-sysrefcst","tag-syskeycst","tag-sysroutines","tag-ssystrigger","tag-journal_info","tag-syscolumn"],"_links":{"self":[{"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/posts\/3910","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/comments?post=3910"}],"version-history":[{"count":1,"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/posts\/3910\/revisions"}],"predecessor-version":[{"id":3911,"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/posts\/3910\/revisions\/3911"}],"wp:attachment":[{"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/media?parent=3910"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/categories?post=3910"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skillup.cloud\/it\/wp-json\/wp\/v2\/tags?post=3910"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}