zDCLGEN README
zDCLGEN extension allows a user to generate a DCLGEN declaration for a table of view defined in DB2.
The copybook wil be generated running a job with a IKJEFT01 step with the instructions to create the DCLGENcopybook.
Features
From zowe explorer a view with the necessary fields to allow a job tha running the programa IKJEFT01 to generate a DCLGEN.
| Fields |
Description |
| Source Table/View |
The full table/view name |
| Table/View Owner |
The table/view owner |
| Dataset Name |
The full destination data set name example: user.lib.copybook(copybool) |
| Action |
ADD new or REPLACE old declaration |
| Structure |
Level 01 definition case different from standard |
| Field Name Prefix |
Prefix to be included to every field |
| Language |
Programing language |
| Column suffix |
true/false add column suffix |
Job definition
//${jobname} JOB ,'DCLGEN',MSGCLASS=${MsgClass},CLASS=${Class}
//****************************************
//DCLGEN EXEC PGM=IKJEFT01,DYNAMNBR=20
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD *
DSN SYSTEM(${System})
DCLGEN -
TABLE(${Table}) -
OWNER(${Owner}) -
LIBRARY(${Library}) -
ACTION(${Action}) -
NAME(${Name}) -
COLSUFFIX(${ColumnSuffix}) -
LANGUAGE(${Language}) -
STRUCTURE(${Structure}) -
QUOTE
/*
Requirements
- VS Code installed.
- Zowe explorer extension installed.
Recommendations
- Ibm Z Open Editor installed.
Extension Settings
This extension contributes the following settings:
zDclgen.JobCard.JobName: Name to be used in the definition in the definition of both jcl to convert csv files to flat files.
zDclgen.JobCard.Class: Class to be included in the Job Card.\nExemple: CLASS=X.
- min length: 1;
- max length: 1;
zDclgen.JobCard.MsgClass: Message Class to be included in the Job Card.\nExemple: MSGCLASS=X.
- min length: 1;
- max length: 1;
zDclgen.DB2.System: DB2 system definition to be included in the jcl.zDclgen.DB2.SourceTable/View: Last Source Table/View used to generate a DCLGEN
zDclgen.DB2.Table/ViewOwner: Last Table/View Owner used to generate a DCLGEN
zDclgen.DB2.DatasetName: Last Library used to generate a DCLGEN
zDclgen.DB2.Action: Last Action used to generate a DCLGEN
- max length: 7;
- Possible values: ["Add", "Replace"]
zDclgen.DB2.FieldNamePrefix: Last Name used to generate a DCLGEN
zDclgen.DB2.Language: Last Language used to generate a DCLGEN
- max length: 18;
- Possible values: ["IBMCob", "PLI", "Cobol", "Cob2"]
zDclgen.DB2.ColumnSuffix: Last Column Suffix used to generate a DCLGEN
"default": falsezDclgen.DB2.StructureName Last Structure Name used to generate a DCLGEN
Known Issues
n/a
Release Notes
1.0.0
Initial release of zDCLGEN
| |
