The DSN5SCLP program

DSN5SCLP is an ODBC program that you can use to invoke IBM® Spatial Support for Db2 for z/OS® stored procedures for administrative tasks.

Start of change DSN5SCLP is located in the SDSNLOAD library. You can run the DSN5SCLP program using JCL job DSN5SCMD, which is located in the SDSNSAMP library. Before you run DSN5SCMD, follow the customization instructions in the job prolog. End of change

Results are returned in the system log. If the job runs without errors, then a return code of 0 is returned. For example:

GSE0000I  The operation was completed successfully.

Otherwise, a return code of 8 and a description of the error is returned. For example:

GSE1040N  A spatial reference system with the numeric identifier 9999 
already exists.

A return code of 4 might be returned, indicating that the job completed but with a warning. For example:

GSE3010W Invalid ring number 2.

If the value of a parameter is broken by a space, surround the value in quotations marks. For example, “COORDSYS 1”.

Use the plus sign (+) to wrap text to another line. For example:

-xMin 23 + 
-yMin 0

If you use the plus sign within quotation marks, all of the white space before the plus sign is preserved. For example:

“COORDSYS NUMBER + 
ONE” => COORDSYS NUMBER ONE 
“COORDSYS NUMBER+ 
ONE” => COORDSYS NUMBERONE

To use quotation marks within quotation marks, use the backslash symbol (\) with the inner quotation marks. For example:

“\”Coordsys 1\””

To use a left bracket ( [ ) and a right bracket ( ] ) in the definition of a coordinate system, you must use the correct hex value for each bracket. The hex value for a left bracket is 0xAD. The hex value for a right bracket is 0xBD.