MVSFORUMS.com

[cappertan]

I want to access a table that I am connecting to via UDB. In my SQL, in Easytrieve, would I code something like? :
SELECT PAT_ID, DEPARTMENT_ID
FROM HCCLDCO1.HCCLCO.PAT_ENC

HCCLDCO1 is the "CONNECTION LOCATION". (I use this in a SPUFI and I am able to the do the above quire[/code]
_________________
Capp

[kolusu]

cappertan,

You can code the same sql even in easytrieve but you need to code it as a cursor. check the example below for a sample ezt code

[shiv_swami]

Kolusu,
When I try to run easytrieve program with embedded cursors.My job fails with error :

JESMSGLOG:

[kolusu]

Shiv,

Look at the steplib definition in my JCL. You need to concatenate the easytrieve/DB2 loadlib for the job.

Each shop has their own standard of naming the load libraries. Try to check the other load libraries with the high-level qualifier that you use to define the ezt loadlib.

Hope this helps...

Cheers

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

[cappertan]

Kolosu. Hi:

Is this an issue for concatenation as well? We, at my shop, are migrating to Teradata dbms. Since we are running Teradata on a windows based server, access will be via UDB or another method.

How is the package/plan set up to access the tables on Teradata for Easytrieve so that I can do a dynamic link/bind? This would be a read only access.

My error from the attemped compile follows:
SELECT PAT_ID FROM HCCLDCO1.HCCLCO.PAT_ENC +
WHERE PAT_ID = :IN_HRN
**B204 SQL - DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME HCCLDCO1
**B204 SQL - NOT FOUND IN PLAN DQPS24C. REASON 01
HCCLDCo1 is the CONNECTION LOCATOR.
_________________
Capp

[kolusu]

Cappertan,

You need to contact your DBA to enable DRDA(Distributed Request Data Access). SYSIBM.LOCATIONS table will have information for every accessible remote server.

Check this link which discusses Accessing tables in different DB2 sub-systems

Hope this helps...

Cheers

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