View previous topic :: View next topic |
Author |
Message |
naveen_kj Beginner

Joined: 03 Feb 2003 Posts: 18 Topics: 8 Location: India
|
Posted: Wed Feb 12, 2003 10:50 am Post subject: How to creating DCLGEN using a JCL |
|
|
Hi,
Can some one tell me how to create the DCLGEN (Declarations Generator - SQL table declarations and COBOL) using a JCL.
Any help is appreciated..
thanks |
|
Back to top |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12378 Topics: 75 Location: San Jose
|
Posted: Wed Feb 12, 2003 5:27 pm Post subject: |
|
|
Naveen,
The following JCl will give you the results.
Code: |
//STEP0100 EXEC PGM=IKJEFT01
//*
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(XXXX)
DCLGEN TABLE(TBLNAME) OWNER(OWNERNAME) ACTION(REP) -
LIBRARY('PDS(TBLNAME)')
END
//*
|
Hope this helps...
cheers
kolusu |
|
Back to top |
|
 |
naveen_kj Beginner

Joined: 03 Feb 2003 Posts: 18 Topics: 8 Location: India
|
Posted: Thu Feb 13, 2003 8:36 am Post subject: |
|
|
kolusu,
The JCL is working.
thanks,
Naveen |
|
Back to top |
|
 |
vallishar Beginner

Joined: 17 Dec 2002 Posts: 53 Topics: 14 Location: BengaLuru
|
Posted: Thu Feb 13, 2003 12:12 pm Post subject: |
|
|
Kolusu,
In the DCLGEN generated, can we add a prefix to each of the fields through the JCL ?
Regards, _________________ If you're not failing every now and again, it's a sign you're not doing anything very innovative. |
|
Back to top |
|
 |
Himesh CICS Forum Moderator

Joined: 20 Dec 2002 Posts: 80 Topics: 21 Location: Chicago
|
Posted: Thu Feb 13, 2003 11:26 pm Post subject: |
|
|
Vallish,
You could refer the following link
DCLGEN Syntax
regards,
Himesh |
|
Back to top |
|
 |
naveen_kj Beginner

Joined: 03 Feb 2003 Posts: 18 Topics: 8 Location: India
|
Posted: Fri Feb 14, 2003 5:35 am Post subject: |
|
|
Vallish,
The following JCl will add a prefix to each of the fields
Code: |
//STEP0100 EXEC PGM=IKJEFT01
//*
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(XXXX)
DCLGEN TABLE(TBLNAME) -
OWNER(OWNERNAME) -
ACTION(REPLACE) -
LIBRARY('PDS(TBLNAME)') -
LANGUAGE(XXXX) -
NAME(prefix name) -
COLSUFFIX(YES) -
STRUCTURE(XXXXXX) -
QUOTE
END
/*
|
Regards,
Naveen |
|
Back to top |
|
 |
|
|