Search found 10 matches
- Fri Mar 23, 2012 5:33 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: DFSORT - SUMMING while retaining records
- Replies: 1
- Views: 3484
DFSORT - SUMMING while retaining records
Hi, I have the following input extract: CODE AMOUNT ------------------ AAA050 BBB011 CCC010 DDD055 AAA020 AAA030 DDD020 Where code is first 3 Bytes & Amount Next 3 Bytes..TOTAL LENGTH 6 BYTES. I want the Output Extract as follows: AAA050 AAA030 AAA020 SUM100 BBB011 SUM011 CCC010 SUM010 DDD055 DDD020...
- Fri Dec 09, 2011 6:11 pm
- Forum: EASYTRIEVE
- Topic: Show Decimal Point in Output
- Replies: 1
- Views: 4934
Show Decimal Point in Output
Hi, Please NOTE the CODE BELOW: FILE OUTAUDIT FB(11 110) OUT-AMT 1 11 N 2 *--------------------WORKING STORAGE VARIABLES------------ WS-AMT W 11 N 2 *----------------------JOB STATEMENT----------------------------- JOB INPUT INAUDIT DISPLAY 'WS-AMT: ' WS-AMT OUT-AMT = WS-AMT GOTO JOB WS-AMT ...
- Fri Dec 09, 2011 4:13 pm
- Forum: EASYTRIEVE
- Topic: EASYTRIEVE ARRAY ISSUE
- Replies: 7
- Views: 18157
Thanks for ur help, I fixed the array issue by changing the array defination
http://code.xmlgadgets.com/2010/09/20/o ... asytrieve/
Please help me with "SPACES is not acceptable keyword in EASYTRIEVE....then how do we check whether an alphanumeric variable contains data or not"
http://code.xmlgadgets.com/2010/09/20/o ... asytrieve/
Please help me with "SPACES is not acceptable keyword in EASYTRIEVE....then how do we check whether an alphanumeric variable contains data or not"
- Fri Dec 09, 2011 1:46 pm
- Forum: EASYTRIEVE
- Topic: EASYTRIEVE ARRAY ISSUE
- Replies: 7
- Views: 18157
I did as you said; and turned out to be what u said "I suspect it will not be what you are expecting." MOVE IN-ARRAY TO WS-ARRAY - This only moved the first 35 bytes of In-ARRAY to WS-ARRAY; Please let me know what can be done for moving all the 1750 bytes to WS-ARRAY?? Also, I checked that SPACES i...
- Thu Dec 08, 2011 3:49 pm
- Forum: EASYTRIEVE
- Topic: EASYTRIEVE ARRAY ISSUE
- Replies: 7
- Views: 18157
Dikdude, This was the complete job, which i specified in my last post & actual input from my file. Input file has record length of 1750. I want to divide this data into parts of 35 bytes and display each part. After displaying the first part successfully, prog displays all other parts as spaces. Ple...
- Thu Dec 08, 2011 12:22 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: DFSORT - process array
- Replies: 3
- Views: 5589
Hi Frank, Please consider the input file with LRECL=80 having follwing 2 records: myname1 111030222040333050111080 myname2 444030555040666050111090 First 20 characters of record contains NAME: "myname1 " "myname2 " REST of the record contains reoccuring sequence of SUB_CODE(3 bytes) & MARKS(3 bytes)...
- Wed Dec 07, 2011 7:04 pm
- Forum: EASYTRIEVE
- Topic: EASYTRIEVE ARRAY ISSUE
- Replies: 7
- Views: 18157
EASYTRIEVE ARRAY ISSUE
Hi, I have a task, where I have to write the different occurances of an array in an output file. I have written a loop to read through all occurances of array. But my program is only displaying the first instance correctly, all other instances of array are appearing as spaces. Please help me!!!! FIL...
- Wed Dec 07, 2011 12:13 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: DFSORT - process array
- Replies: 3
- Views: 5589
DFSORT - process array
Hi, I have an input file with following structure: 10 Name x(20) 01 ARRAY occurs 10 times 02 SUB_CODE x(3) 02 SUB_MARKS 9(3) I have to extract an output file containing the name,sub code, total marks where SUB_CODE = '111'. Each Input records can have multiple occurances of SUB_CODE='111'. Please le...
- Fri Nov 25, 2011 1:10 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: ICETOOL - Compute SUM of Repetative Fields in a file
- Replies: 3
- Views: 5419
- Fri Nov 25, 2011 12:08 pm
- Forum: DFSORT , ICETOOL & Utilities
- Topic: ICETOOL - Compute SUM of Repetative Fields in a file
- Replies: 3
- Views: 5419
ICETOOL - Compute SUM of Repetative Fields in a file
Hi, I have an input file with following structure: Emp# Amount ------- ---------- emp1 500 emp1 200 emp2 300 emp3 100 emp3 20 emp3 500 I want my output file to Sum the amounts of Emp# which are repeating. File is sorted on EMP# field. Structure of output file: Emp# Amount ------- ---------- emp1 700...