DB2 from EasyTrieve

Hi,

I am trying to access DB2 tables from a Easytrieve program....but have not
been able to. Hope you guys can help me out !

Following is the SYSPRINT output of the program I tried to execute.

-------------------------------------------------------------------------------
------------------------------------
PARM SSID('DB2T') +
SQLID('SYSIBM')

FILE OUTRPT


W-NAME W 8 A

JOB INPUT SQL
SELECT NAME FROM SYSPLAN ORDER BY NAME +
*******B204 SQL - DB2 SUBSYSTEM "DB2T" DOES NOT EXIST
*******B204 SQL - CHANGING TO "PARTIAL" SQL SYNTAX CHECKING
INTO :W-NAME
-------------------------------------------------------------------------------
------------------------------------

According to the manual, it says that Easytrieve can do Automatic retrival and
it says that -

"In this read-only method, SQL must be coded on the JOB statement in
place of a file name. A SELECT statement must be coded directly after the
JOB statement to specify the columns to be retrieved and the host
variables to receive the data. Each time the JOB activity is iterated,
another row of SQL data is retrieved. This is a simple way to retrieve
SQL data into working storage or into an extract file for subsequent
output. "

Also, my execution step in the JCL has the DB2 loadlibs and the EZYT loadlibs
concatenated.....So, I am not sure what else I am missing here.

Any ideas ?

Thanks,
Madhu

I don't know a thing about Easytrieve, but are you submitting the job to
the correct system? (assuming you have multiple MVS images and assuming
DB2T is the correct name). We ran into similar messages when people forgot
to use a "/*JBS BIND system" card or the jobclass we dedicated to DB2 and
the jobs ended up on another box.

At 11:37 AM 12/21/99 -0700, you wrote:
>Hi,
>
>I am trying to access DB2 tables from a Easytrieve program....but have not
>been able to. Hope you guys can help me out !
>
>Following is the SYSPRINT output of the program I tried to execute.
>
>---------------------------------------------------------------------------
----
>------------------------------------
>PARM SSID('DB2T') +
> SQLID('SYSIBM')
>
>FILE OUTRPT
>
>
>W-NAME W 8 A
>
>JOB INPUT SQL
> SELECT NAME FROM SYSPLAN ORDER BY NAME +
>*******B204 SQL - DB2 SUBSYSTEM "DB2T" DOES NOT EXIST

You were right !! Thanks a lot.......It worked....I just had to put a /*Route
XEQ 'db2' statement.....

lRegards and have a great holiday !

Madhu



From: [login to unmask email] on 12/21/99 02:22 PM
To: [login to unmask email]
cc: (bcc: Madhu K Banavati)
Subject: Re: DB2 from EasyTrieve

I don't know a thing about Easytrieve, but are you submitting the job to
the correct system? (assuming you have multiple MVS images and assuming
DB2T is the correct name). We ran into similar messages when people forgot
to use a "/*JBS BIND system" card or the jobclass we dedicated to DB2 and
the jobs ended up on another box.

At 11:37 AM 12/21/99 -0700, you wrote:
>Hi,
>
>I am trying to access DB2 tables from a Easytrieve program....but have not
>been able to. Hope you guys can help me out !
>
>Following is the SYSPRINT output of the program I tried to execute.
>
>---------------------------------------------------------------------------
----
>------------------------------------
>PARM SSID('DB2T') +
> SQLID('SYSIBM')
>
>FILE OUTRPT
>
>
>W-NAME W 8 A
>
>JOB INPUT SQL
> SELECT NAME FROM SYSPLAN ORDER BY NAME +
>*******B204 SQL - DB2 SUBSYSTEM "DB2T" DOES NOT EXIST

You have to use cursor in order to access DB2 tables
in easytrieve plus. Cursor is required even if u want
to process single record.

Nayeem

--- Madhu K Banavati <[login to unmask email]>
wrote:
> You were right !! Thanks a lot.......It worked....I
> just had to put a /*Route
> XEQ 'db2' statement.....
>
> lRegards and have a great holiday !
>
> Madhu
>
>
>
> From: [login to unmask email] on 12/21/99 02:22 PM
> To: [login to unmask email]
> cc: (bcc: Madhu K Banavati)
> Subject: Re: DB2 from EasyTrieve
>
> I don't know a thing about Easytrieve, but are you
> submitting the job to
> the correct system? (assuming you have multiple MVS
> images and assuming
> DB2T is the correct name). We ran into similar
> messages when people forgot
> to use a "/*JBS BIND system" card or the jobclass we
> dedicated to DB2 and
> the jobs ended up on another box.
>
> At 11:37 AM 12/21/99 -0700, you wrote:
> >Hi,
> >
> >I am trying to access DB2 tables from a Easytrieve
> program....but have not
> >been able to. Hope you guys can help me out !
> >
> >Following is the SYSPRINT output of the program I
> tried to execute.
> >
>
>---------------------------------------------------------------------------
> ----
> >------------------------------------
> >PARM SSID('DB2T') +
> > SQLID('SYSIBM')
> >
> >FILE OUTRPT
> >
> >
> >W-NAME W 8 A
> >
> >JOB INPUT SQL
> > SELECT NAME FROM SYSPLAN ORDER BY NAME
> +
> >*******B204 SQL - DB2 SUBSYSTEM "DB2T" DOES NOT
> EXIST
>
>
> To change your subscription options or to cancel
> your subscription visit the
> DB2-L webpage at http://www.ryci.com/db2-l. The
> owners of the list can be
>
>
>
> To change your subscription options or to cancel
> your subscription visit the DB2-L webpage at
> http://www.ryci.com/db2-l. The owners of the list
> can
>

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com