MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

I need to use the calls like DSNCLI & DSNHLI in my progr

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database
View previous topic :: View next topic  
Author Message
me_naveen
Beginner


Joined: 21 Dec 2007
Posts: 23
Topics: 12

PostPosted: Fri Jul 04, 2008 7:56 am    Post subject: I need to use the calls like DSNCLI & DSNHLI in my progr Reply with quote

Hi,
I need to use the calls like DSNCLI & DSNHLI in my program. I would require the materials regarding these calls. If any one have could you please post it here.

Thanks in advance.

Thanks,
Nav
Back to top
View user's profile Send private message
CZerfas
Intermediate


Joined: 31 Jan 2003
Posts: 211
Topics: 8

PostPosted: Mon Jul 07, 2008 4:07 am    Post subject: Reply with quote

Hello Nav,

there is a DB2 feature called "call attach facility" or CAF, which allows you to contact DB2 in a more low-tech fashion (you have to code the attach itself, initialization, detaching, etc.). Trying to mingle with the high level interfaces to DB2 cannot be recommended.

regards
Christian
Back to top
View user's profile Send private message
me_naveen
Beginner


Joined: 21 Dec 2007
Posts: 23
Topics: 12

PostPosted: Mon Jul 07, 2008 7:12 am    Post subject: Reply with quote

Hi Christian,
Thanks for your reply.

Actually my requirement is , Instead of calling the program PGM1, It must be under a different name with a copy of "PARMMVS LNK.IN INCLUDE SYSLIB (DSNHLI)" are used. Actually DSNHLI is used for batch Environment.

As per your reply I need to use CAF.

In the above case how could I resolve my problem.

Thanks,
Nav
Back to top
View user's profile Send private message
dbzTHEdinosauer
Supermod


Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany

PostPosted: Mon Jul 07, 2008 8:18 am    Post subject: Reply with quote

what are you running? what operating system, what version of db2, what cobol/assembler?
_________________
Dick Brenholtz
American living in Varel, Germany
Back to top
View user's profile Send private message
CraigG
Intermediate


Joined: 02 May 2007
Posts: 202
Topics: 0
Location: Viginia, USA

PostPosted: Mon Jul 07, 2008 9:03 am    Post subject: Reply with quote

What are the standards at your site?
Back to top
View user's profile Send private message
jsharon1248
Intermediate


Joined: 08 Aug 2007
Posts: 291
Topics: 2
Location: Chicago

PostPosted: Mon Jul 07, 2008 12:04 pm    Post subject: Reply with quote

I'm not understanding your requirement. There are circumstances where you cannot use the simpler more common methods to connect to DB2. In those cases you must use an alternative like CAF. However, I think you're better off using the common methods if you can and avoid using CAF unless you have a very good reason.

Details about CAF can be found in the DB2 Application and Programming Guide following the Quick Manuals link.
Back to top
View user's profile Send private message
me_naveen
Beginner


Joined: 21 Dec 2007
Posts: 23
Topics: 12

PostPosted: Tue Jul 08, 2008 1:59 am    Post subject: Reply with quote

Hi

Actually I need to call a db2 program(PGM1) but it must be under a different name with a copy of "PARMMVS LNK.IN INCLUDE SYSLIB (DSNHLI)" are used. so that is the reason I would like to go for DSNHLI calls.
But as per prebvious reply I could use CAF.
I have gone through the DB2 Application and Programming Guide but I am not quite clear how to use exactly.

Could you please help me out to solve my problem. DB2 version in my site is v7.2.

Thanks,
Nav
Back to top
View user's profile Send private message
dbzTHEdinosauer
Supermod


Joined: 20 Oct 2006
Posts: 1411
Topics: 26
Location: germany

PostPosted: Tue Jul 08, 2008 4:46 am    Post subject: Reply with quote

what you want to do is somewhat non-standard......... never had to make this kind of CALL in 30 years.

Quote:

Actually I need to call a db2 program(PGM1)


from where are you CALLing pgm1? is this ims or dli or something. cics? batch?
what reason must you make direct db2 calls and not use the api? is this a stored proc? what are you doing. I would have assumed that you could see that few understood what you want. Provide some more details.
_________________
Dick Brenholtz
American living in Varel, Germany
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Database All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group