Question:
Can you execute SQL queries in local mode? I usually execute SQL in CV mode or online.
Answer:
Yes, you can execute SQL queries in local mode using IDMSBCF or a local batch program. Ensure, you are specifying the correct DMCL and DICTNAME in the SYSIDMS parameter. Also verify that you are connecting to the DBNAME that where the SCHEMA is located.
Here's an example:
//IDMSBCF EXEC PGM=IDMSBCF,REGION=2048K
//*** DD DSN=MEN.C5100.NIELD.LOADLIB,DISP=SHR
//STEPLIB DD DSN=DIST.CAGJJ0.PRODTGT.LOADLIB,DISP=SHR
// DD DSN=MEN.C5100.PHIL190.DBA.LOADLIB,DISP=SHR
// DD DSN=MEN.C5100.PHIL190.CUSTOM.LOADLIB,DISP=SHR
// DD DSN=MEN.C5100.PHIL190.CAGJLOAD,DISP=SHR
//SYSLST DD SYSOUT=*
//SYSPCH DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SORTMSG DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//J1JRNL DD DUMMY
//J2JRNL DD DUMMY
//J3JRNL DD DUMMY
//SYSJRNL DD DUMMY
//**SYSCTL DD DSN=MEN.C5100.PHILTEST.SYSCTL,DISP=SHR
//SYSIDMS DD *
ECHO=ON
DBNAME=SYSTEM
DMCL=DMCL1900
/*
//SYSIPT DD *
CONNECT TO SYSTEM;
SELECT NAME, LENGTH, DATALENGTH, PREFIXLENGTH FROM SYSTEM.TABLE;
Additional Information:
CA IDMS Release 19.0 SQL Reference Guide
Chapter 7: Query Specifications, Subqueries, Query Expressions and Cursor Specifications