Search found 22 matches
- Sat Nov 13, 2010 5:44 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Select Group based on detail record condition
- Replies: 2
- Views: 4718
- Sat Nov 13, 2010 2:54 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Select Group based on detail record condition
- Replies: 2
- Views: 4718
Select Group based on detail record condition
My requirement is to exclude a group from an XML file if the group contain error values in one of the detail record. Details given below File Format : FB Record length : 32000 Group starts with value 'RFH' in position 1-3 and ends with the value </BookingsCreate></ns0:MT_BookingsCreate> in position ...
- Fri Oct 08, 2010 12:33 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Question on FINDREP and ALTSEQ
- Replies: 2
- Views: 6481
- Thu Oct 07, 2010 3:57 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Question on FINDREP and ALTSEQ
- Replies: 2
- Views: 6481
Question on FINDREP and ALTSEQ
My requirement is to replace the hexadecimal character a) X'6B' with X'4B' between the positions 106-174 of the input file b) X'4A' with X'40' between positions 63-92 of the input file I tried initially using ALTSEQ shown below and not getting the correct result and it seems the character X'6B' foun...
- Wed Aug 04, 2010 2:43 am
- Forum: ENDEVOR, COOLGEN , PANVALET and CA-7
- Topic: CA7 Queue Structure.
- Replies: 5
- Views: 9762
- Fri Jul 30, 2010 12:09 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Help in Multiplcation of decimal constant
- Replies: 4
- Views: 9535
- Thu Jul 29, 2010 4:33 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Help in Multiplcation of decimal constant
- Replies: 4
- Views: 9535
- Thu Jul 29, 2010 4:12 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Help in Multiplcation of decimal constant
- Replies: 4
- Views: 9535
Help in Multiplcation of decimal constant
My requirement is to multiply a packed decimal field with a decimal constant 0.0256. The input file is of record length 80 and the packed decimal field is at position 54 of length 5. The multiplication output need to be stored at postion 81-85 Could you please help me to correct the following OUTREC...
- Fri Jul 23, 2010 9:15 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Find and Replace string with current Date
- Replies: 9
- Views: 16962
- Fri Jul 23, 2010 3:43 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Find and Replace string with current Date
- Replies: 9
- Views: 16962
Find and Replace string with current Date
My requirement is to replace the '########' string with current date in a SFTP control member. Input PWD ls -l get 'ETOLDAG_000003_########.csv' 'UGLXCD.EBAXMD.NETWORK.TEST' rename 'ETOLDAG_000003_########.csv' 'ETOLDAG_000003_########.csv.taken' quit Output PWD ls -l get 'ETOLDAG_000003_20100722.cs...
- Tue Mar 30, 2010 10:35 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Sort jcl - report writer queries using OUTREC
- Replies: 5
- Views: 16311
- Tue Mar 30, 2010 5:19 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Sort jcl - report writer queries using OUTREC
- Replies: 5
- Views: 16311
Thanks Frank for your Quick Response. Q1: The input file record format is FB and the LRECL is 110.It would be great if you can show me how to pass the date constant to Header2. Q2.Initially I was trying my requirement using DISPLAY operator of ICETOOL instead of SORT report writer. However I was not...
- Mon Mar 29, 2010 11:24 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Sort jcl - report writer queries using OUTREC
- Replies: 5
- Views: 16311
Sort jcl - report writer queries using OUTREC
I have the following questions relate to Sort reports Q1 I am using the following SORT to create a report. However the date is displayed as 29-03-2010 in the report. Instead my requirement is to display the date as 29-MAR-2010 in the report. Is there any date format that displays the month name ?. S...
- Wed Jan 27, 2010 11:45 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Search position of a string
- Replies: 1
- Views: 5907
Search position of a string
My requirement is to get the first starting position of a string (ZZZ) if it's found in a record. Similar to POS function used in REXX. I used the following jcl and getting the correct results. I feel the Sort JCL I used can be simplified to achieve the results in a better way. Appreciate if someone...
- Tue Jan 26, 2010 4:07 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Splitting record based on range
- Replies: 2
- Views: 6177