You can invoke the MVS isql utility as a standard batch program using these parameters:
SE – server name (ASE or Open Server)
U – user ID
PAS – password
NETDRIVER – driver type used to establish a connection. For the IBM TCP/IP driver, use TCPIBM. For the CPIC driver, use CPIC.
LOGINCSET – name of the character set to be used for logging in to the remote server. Some possible values are iso_1, utf8, and sjis.
DISPCCSID – CCSID to be used for displaying the server result set. Some possible values are 500, 1025, and 277.
Use the LOGINCSET and DISPCCSID parameters only when the USEIBMUNICODE option in the SYGWXCPH module is set to Y. For more information, see Appendix A, “Customization Options.”
The STEPLIB DD statements must point to the following:
Client Option MVS load library
C370 runtime libraries
SYGWXCPH module
TCPIP.SEZALINK data set (for TCP/IP connections)
This is an example of a simple MVS isql invocation:
/MYJOB JOB ... //GO EXEC PGM=SYISQL, // PARM='SE(SYBASE10),U(sa),PAS(NULL),NETDRIVER(TCPIBM)', // REGION=4096K //* //* The following 2 lines are an example of using the new //* Unicode support parameters when USEIBMUNICODE=Y. //* //* PARM='SE(ase1),U(sa),PAS(NULL),NETDRIVER(TCPIBM),DISPCSID(500),LOG* //* INCSET(utf8)', //* //STEPLIB DD DSN=SYBASE.OCC150.MVS.LOADLIB,DISP=SHR // DD DSN=CEE.SCEERUN,DISP=SHR //* DD DSN=TCPIP.SEZALINK,DISP=SHR <-- Change //* //SYSPRINT DD SYSOUT=* //SYSUDUMP DD SYSOUT=* //SYSTERM DD SYSOUT=* //* //SYBSQLIN DD * SELECT * FROM SYBASE.SAMPLETB go /* //
An example of a batch isql invocation is provided in SYBASE.OCC150.MVS.JCL(SYIHTSQL).