Data transformation parameters (MJENGL75)


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.   
//                                                                                         

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*