Author |
Message |
Topic: Removing leading zeroes |
sushma4satya
Replies: 9
Views: 5543
|
Forum: Utilities Posted: Wed Apr 30, 2008 10:20 am Subject: Removing leading zeroes |
Thanks Kolusu..this helped me. |
Topic: Removing leading zeroes |
sushma4satya
Replies: 9
Views: 5543
|
Forum: Utilities Posted: Tue Apr 29, 2008 3:20 pm Subject: Removing leading zeroes |
The only condition we have is if first 4 bytes in i/p has zeroes then we need to suppress the first leading zero for all other cases then we should not disturb that field.
i/p:
0000107139
0000 ... |
Topic: Removing leading zeroes |
sushma4satya
Replies: 9
Views: 5543
|
Forum: Utilities Posted: Tue Apr 29, 2008 1:56 pm Subject: Removing leading zeroes |
Thanks Kolusu.
One more question.
If my i/p file has :
0000107139
0000107139
000107666A
000107666A
I need o/p as :
000107139 ( Should suppress first leading zero if i/p rec has 4 ... |
Topic: Removing leading zeroes |
sushma4satya
Replies: 9
Views: 5543
|
Forum: Utilities Posted: Mon Apr 28, 2008 3:15 pm Subject: Removing leading zeroes |
Kolusu,
I used the below code for the below records.
0000107218
0000107768
0000107768
0000107652
0000107652
Iam getting the output as
17218
17768
17768
17652
17652
but i expected the ... |
Topic: Find and replace |
sushma4satya
Replies: 2
Views: 1991
|
Forum: Job Control Language(JCL) Posted: Wed Feb 28, 2007 10:51 pm Subject: Find and replace |
Kolusu,
Thanks so much...it worked .
Satya |
Topic: Find and replace |
sushma4satya
Replies: 2
Views: 1991
|
Forum: Job Control Language(JCL) Posted: Wed Feb 28, 2007 5:16 pm Subject: Find and replace |
File looks like below :
------------------------------------------------------------------------------
AAAAAAAA 2006-09-01 XXXXXXXXXX 001 000
BBBBBBBB 2006-06-01 XXXXXXXXXX ... |
Topic: Copy the contents of file2 - file2 is in file1 |
sushma4satya
Replies: 3
Views: 1952
|
Forum: Job Control Language(JCL) Posted: Mon Feb 12, 2007 8:46 pm Subject: Copy the contents of file2 - file2 is in file1 |
It worked perfectly. thanks much.
Can you explain me in detail the below 2 statements
ALTSEQ CODE=(7D40,4D40,5D40)
OUTREC FIELDS=(01,80,TRAN=ALTSEQ)
Satya  |
Topic: Copy the contents of file2 - file2 is in file1 |
sushma4satya
Replies: 3
Views: 1952
|
Forum: Job Control Language(JCL) Posted: Fri Feb 09, 2007 10:48 pm Subject: Copy the contents of file2 - file2 is in file1 |
1)I have file1 : TESTGHN.H0307.LISTC.OUTPUT.T1
The contents of the file1 looks as below
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
LISTC - ... |
Topic: Merge 2 files with a single header using SORT |
sushma4satya
Replies: 5
Views: 2286
|
Forum: Job Control Language(JCL) Posted: Mon Feb 13, 2006 5:21 pm Subject: Merge 2 files with a single header using SORT |
Thanks Kolusu,its working perfectly .
Iam curious to learn about :
OMIT COND=(1,3,SS,EQ,C'HDR,TRL')
SORT FIELDS=COPY
OUTFIL REMOVECC, ... |
Topic: Merge 2 files with a single header using SORT |
sushma4satya
Replies: 5
Views: 2286
|
Forum: Job Control Language(JCL) Posted: Mon Feb 13, 2006 2:06 pm Subject: Merge 2 files with a single header using SORT |
Thanks Kolusu for immediate reply
1. I need HDR followed by current date for header
2. I don't want to sort the file. |
Topic: Merge 2 files with a single header using SORT |
sushma4satya
Replies: 5
Views: 2286
|
Forum: Job Control Language(JCL) Posted: Mon Feb 13, 2006 1:06 pm Subject: Merge 2 files with a single header using SORT |
I have a 2 input files of LRECL =200
Merged out file with header : LRECL = 200
File : 1
HDR20060214
AAAAAAA
BBBBBBB
CCCCCC
TRL20060214000003
File : 2
HDR20060214
DDDDD
EEEEEE
FFF ... |
Topic: ICETOOL - TO DROP MATCHING |
sushma4satya
Replies: 8
Views: 4872
|
Forum: Job Control Language(JCL) Posted: Thu Dec 08, 2005 10:58 am Subject: ICETOOL - TO DROP MATCHING |
Hi Kolusu,
We have searched the forum and took your solution from one of the post, here we are trying to tell you that creating dynamic INCLUDE doesn't support for more rows. We have tested the sam ... |
Topic: ICETOOL - TO DROP MATCHING |
sushma4satya
Replies: 8
Views: 4872
|
Forum: Job Control Language(JCL) Posted: Thu Dec 08, 2005 10:46 am Subject: ICETOOL - TO DROP MATCHING |
Here is the requirement :
Input File-1 --> LRECL = 150 RECFM=FB with 12000 records
Input File-2 --> LRECL = 150 RECFM=FB with 12000 records
Key --> 49-60 is the key in both t ... |
Topic: ICETOOL - TO DROP MATCHING |
sushma4satya
Replies: 8
Views: 4872
|
Forum: Job Control Language(JCL) Posted: Thu Dec 08, 2005 10:31 am Subject: ICETOOL - TO DROP MATCHING |
With reference to the previous posts to drop the matching field I used
the following JCL.
//R010 EXEC PGM=ICETOOL
//INPUT1 DD DSN=TESTMRN.MR0263.MR263. ... |
|