We will explore few more common uses of OUTREC with examples below 1 . Inserting Zeros, Spaces and Character strings to your output You can insert blanks before, between, or after fields. You can use X or 1X to specify a single blank. You can use nX to specify n blanks.To insert 10 blanks, write 10X […]
Reformatting Records Using OUTREC – Part 1
Though OUTREC is one of the most frequently used features of DFSORT, many still find a SORT cards with OUTREC FIELDS=(21:106,4,35:1,75) confusing . We will try to explore the many uses of OUTREC in this article with some examples . OUTREC gives you the flexibility to reformat your output file in multiple ways . […]
How to create test files for SORT
Looking to learn SORT ? , you are definitely going to need some input files to test your SORT card , the good news is that you need to have to create them manually . IBM provides you with a JCL which would create 3 test file with different kinds of data types that you […]
DB2 Multi Row Fetch
Multi row fetch is one of the most powerful features of DB2 V8, which can give significant performance improvements to of your DB2 application. So what is multi row fetch or MRF , as the name suggests it simply mean fetching multiple rows at a time using your cursor. When you use a […]
COBOL program using VSAM ESDS
An ESDS VSAM file is very similar to a flat file, as with a flat file the access mode is sequential and the file control section would look very similar to that of a flat file if the ESDS file is of fixed length with both ORGANIZATION and ACCESS MODE being SEQUENTIAL. […]
How to Encrypt Data using DB2
Thought most of us who are working, as application programmer may never use this feature of DB2 at a program level it is an interesting upgrade in DB2 V8 and is worth understanding. DB2 provides encryption and decryption of data at a column level and provides a number of built in functions to facilitate this. […]
IMS Status Code Quick Refrence
A quick look up guide for IMS Status code and associated DLI calls IMS_Status_Code_Quick_Refrence
How to submit your Mainframe Job from windows
You can submit any mainframe JCL from your desktop using just a few FTP commands, to do so follow the below steps. To submit a mainframe job first you need to establish connectivity with your mainframe, to do this type the below command from your command prompt in windows C:\>ftp ftp> OPEN xx.xxx.x.xxx (mainframe […]