Testing the sample

Before you begin to write your RSP, test the sample you are using as a shell. The samples use a table called PCSQL.SAMPLE_PARTS. The CREATE TABLE statement for this table is member PARTSTAB in the SYBASE.ORSP310B.CICS.SOURCE library.

If you want to compile these examples and test them, Sample 1 (SAMP01A or SAMP01C) requires you to provide a 5-byte character value for PARTNO. This variable is not in keyword format, so the statement that executes this stored procedure would appear as:

USE PROCEDURE SAMP01x 'xxxxx'

Sample 3 (SAMP03A or SAMP03C) requires you to provide an ISO-format (yyyy-mm-dd) date value in keyword format for &DATE, as follows:

USE PROCEDURE SAMP03x &DATE='yyyy-mm-dd'

If you need detailed instructions on testing the sample, go to Chapter 5, “Testing and invoking an RSP.”