One of my application JCL is used to run the FOCUS programs

raghav08 · New User Joined: 03 Jun 2008 Posts: 94 Location: Bangalore

Hi,

In one of my application JCL is used to run the FOCUS programs, this also having DB2 plan as below,

//SYSTSIN DD *
DSN SYS(DB2A)
RUN PROGRAM(FOCUS) PLAN(DSQL) LIBRARY('FOCUS.PROD.FOCLIB')
END

I know the source code of FOCUS program, but i couldn't find any SQL queries. Please let me know how FOCUS program queries the DB2.

dick scherrer · Posted: Thu Dec 04, 2008 8:36 pm

Hello,

FOCUS may build the sql dynamically during the execution so there is no sql source to see.

Suggest you look in the documentation for your release of FOCUS or contact Information Builders support.