S806 Abend while trying to access a DB2 Table

bijumon · Posted: Sun Aug 12, 2007 2:48 pm

Hi,

I am new to the Easytrieve DB2 programs, i created a JCL to run a program which is just reading a DB2 table and displaying its contents.

But I am getting an S806 abend as follows:

REQUESTED MODULE DQSPSCV NOT FOUND
what all JCLLIBS do i need to provide for this easytrieve program.
Or what all are the pre requisites of running an Easytrieve program which accesses a DB2 table.

ofer71 · Posted: Sun Aug 12, 2007 4:43 pm

Take a look at CA-Easytrieve Plus SQL Interface Option Guide, Chapter 7: "Executing Your SQL Program".

O.

dick scherrer · Posted: Sun Aug 12, 2007 8:13 pm

Hello,

It you talk with the DBAs and/or system support people for your system, they should be able to tell you exactly which dataset names need to be used for your environment.