Data transformation parameters (MJENGL75) (PTF BPF0457 applied)
The product distributes the following sample MJENGLEX member for transforming extracted data to CSV format:
//*- INSERT JOBCARD -
//*
//********************************************************************
//* CHANGE
//*
//* ?INPUTDSN? TO YOUR GENERATED OUTPUT OF MJENGLEX JCL
//* ?OUTPUTCSV? TO YOUR COMMA SEPARATED VALUE DATASET
//* ?BBLINK? TO YOUR MJE BBLINK
//* ?BBACTDEF? TO YOUR BBACTDEF WHERE MJFTDM RESIDES
//* ?BBSAMP? TO YOUR BBSAMP WHERE PRODUCT DATA MAPS RESIDES
//* ?BBMAP? TO YOUR BBMAP WHERE PRODUCT DATA MAPS RESIDES
//*
//********************************************************************
//*
//DELETE EXEC PGM=IEFBR14
//OUT1 DD DSN=?OUTPUTCSV?,DISP=(MOD,DELETE),
// SPACE=(CYL,(500,100),RLSE),UNIT=SYSDA,
// DCB=(LRECL=32000,BLKSIZE=32760,RECFM=VB,DSORG=PS)
//MD75 EXEC PGM=IKJEFT01,REGION=0M,PARM='BBM9MD75'
//STEPLIB DD DSN=?BBLINK?,DISP=SHR
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD DUMMY
//MD73IN DD DSN=?INPUTDSN?,DISP=SHR
//BBACTDEF DD DSN=?BBACTDEF?,DISP=SHR
//BBSAMP DD DSN=?BBSAMP?,DISP=SHR
//BBMAP DD DSN=?BBMAP?,DISP=SHR
//OUT1 DD DSN=?OUTPUTCSV?,DISP=(,CATLG),
// SPACE=(CYL,(500,100),RLSE),UNIT=SYSDA,
// DCB=(LRECL=32000,BLKSIZE=32760,RECFM=VB,DSORG=PS)
//SYSIN DD *
*YOU CAN FOLLOW THE SAME GUIDELINES FOR TRANSFORMING HISTORICAL DATA
*IN THIS DOCUMENTATION LINK: https://docs.bmc.com/docs/x/pi7qOQ
*
*EXAMPLE OF WRITING QUERY STATEMENT TO SELECT FEW COLUMNS OF NGL RECORDS
*USING THE DATA MAP FOR SMF123 API PROVIDER DETAIL DATA:
* SELECT S123JOB,S123STYPE,S123SYSN
* FROM MJFTDM.MJFUZCD0
* ;
*AFTER THIS LINE, WRITE YOUR QUERY STATEMENT.
//
//*
//********************************************************************
//* CHANGE
//*
//* ?INPUTDSN? TO YOUR GENERATED OUTPUT OF MJENGLEX JCL
//* ?OUTPUTCSV? TO YOUR COMMA SEPARATED VALUE DATASET
//* ?BBLINK? TO YOUR MJE BBLINK
//* ?BBACTDEF? TO YOUR BBACTDEF WHERE MJFTDM RESIDES
//* ?BBSAMP? TO YOUR BBSAMP WHERE PRODUCT DATA MAPS RESIDES
//* ?BBMAP? TO YOUR BBMAP WHERE PRODUCT DATA MAPS RESIDES
//*
//********************************************************************
//*
//DELETE EXEC PGM=IEFBR14
//OUT1 DD DSN=?OUTPUTCSV?,DISP=(MOD,DELETE),
// SPACE=(CYL,(500,100),RLSE),UNIT=SYSDA,
// DCB=(LRECL=32000,BLKSIZE=32760,RECFM=VB,DSORG=PS)
//MD75 EXEC PGM=IKJEFT01,REGION=0M,PARM='BBM9MD75'
//STEPLIB DD DSN=?BBLINK?,DISP=SHR
//SYSTSPRT DD SYSOUT=*
//SYSTSIN DD DUMMY
//MD73IN DD DSN=?INPUTDSN?,DISP=SHR
//BBACTDEF DD DSN=?BBACTDEF?,DISP=SHR
//BBSAMP DD DSN=?BBSAMP?,DISP=SHR
//BBMAP DD DSN=?BBMAP?,DISP=SHR
//OUT1 DD DSN=?OUTPUTCSV?,DISP=(,CATLG),
// SPACE=(CYL,(500,100),RLSE),UNIT=SYSDA,
// DCB=(LRECL=32000,BLKSIZE=32760,RECFM=VB,DSORG=PS)
//SYSIN DD *
*YOU CAN FOLLOW THE SAME GUIDELINES FOR TRANSFORMING HISTORICAL DATA
*IN THIS DOCUMENTATION LINK: https://docs.bmc.com/docs/x/pi7qOQ
*
*EXAMPLE OF WRITING QUERY STATEMENT TO SELECT FEW COLUMNS OF NGL RECORDS
*USING THE DATA MAP FOR SMF123 API PROVIDER DETAIL DATA:
* SELECT S123JOB,S123STYPE,S123SYSN
* FROM MJFTDM.MJFUZCD0
* ;
*AFTER THIS LINE, WRITE YOUR QUERY STATEMENT.
//
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*