access AS400 tables from Mainframe programs

dsandeep · New User Joined: 17 Mar 2006 Posts: 2

We need to read AS400 tables(DB2) from Mainframe batch and online programs as weel. Any suggestions ?
Heard that DB2 connect can do this .. anyone has done this before..

Thanks a lot

martin9 · Posted: Fri Mar 17, 2006 7:47 pm

hy dsandeep,

it is possible, depending of your system configuration,
you could connect both db2 systems, this on as400
and this on z/OS together. but how to do this, is
a task for your dba...

martin9

dsandeep · New User Joined: 17 Mar 2006 Posts: 2

Thanks Martin,

Can you tell me whether DB2 connect has to be used for connedting the databases on AS-400 and Mainframe ?

Regards

Jack Lash · Posted: Mon Nov 19, 2007 7:41 pm

I was wondering if you ever found a way to do this. I have been able to connect to the AS400 and read tables with Library names less than eight characters but when the library/file name is greater than 8 characters, I can't get past the bind on the mainframe. If I use the bind parameter SQLERRER(CONTINUE) it will bind but fails at execution. Does anybody have an answer to this problem?

kgumraj2 · New User Joined: 01 Aug 2007 Posts: 42 Location: Hyderabad

DSandeep,

Yes you are correct. DB2 connect will connect the to remote database.

Syntax:
Exec sql
connect to <database name>
end-exec.

As Martin suggested it is more of a DBA work.