| Author |
Message |
Topic: Need help with formatting a field value |
akash_rgh
Replies: 1
Views: 1676
|
Forum: Utilities Posted: Fri Sep 04, 2015 6:39 am Subject: Need help with formatting a field value |
Hi
I am trying to parse a csv file as below :
Input :
aaa,6.5,ccc
sssss,0,hhh
ccc,1,fffff
hhhhh,12.45,jjjjjj
I am using :
OUTREC PARSE=(%01=(ENDBEFR=Cā,ā,FIXLEN=8),
... |
Topic: Wild card HLQs for files |
akash_rgh
Replies: 2
Views: 2220
|
Forum: Job Control Language(JCL) Posted: Wed Feb 10, 2010 3:44 am Subject: Wild card HLQs for files |
Hi,
I have a situation where I have few PS files( the count keeps changing)
to be sorted into one file.
The files follow a perticular naming convention.
for example :
ABC.DEF.Z1GH.IJ
ABC ... |
Topic: Need to generate a comparison report between two files |
akash_rgh
Replies: 7
Views: 4402
|
Forum: Utilities Posted: Fri Jan 02, 2009 3:27 am Subject: Need to generate a comparison report between two files |
yupp, it worked, Thanks a lot to both of you  |
Topic: Need to generate a comparison report between two files |
akash_rgh
Replies: 7
Views: 4402
|
Forum: Utilities Posted: Mon Dec 29, 2008 2:58 am Subject: Need to generate a comparison report between two files |
| In output file we will in third example we will have the special number under new special number column while the old one will remain blank. In my query above it looks like in old column. |
Topic: Need to generate a comparison report between two files |
akash_rgh
Replies: 7
Views: 4402
|
Forum: Utilities Posted: Mon Dec 29, 2008 2:55 am Subject: Need to generate a comparison report between two files |
Hi Kolusu,
Please find the details below :
1. LRECL 141 and RECFM =FB.
2. No duplicates possible for the combination of item number and class.
3. Item no 20 bytes
Class 2 ... |
Topic: Need to generate a comparison report between two files |
akash_rgh
Replies: 7
Views: 4402
|
Forum: Utilities Posted: Fri Dec 26, 2008 6:04 am Subject: Need to generate a comparison report between two files |
The combination of item number and class in first two columns makes a unique combinaition...
The output report tells whether the special number has got chnaged, added newly or deleted... |
Topic: Need to generate a comparison report between two files |
akash_rgh
Replies: 7
Views: 4402
|
Forum: Utilities Posted: Fri Dec 26, 2008 4:23 am Subject: Need to generate a comparison report between two files |
Hi,
I have two files :
FILE-1 :-
Item no Class colour special number manufacturer
--------------------------------------------------------
BC111 A Green 1234.12.1234 ABCD ... |
| |