Chapter 4: Using isql

Example

The following 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.OCC126.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.OCC126.MVS.JCL(SYIHTSQL).

View this book as PDF