SQL/MX 3.2.1 Guide to Stored Procedures in Java (H06.26+, J06.15+)

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 (page 93).
>>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;
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
(page 94).
Backing Up SPJs
Backing up SPJs should be part of a backup and recovery strategy for the entire database. This
strategy should involve periodically storing copies of these files in a safe location, such as another
disk, magnetic tape, or another system:
• CREATE PROCEDURE statements (or the equivalent SQL/MX metadata)
• Java class or JAR files that contain the Java classes of the SPJs
For comprehensive strategies of backing up and recovering database files, see the SQL/MX
Installation and Upgrade Guide and SQL/MX Management Manual.
Backing Up SPJs 97