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: 4712
- Sat Nov 13, 2010 2:54 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Select Group based on detail record condition
- Replies: 2
- Views: 4712
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: 6468
- Thu Oct 07, 2010 3:57 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Question on FINDREP and ALTSEQ
- Replies: 2
- Views: 6468
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: 9747
- Fri Jul 30, 2010 12:09 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Help in Multiplcation of decimal constant
- Replies: 4
- Views: 9519
- Thu Jul 29, 2010 4:33 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Help in Multiplcation of decimal constant
- Replies: 4
- Views: 9519
- Thu Jul 29, 2010 4:12 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Help in Multiplcation of decimal constant
- Replies: 4
- Views: 9519
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: 16951
- Fri Jul 23, 2010 3:43 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Find and Replace string with current Date
- Replies: 9
- Views: 16951
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: 16295
- Tue Mar 30, 2010 5:19 am
- Forum: DFSORT , ICETOOL & Utilities
- Topic: Sort jcl - report writer queries using OUTREC
- Replies: 5
- Views: 16295
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: 16295
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: 5893
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: 6170