Mainframe saves various details against a member or physical sequential file like version, user, create date etc. These details can however be changed by the following methods 1. Using the Rexx code /* rexx */                                              dsname     = “USERID.ABC.XYZ” /* Work PDS   */                             usrid           = “USER1”   /* User id to be updated in the […]
Wildcard character underscore in DB2
Wildcard character _ in DB2 Wild card character _ (underscore) is used to substitute exactly one character in a DB2 query. If you wish to fetch data from a DB2 table and you do not know what is the exact value in the column but you remember all the chars except one character somewhere in
Wildcard character underscore in DB2 Read More »
Transferring Data from Spool to a Dataset
Transferring Data from Spool to a Dataset Many a times we need the data sitting in spool to be transferred to a dataset. We might be researching on that data or the client might be looking for that data. To take care of such requests we can make use of any of the two approaches
Transferring Data from Spool to a Dataset Read More »
Synonym of DB2 Table
Synonyms are used to give some meaningful (alternate) names to the existing tables. These can refer tables which are local to the system, these can not access the remote tables. If a table is dropped then all the associated synonyms are dropped automatically. How to Create Synonym on a DB2 Table? CREATE SYNONYM synonym_name FOR
Synonym of DB2 Table Read More »
Rexx to Save in View Mode
REXX TO SAVE A MEMBER OF PDS IN VIEW MODE The following REXX code can be used to save a member in VIEW mode. Although you can save a member using ISPF commands while viewing the datasets also (refer Saving in View Mode) ; ; ; ; “ISPEXEC CONTROL ERRORS RETURN”     Â
Rexx to Save in View Mode Read More »
How to retrieve the last command issue
How to retrieve the last command issue? You can issue the following command to retrieve the last commands that has been issued The above command will retrieve the last command and put it on the command line so that you can execute it again. You can assign this command to any PF key so that
How to retrieve the last command issue Read More »
How to assign a PF Key to a command
How to assign a PF Key to a command? Use the following steps to assign a PF Key to a command line command Step3: In the Keylist utility panel provide the command name against the key you wish to use. Prefer using Keys which have not been assigned yet. Now if you press the key
How to assign a PF Key to a command Read More »
Clist to Tag COBOL code
CLIST TO TAG COBOL CODE AT 73-82 COLS ISREDIT MACRO (PARM1) NOPROCESS Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â ISPEXEC CONTROL ERRORS RETURN Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â
Clist to Tag COBOL code Read More »
DIFFERENCE BETWEEN STRING and MOVE
DIFFERENCE BETWEEN STRING and MOVE The following COBOL program depicts the use of difference between STRING and MOVE command     01 WS-STRING1   PIC X(19) VALUE ‘MAINFRAMEWIZARD.COM’.     01 WS-STRING2   PIC X(19) VALUE ‘MAINFRAMEWIZARD.COM’.        MOVE  ‘COBOLLANG’ TO WS-STRING1       Â
DIFFERENCE BETWEEN STRING and MOVE Read More »
Changing Long strings Have you faced a situation where the string that you wish to changedoes not fit the command line? If the answer is Yes then you may beinterested in the following tipMy command line looks like belowCOMMAND ==> ____________________________________________________and I have to execute the following commandCHANGE A_VERY_VERY_VERY_VERY_LONNNNNNNNNNNNNNNNNNG_STRING TO A_NEW_STRINGThe above command is too