Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

access AS400 tables from Mainframe programs

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IBM Tools
View previous topic :: :: View next topic  
Author Message
dsandeep

New User


Joined: 17 Mar 2006
Posts: 2

PostPosted: Fri Mar 17, 2006 9:59 am    Post subject: access AS400 tables from Mainframe programs
Reply with quote

icon_question.gif 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
Back to top
View user's profile Send private message

martin9

Active User


Joined: 01 Mar 2006
Posts: 287
Location: Basel, Switzerland

PostPosted: Fri Mar 17, 2006 7:47 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
dsandeep

New User


Joined: 17 Mar 2006
Posts: 2

PostPosted: Fri Mar 17, 2006 9:48 pm    Post subject:
Reply with quote

Thanks Martin,

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

Regards
icon_neutral.gif
Back to top
View user's profile Send private message
Jack Lash

New User


Joined: 17 Nov 2007
Posts: 1
Location: Philadelphia

PostPosted: Mon Nov 19, 2007 7:41 pm    Post subject: Reply to: access AS400 tables from Mainframe programs
Reply with quote

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?
Back to top
View user's profile Send private message
kgumraj2

New User


Joined: 01 Aug 2007
Posts: 42
Location: Hyderabad

PostPosted: Mon Nov 19, 2007 7:54 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IBM Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts FTP from Mainframe to Unix - with CRLF vasanthz All Other Mainframe Topics 5 Thu Mar 23, 2017 5:12 am
No new posts Want to pull the job log into a Mainf... Jishu Mukherjee Compuware & Other Tools 9 Tue Mar 21, 2017 4:48 pm
No new posts Innovations in Your Mainframe Sort Arun Raj PC Guides & IT News 4 Wed Mar 15, 2017 10:38 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts To know activities on db2 tables ashek15 DB2 4 Fri Mar 03, 2017 11:23 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us