Tue, 01/08/2013 – 20:13 #1 test jcl for errors There was a job you could run that would thoroughly test jcl without running and it wasnt typrun=scan – what is it? Click the +1 button  below to share it with your friends and colleagues Share this if you liked it! Disclaimer
test jcl for errors Read More »
SQL CODE -205  This sql code is returned when the sql statement uses a column name which does not belong to the table. Click the +1 button  below to share it with your friends and colleagues Share this if you liked it! Disclaimer
SQL CODE -105 This sql error comes when the string used in the statement is invalid. You may need to check the correct format of the string type and then use  the proper string format.c Click the +1 button  below to share it with your friends and colleagues Share this if you liked it! Disclaimer
SQL CODE -102 The sql statement is using a string literal which has exceeded the limit defined for that string type. Most of the strings have a limit defined for their length. Click the +1 button  below to share it with your friends and colleagues Share this if you liked it! Disclaimer
Wed, 04/18/2012 – 19:04 #1 How a data in physical and symbolic map gets treated Since the physical map is much concerned about the screen alignment and the field positions, how the values entered in the field which has PICIN or PICOUT clause in Physical map gets treated? Does that mean datas recieved or sent
How a data in physical and symbolic map gets treated Read More »
Fri, 06/17/2011 – 18:11 #1 How to concatenate strings in Ezytrieve How to concatenate strings in Ezytrieve? Its urgent, can some one provide an example of concatenating two strings in Eazytrieve. I am trying to create a Job using Eazytrieve and I need this badly Thanks!! Prabhat “; ; ; ; Click the +1 button
How to concatenate strings in Ezytrieve Read More »
Fri, 12/16/2011 – 06:12 #1 FTP target file with date and time qualifier I am trying to ftp a file from mainframe to wintel server, I am using a JCL to transfer the file. The requirement is to have name of the target file unique each time transfer occurs, for this I plan to append
FTP target file with date and time qualifier Read More »
Fri, 07/08/2011 – 19:47 #1 Easytrieve equivalent of S9(7)V99 Comp-3 in COBOL I have a file which is prepared by a COBOL program and which contains packed data. Packed data is not in readable format, so for sending the report to client I need it converted to readable format. I want to write an easytrieve to convert this
Easytrieve equivalent of S9(7)V99 Comp-3 in COBOL Read More »
Tue, 11/08/2011 – 08:26 #1 Difference between Include and Jcllib Can someone let me know the difference between the include and JCLLIB statements in JCL? Thanks “; ; ; ; Click the +1 button  below to share it with your friends and colleagues Share this if you liked it! Disclaimer
Difference between Include and Jcllib Read More »
Thu, 12/01/2011 – 11:28 #1 Delete few records from a flat file I have a flat file and I wish to delete few records from the file. I need to delete every 2nd record from the file. For eg Input file 1 2 3 4 5 6 7 8 Output file 1 3 5 7
Delete few records from a flat file Read More »
