Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Syntax for binding a COBOL program to an UDB

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> TSO/ISPF
View previous topic :: :: View next topic  
Author Message
twissi

Active User


Joined: 01 Aug 2005
Posts: 105
Location: Somerset, NJ

PostPosted: Mon Aug 01, 2005 6:29 pm    Post subject: Syntax for binding a COBOL program to an UDB
Reply with quote

Hello Friends,

Can any one give me the syntax for binding a COBOL program to an UDB. I'm provided with only the database name and the server name. The UDB is on a UNIX server

Thanks in advance,
Cheers, Twissi.
Back to top
View user's profile Send private message

twissi

Active User


Joined: 01 Aug 2005
Posts: 105
Location: Somerset, NJ

PostPosted: Tue Apr 11, 2006 6:44 pm    Post subject:
Reply with quote

Hello all,

I found it myself !!

You need to have a PACKAGE-PLAN bind, here is the syntax:

//*
//* PACKAGE BIND
//*
//DB2BIND1 EXEC PGM=IKJEFT01,DYNAMNBR=40
//STEPLIB DD DSN=SYS1.DSNDSNC.SDSNLOAD,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//DBRMLIB DD DISP=SHR,DSN= ----------------> your DBRMLIB
//SYSIN DD DUMMY
//SYSTSIN DD *
DSN SYSTEM (DSNC)
BIND PACKAGE (XXXXXX.CCSPACK) -
MEMBER (PGM) -
OWNER (CCSUPDT) -
ACTION (REPLACE) -
VALIDATE (BIND) -
ISOLATION (CS) -
CURRENTDATA (NO) -
DEGREE (ANY) -
RELEASE (COMMIT) -
EXPLAIN (NO)
END
/*
//*
//* PLAN BIND
//*
//DB2BIND2 EXEC PGM=IKJEFT01,DYNAMNBR=40,COND=(0,NE)
//STEPLIB DD DSN=SYS1.DSNDSNC.SDSNLOAD,DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSTSPRT DD SYSOUT=*
//SYSIN DD DUMMY
//SYSTSIN DD *
DSN SYSTEM (DSNC)
BIND PLAN (PLANNAME) - ---------------------> Your PLAN NAME
PKLIST (XXXXXX.CCSPACK.*) - XXXXXX = your database name on UDB
ACTION (REPLACE) -
RETAIN -
ISOLATION (CS) -
CURRENTSERVER(SERVERNM) - --------------> your servername
CURRENTDATA (NO)
END
/*
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 -> TSO/ISPF All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts KSDS and Index file in cobol deepak14450 COBOL Programming 9 Fri Dec 22, 2017 9:36 am
No new posts The same REXX program doesnt work for... jackzhang75 CLIST & REXX 5 Wed Dec 06, 2017 2:51 am
This topic is locked: you cannot edit posts or make replies. Cobol to fetch the content by using s... arunc55 COBOL Programming 4 Fri Nov 17, 2017 1:25 pm
No new posts Calling IKJEFT01 program from Rexx upendrasri CLIST & REXX 8 Wed Nov 15, 2017 4:27 pm
No new posts VBS and VB, COBOL syntax is the same ... natt.sut COBOL Programming 3 Sun Nov 12, 2017 6:36 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us