Choosing a sample RSP

Sybase recommends that you select a sample RSP in the programming language you are using as a shell for your application. The sample RSPs are provided on the Open ServerConnect API tape.

The following table lists the sample programs and definitions available to you:

Table 3-1: Samples on the Open ServerConnect API tape

Sample

Description

MODELRSP

Shows how to use a DB2 format output pipe and a SQLDA definition. MODELRSP is reproduced in Appendix B, “MODELRSP DB2 Output Pipe Sample RSP.”

RSP3C

Shows how to use STD format input and output pipes to transmit data. RSP3C is reproduced in Appendix C, “RSP3C STD Input and Output Pipe Sample RSP.”

RSP4C

Shows an example of transmitting keyword variables. RSP4C is reproduced in Appendix D, “RSP4C Keyword Variable Sample RSP.”

RSP8C

Shows an example of transmitting variable text. RSP8C is reproduced in Appendix E, “RSP8C Variable Text Sample RSP.”

SAMP01A

Assembler sample program RSP 1. Shows how to use a text property to select data in DB2 and write the results to a CICS temporary storage queue.

SAMP01C

COBOL II sample program RSP 1. (See SAMP01A for description of what it does.)

SAMP02A

Assembler sample program RSP 2. Shows how to select the contents of an entire DB2 table and write the results to STD-format output pipes.

SAMP02C

COBOL II sample program RSP 2. (See SAMP02A for description of what it does.)

SAMP03A

Assembler sample program RSP 3. Shows how to use a keyword property to select data from DB2 and write the results to DB2-format output pipes.

SAMP03C

COBOL II sample program RSP 3. (See SAMP03A for description of what it does.)

SAMP04A

Assembler sample program RSP 4, which demonstrates VSAM access. Shows how to use a text property as a partial key to perform a partial-key “browse” on a VSAM KSDS dataset and write the results to DB2-format output pipes.

SAMP04C

COBOL II sample program RSP 4. (See SAMP04A for description of what it does.)

EMPDATA

Test data for sample program SAMP04.

EMPFILE

VSAM define for sample program SAMP04.

EMPREPRO

JCL to populate sample VSAM file.

EMPTAB

Create table for sample SAMP04.

SPAREAP

PL/I RSP communication area.

SPAREAX

C RSP communication area.

SQLDAX

C sample SQLDA.

PARTSTAB

Create SQL statement table for sample RSPs.