SQL/MX Guide to Stored Procedures in Java (G06.24+, H06.03+)

Managing SPJs in NonStop SQL/MX
HP NonStop SQL/MX Guide to Stored Procedures in Java—523727-004
6-17
Regenerating CREATE PROCEDURE Statements
3. To end logging, enter the LOG command without the name of the log file:
LOG;
4. Edit the log file by removing the SHOWDDL commands and by revising the
CREATE PROCEDURE statements if necessary.
In this example, you must remove the text in boldface from the log file. The output
of the SHOWDDL command does not exactly match the original CREATE
PROCEDURE statement. For more information, see the Output of the SHOWDDL
Command on page 6-12.
As you can with any OBEY command file, you can use the edited log file to re-create
the SPJs if necessary. For more information, see CREATE PROCEDURE Statements
in an OBEY Command File on page 6-14.
>>showddl procedure samdbcat.sales.dailyorders;
CREATE PROCEDURE SAMDBCAT.SALES.DAILYORDERS
(
IN DATE
, OUT NUMBER INTEGER
)
EXTERNAL NAME 'Sales.numDailyOrders (java.sql.Date,int[])'
EXTERNAL PATH '/usr/mydir/myclasses'
LOCATION \KINGPIN.$TX0115.ZSDX7KT4.N71HTB00
LANGUAGE JAVA
PARAMETER STYLE JAVA
READS SQL DATA
NOT DETERMINISTIC
ISOLATE
;
--- SQL operation complete.
>>showddl procedure samdbcat.sales.monthlyorders;
CREATE PROCEDURE SAMDBCAT.SALES.MONTHLYORDERS
(
IN INTEGER
, OUT NUMBER INTEGER
)
EXTERNAL NAME 'Sales.numMonthlyOrders (int,int[])'
EXTERNAL PATH '/usr/mydir/myclasses'
LOCATION \KINGPIN.$TX0115.ZSDX7KT4.G13HVB00
LANGUAGE JAVA
PARAMETER STYLE JAVA
READS SQL DATA
NOT DETERMINISTIC
ISOLATE
;
--- SQL operation complete.
>>log;