Search found 10 matches

by sahiljethi
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...
by sahiljethi
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 ...
by sahiljethi
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 :lol:
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"
by sahiljethi
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...
by sahiljethi
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...
by sahiljethi
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)...
by sahiljethi
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...
by sahiljethi
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...
by sahiljethi
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

Thanks Anuj, It helped a Lot :)

But can u also explain me the SORT CARD...especially

OUTFIL REMOVECC,NODETAIL,
SECTIONS=(1,4,
TRAILER3=(1,5,TOT=(6,3,UFF,EDIT=(TTT))))

I wanted to understand the parameters in Section & TRAILER3.
by sahiljethi
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...