IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Syntax for binding a COBOL program to an UDB


IBM Mainframe Forums -> TSO/ISPF
Post new topic   Reply to topic
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> TSO/ISPF

 


Similar Topics
Topic Forum Replies
No new posts Replace each space in cobol string wi... COBOL Programming 3
No new posts Using API Gateway from CICS program CICS 0
No new posts PARSE Syntax for not fix length word ... JCL & VSAM 7
No new posts COBOL -Linkage Section-Case Sensitive COBOL Programming 1
No new posts COBOL ZOS Web Enablement Toolkit HTTP... COBOL Programming 0
Search our Forums:

Back to Top