MVSFORUMS.com

rrv · Beginner Joined: 01 Nov 2004 Posts: 19 Topics: 6

Hi

Our shop uses CA-EASYTRIEVE PLUS-6.4 extensively in PROD environment for reporting and other utility jobs, limited to Q/VSAM file sets. Recently we installed the PAN/SQL Interface add-on to enable reporting based on DB2.

I'm able to perfectly execute an EASYTRIEVE+SQL program as long as it is compiled and link-edited, using IKJEFT1B. However, when I try to execute the same program under EZTPA00 (see the code below), I receive the following message at the first SQL statement:

*******B204 SQL - INVALID OR MISSING STATIC COMMAND PROGRAM NAME

followed by this at subsequent SQL statements:

*******B256 SQL PROCESSING BYPASSED DUE TO PREVIOUS ERROR

vivek1983 · Intermediate Joined: 20 Apr 2006 Posts: 222 Topics: 24

rrv,

I think you are not giving the db2 subsystem.

I have not worked on EZT yet
I found some of the EZT programs using the following at the start of the program:

PARM LINK (PGMNAME(R)) DB2SSID('DB2SUBSYSTEM')

Vivek G
_________________
Vivek G
--------------------------------------
A dream is just a dream. A goal is a dream with a plan and a deadline. (Harvey Mackay)

rrv · Beginner Joined: 01 Nov 2004 Posts: 19 Topics: 6

Vivek

True, even I have seen the PARM LINK statement at the beginning of few EASYTRIEVE programs. However, my understanding is that PARM LINK terminates execution after the completion of syntax check and compile operations. It does not EXECUTE the program in interpret mode or otherwise.

Pls correct me if this is NOT the case.

Ram

kolusu · Posted: Wed Sep 12, 2007 8:00 am Post subject:

rrv,

You are trying to run a dynamic sql easytrieve program. You need DQSPSCV module to do that. The PAN$SQL DD file is processed only when executing statically. The PAN$SQL file can also be used to indicate that you want to execute under the TSO terminal Monitor Program in background mode. If TSO execution is specified, then the plan name and subsystem ID parameters are ignored.

So you need to concatenate the easytrieve DB2 loadlib dataset to steplib.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

rrv · Beginner Joined: 01 Nov 2004 Posts: 19 Topics: 6

Kolusu

Thanks for the response. The second library in the STEPLIB concatenation does contain DQSPSCV module, as seen from the screen print below.

kolusu · Posted: Wed Sep 12, 2007 10:01 am Post subject:

rrv · Beginner Joined: 01 Nov 2004 Posts: 19 Topics: 6

Kolusu

I've used the following statement to include the DCLGEN equivalent for EASYTRIEVE.

SQL INCLUDE LOCATION W FROM AIDABPTS.IDA_ACCT_MSTR_IDX

This enables one to use COLUMN names as host variables without explicitly defining additional fields.

What I'm not sure is that the same program works perfectly OK when I execute under TSO background using IKJEFT1B after compile & link-edit. Then why does it fail with -302 in INTERPRET mode?

singhm · Beginner Joined: 24 Jan 2007 Posts: 1 Topics: 0

Hi,

I am also getting the same error but in my case I am using DB2 v8, in my query I am using UNION ALL, and it is throwing -302 error. But the same query when I am running without UNION ALL, i.e. breaking the same query to two different queries, the job is running perfectly fine... Shocked

...Any ideas?

Thanks..

CICS Guy · Intermediate Joined: 30 Apr 2007 Posts: 292 Topics: 3

-302 THE VALUE OF INPUT VARIABLE OR PARAMETER NUMBER position-number IS INVALID OR TOO LARGE FOR THE TARGET COLUMN OR THE TARGET VALUE
What is the "position-number" pointing to?

rrv · Beginner Joined: 01 Nov 2004 Posts: 19 Topics: 6

The position number always refers to the very first column being selected. In my example, it is BANK_NUMBER.

The execution environment is CA-PAN/SQL add on working against DB2 V8 Data Sharing Group.