× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
ivangron reported 2017-02-20T22:53:06Z  · tariqrahiman last modified 2017-02-28T23:05:04Z

DB2 z/OS -> Extraction of procedure missing source


customer request
Priority Low
Complexity Unknown
Component DB - DB2 zOS
Version 17.0

  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.

1 attachment

Issue #15031

Closed
Fixed
Resolved 2017-02-21T03:13:11Z
 
 
Completion
No due date
Fixed Build v17.0.13, v18.0.0-preview-82
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017