Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Ops Monitor for Java Environments 4.1.

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

 

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