Customer has requested that we modify procedure extraction to attempt to retrieve the source from the sysibm.sysroutines_src table if it does not exist in the sysibm.sysroutines table. example :
-- LOADMOD = 'DSNB10.DBBG.RUNLIB.LOAD(SQL70922)' -- DBRM = 'DSNB10.DBBG.DBRMLIB.DATA(SQL70922)' -- CSOURCE = 'DSNB10.DBBG.SRCLIB.DATA(SQL70922)' CREATE PROCEDURE IVAN.TST_PROC_01 () RESULT SETS 1 LANGUAGE SQL FENCED COLLID TEST WLM ENVIRONMENT DBBGENVD RUN OPTIONS 'NOTEST(NONE,*,*,*)' EXTERNAL NAME LMISP603 P1: BEGIN -- Declare cursor DECLARE cursor1 CURSOR WITH RETURN FOR -- ####################################################################### -- # Replace the SQL statement with your statement. -- # Note: Be sure to end statements with the terminator character -- # (usually ';') -- # The example SQL statement SELECT NAME FROM SYSIBM.SYSTABLES -- # returns all table names from SYSIBM.SYSTABLES. -- ###################################################################### SELECT NAME FROM SYSIBM.SYSTABLES; -- Cursor left open for client application OPEN cursor1; END P1
If the sysibm.sysroutines.text column does not contain any statement source we should also check the sysibm.sysroutines_src.createstmt column.
|
171 KB
initial work checked in to version 18: Committed revision: 53290
Extraction has been modified so that the body will be looked for in sysibm.sysprocedure_src.createstmt column. If the createstmt column is null, it will use the sysibm.sysprocedure.text column.
I would like to make a note for users that the sysibm.sysprocedure_src table user modifiable table. Due to this, we can not guarantee that the information in this table is correct and hope that the DBA of the system is properly managing this catalog table.
Committed revision: 53291
Extraction has been modified so that the body will be looked for in sysibm.sysprocedure_src.createstmt column. If the createstmt column is null, it will use the sysibm.sysprocedure.text column.
I would like to make a note for users that the sysibm.sysprocedure_src table user modifiable table. Due to this, we can not guarantee that the information in this table is correct and hope that the DBA of the system is properly managing this catalog table.
Committed revision: 53291
Verified in ADS-18.0.0.Preview-88. Refer updated screenshot 'Updated_15031.png'
Verified in ADS-18.0.0.Preview-88. Refer updated screenshot 'Updated_15031.png'
Verified in ADS-18.0.0.Preview-88. Refer updated screenshot 'Updated_15031.png'
Verified in ADS-18.0.0.Preview-88. Refer updated screenshot 'Updated_15031.png'
Issue #15031 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build v17.0.13, v18.0.0-preview-82 |
No time estimate |
initial work checked in to version 18: Committed revision: 53290