Sample applications in TSO

A set of Db2 sample applications run in the TSO environment.

Table 1. Sample Db2 applications for TSO
Application Program name Preparation JCL member name Attachment facility Description
Phone DSN8BC3 DSNTEJ2C DSNELI This COBOL batch program lists employee telephone numbers and updates them if requested.
Phone DSN8BD3 DSNTEJ2D DSNELI This C batch program lists employee telephone numbers and updates them if requested.
Phone DSN8BE3 DSNTEJ2E DSNELI This C++ batch program lists employee telephone numbers and updates them if requested.
Phone DSN8BP3 DSNTEJ2P DSNELI This PL/I batch program lists employee telephone numbers and updates them if requested.
Phone DSN8BF3 DSNTEJ2F DSNELI This FORTRAN program lists employee telephone numbers and updates them if requested.
Organization DSN8HC3 DSNTEJ3C or DSNTEJ6 DSNALI This COBOL ISPF program displays and updates information about a local department. It can also display and update information about an employee at a local or remote location.
Phone DSN8SC3 DSNTEJ3C DSNALI This COBOL ISPF program lists employee telephone numbers and updates them if requested.
Phone DSN8SP3 DSNTEJ3P DSNALI This PL/I ISPF program lists employee telephone numbers and updates them if requested.
UNLOAD DSNTIAUL DSNTEJ2A DSNELI This assembler language program unloads the data from a table or view and to produce LOAD utility control statements for the data.
Dynamic SQL DSNTIAD DSNTIJTM DSNELI This assembler language program dynamically executes non-SELECT statements read in from SYSIN; that is, it uses dynamic SQL to execute non-SELECT SQL statements.
Dynamic SQL DSNTEP2 DSNTEJ1P or DSNTEJ1L DSNELI This PL/I program dynamically executes SQL statements read in from SYSIN. Unlike DSNTIAD, this application can also execute SELECT statements.
Stored procedures1 DSN8EP1 DSNTEJ6P DSNELI The jobs DSNTEJ6P and DSNTEJ6S prepare a PL/I version of the application. This sample executes Db2 commands using the instrumentation facility interface (IFI).
Stored procedure1 DSN8EP2 DSNTEJ6S DSNRLI
Stored procedures1 DSN8EPU DSNTEJ6U DSNELI The sample that is prepared by job DSNTEJ6U invokes the utilities stored procedure.
Stored procedures1 DSN8ED1 DSNTEJ6D DSNELI The jobs DSNTEJ6D and DSNTEJ6T prepare a C version of the application. The C stored procedure uses result sets to return commands to the client. This sample executes Db2 commands using the instrumentation facility interface (IFI).
Stored procedures1 DSN8ED2 DSNTEJ6T DSNRLI
Stored procedures1 DSN8EC1 DSNTEJ61 DSNRLI The sample that is prepared by jobs DSNTEJ61 and DSNTEJ62 demonstrates a stored procedure that accesses IMS databases through the ODBA interface.
Stored procedures1 DSN8EC2 DSNTEJ62 DSNELI
Stored procedures1 DSN8ES1 DSNTEJ63 DSNRLI The sample that is prepared by jobs DSNTEJ63 and DSNTEJ64 demonstrates how to prepare an SQL procedure using JCL.
Stored procedures1 DSN8ED3 DSNTEJ64 DSNELI
Stored procedures1 DSN8ES2 DSNTEJ65 DSNRLI The sample that is prepared by job DSNTEJ65 demonstrates how to prepare an SQL procedure using the SQL procedure processor.
Stored procedures1 DSN8ED6 DSNTEJ6W DSNELI The sample that is prepared by job DSNTEJ6W demonstrates how to prepare and run a client program that calls a Db2–supplied stored procedure to refresh a WLM environment.
Stored procedures1 DSN8ED7 DSNTEJ6Z DSNELI The sample that is prepared by job DSNTEJ6Z demonstrates how to prepare and run a client program that calls a Db2–supplied stored procedure to display the current settings of system parameters.
Stored procedures1 DSN8ED9 DSNTEJ66 DSNELI The sample that is prepared by job DSNTEJ66 demonstrates how to prepare and run a client program that calls a native SQL procedure, manages versions of that procedure, and optionally, deploys that procedure to a remote server. DSN8ES3 is the sample native SQL procedure and DSN8ED9 is the sample C language caller of DSN8ES3.
Stored procedures1 DSN8ES3 DSNTEJ66 not applicable
User-defined functions DSN8DUAD DSNTEJ2U DSNRLI These C applications consist of a set of user-defined scalar functions that can be invoked through SPUFI or DSNTEP2.
User-defined functions DSN8DUAT DSNTEJ2U DSNRLI
User-defined functions DSN8DUCD DSNTEJ2U DSNRLI
User-defined functions DSN8DUCT DSNTEJ2U DSNRLI
User-defined functions DSN8DUCY DSNTEJ2U DSNRLI
User-defined functions DSN8DUTI DSNTEJ2U DSNRLI
User-defined functions DSN8DUWC DSNTEJ2U DSNRLI The user-defined table function DSN8DUWF can be invoked by the C client program DSN8DUWC.
User-defined functions DSN8DUWF DSNTEJ2U DSNRLI
User-defined functions DSN8EUDN DSNTEJ2U DSNRLI These C++ applications consist of a set of user-defined scalar functions that can be invoked through SPUFI or DSNTEP2.
User-defined functions DSN8EUMN DSNTEJ2U DSNRLI
User-defined functions DSN8HDFS DSNTEJBI DSNRLI The user-defined table function HDFS_READ, which is prepared by DSNTEJBI, reads data from a delimiter-separated file in the Hadoop Distributed File System (HDFS). This user-defined function can be invoked through SPUFI or DSNTEP2.
User-defined functions DSN8JAQL DSNTEJBI DSNRLI The user-defined scalar function JAQL_SUBMIT, which is prepared by DSNTEJBI, invokes an IBM® InfoSphere® BigInsights® Jaql query. This user-defined function can be invoked through SPUFI or DSNTEP2.
LOBs DSN8DLPL DSNTEJ71 DSNELI These applications demonstrate how to populate a LOB column that is greater than 32 KB, manipulate the data using the POSSTR and SUBSTR built-in functions, and display the data in ISPF using GDDM.
LOBs DSN8DLCT DSNTEJ71 DSNELI
LOBs DSN8DLRV DSNTEJ73 DSNELI
LOBs DSN8DLPV DSNTEJ75 DSNELI
Note:
  1. All of the stored procedure applications consist of a calling program, a stored procedure program, or both.