Overriding Concatenated Datasets in JCL Lets assume that you have a PROC with the following step which has 5 concatenated steps. //STEP010 EXEC PGM=PROGRAM1 //INPUTF DD …
DB2 9 Family Fundamentals(000-730) - Q & A Read and Download several question and answers for the IBM DB2 9 certification exam. Section 1 - Planning (14%) Knowledge of restricting …
Replacing low values to spaces in Mainframe Sort In Mainframe, using Sort, how can I replace all the low-values in a file to spaces? We can use ALTSEQ CODE to change the low-values or …
COBOL Code Optimization To assist in the optimization of the code, you should use the OPTIMIZE compiler option. With the OPTIMIZE(STD) or OPTIMIZE(FULL) options in …
ARITH Compiler Option in COBOL ARITH affects the maximum number of digits that you can code for integers, and the number of digits used in fixed-point intermediate …
Converting a file from VB to FB. DFSORT can be used to do VB to FB conversion, when sorting, copying or merging. The VTOF or CONVERT and OUTREC operands of OUTFIL can be …
Recovering Deleted Flat Files in Mainframe Flat files can be recovered by following the below mentioned steps. Start 6 HLIST BCDS DSN(‘filename’) Wait for the system notification Type …
AUTOTYPE Suggestion How wonderful it feels when Internet explorer suggests names for URLs when we start typing the first few letters! Our mainframe also has the …
Options on DECLARE CURSOR Use FOR READ/FETCH ONLY or WITH UR for retrieval only cursors. Use OPTIMIZE when you know the accurate number of rows that will be fetched …
Useful List of SYSIBM tables SYSCHECKDEP Column references for CHECK constraints SYSCHECKS CHECK constraint specifications SYSCHECKS2 (V7) Information about CHECK …
GDG - A Basic Introduction Introduction GDG stands for Generation Data Group. Here a group of files are related functionally or chronologically and can be accessed …
Ranking and Numbering for Records in DB2 DB2 supports ranking and numbering in much the same way that Oracle does. The available functions are: ROW_NUMBER(), which simply numbers …
Selecting first few rows in DB2 DB2’s method of performing a Top-N query is the FETCH FIRST clause. You can append these variations to a regular SELECT query: FETCH FIRST …
INSPECT in COBOL The INSPECT verb has two options, TALLYING and REPLACING. You can do one or the other or both. If both are done, the TALLYING IS DONE BEFORE …
ISPF Special Searching A picture string in a FIND, CHANGE, or EXCLUDE command allows you to search for a particular kind of character without regard for the …
TIME=NOLIMIT and TIME=MAXIMUM We can specify the max limit of TIME parameter as TIME=NOLIMIT TIME=MAXIMUM Now which specification gives maximum time for a JOB? …
Run a step only from a set of steps in a job I have a JCL with 20 steps. Due to some reasons I want to execute the step 15 only. One way to do it is to use RESTART from STEP15, but it …
DB2 Index with Expressions Prior to DB2 9, the create index statement only allowed you to use the column name from the table the index is being built on. The same …
Run a Program using Referback It is possible to execute a program from any library using the referback feature. STEP1 EXEC PGM=IEFBR14 //PROGRAM DD …
Like the DB2 LIKE The LIKE phrase defines a mask for comparing characters: WHERE COL_VAL [NOT] LIKE mask A mask may be a host variable or a literal enclosed …
Handling NULL in DB2 The value of an indicator variable tells the status of a row after a query. Host Variable: 01 FILLER. 05 WS-AMOUNT PIC S9(5)V9(2) COMP-3. 05 …
Isolation level in DB2 The list of isoloation leves are listed below. SERIALIZABLE(Repeatable read (RR)) REPEATABLE READ(Read stability (RS)) READ COMMITTED(Cursor …
Freezing columns in File-Aid While working in MS Excel we have the option of “Freeze Panes”. By this options we can freeze some columns and have other columns scrolling. …
Read Only VSM Files By using INHIBIT along with ALTER command, we can have a read-only VSAM dataset. Example: //STEP1 EXEC PGM=IDCAMS //SYSPRINT DD SYSOUT=* …
TSQ Vs. TDQ In Temporary Storage Queues Data is read randomly, while in Transient Data Queues data must be read sequentially. In a TSQ data can be read …
Find bad data using File-Aid The Easiest and Coolest way to locate bad data is thru File-Aid’s FIND command. OPEN the file in FILE-AID (in either browse or edit mode). …
Points to Ponder on DB2 NULL NULLs can present problems because they are handled differently by different computers and the collating sequence is inconsistent with …
Explanation on DB2 Explain When an SQL is executed against or bound to a DB2 database, DB2 Optimizer tool defines the access path used to access the data. This access …
Appending to ISPF Clipboard Scenario: I have a dataset with 10,000 lines. I want to cut the first 10 lines and last 10 lines and paste into another dataset. When I cut …
Viewing Mainframe ISPF Clipboard When I issue CUT , I know that the CUT content are placed in a clipboard. And when I issue PASTE, the clipboard content are pasted. But is …
Changing the Create or Update User ID in Mainframe Usually the PDS or PS bears the ID of the creator or the ID of the person who modified it recently. It’s possible to change these ID values …
Repeating the ISPF command without typing again Any command entered in the ISPF COMMAND LINE disappears after the successful execution of its intended function. If you want to repeat the …
Verification of DB2 Consistency token When a Job abends at a program due to bind error with SQL code of -805 or -818 then generally there is issue with consistency token (often …
Filtering Jobs in Spool There is a possibility to list only the jobs which has ABENDED, leaving out all other jobs in the spool. For such a kind of listing, use the …
Rearrage SDSF Columns If you want to rearrange the columns in SDSF. Go to SDSF;ST. In command line type “arr ?”. This will bring the complete list of SDSF column …
Change uppercase to lowercase or lowercase to uppercase in Sort Translation features of INREC, OUTREC and OUTFIL make it easy to change the case of characters in your fields. The TRAN=LTOU operand can be …
Easy & Fast Editing of PDS using File-Aid Projects do testing of their code multiple times before they move their code to production. Once the test JCLs are created. From the second …
Add leading and trailing Characters in Sort Lets assume that we have a sequential dataset with records as below: ONE TWO THREE FOUR FIVE I want to reformat the records for output as …
