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
 

 

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
This topic is locked: you cannot edit posts or make replies. Cobol GUI (like Editor) Kala Mainframe COBOL Programming 14 Wed May 10, 2017 12:30 pm
No new posts IMS T-Pipe queue counts in a COBOL Pr... Siva NKK Kothamasu IMS DB/DC 0 Tue May 09, 2017 6:31 pm
No new posts COBOL Code Parsers and Lineage Establ... balimanja COBOL Programming 2 Tue May 02, 2017 3:30 am
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts Need help in REXX CALL program Raje1002 CLIST & REXX 5 Wed Apr 19, 2017 11:18 pm


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