View previous topic :: View next topic
|
Author |
Message |
shuklas
New User
Joined: 21 Dec 2006 Posts: 20 Location: London
|
|
|
|
Hi,
I am facing a problem in repeating the record some 'n' number of times by incrementing a field value which is packed decimal of 8 in length,
when i give a 15 digit number it is giving me
ICE000I 1 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R5 - 11:24 ON
OPTION COPY
OUTFIL OVERLAY=(1:SEQNUM,8,PD,START=100000000000000,INCR=1),
?
ICE008A 0 FIELD OR VALUE EXCEEDS MAXIMUM ALLOWABLE CHARACTERS
REPEAT=10
?
But packed decimal can store 15 digit in it.
and my requirement is that for 15 digit only.Please help me out and tell me how this can be done. |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
The sort manual says:
Quote: |
j specifies the starting value. The value for j must be between 0 and 100000000000. The default for j is 1. |
But you need:
Quote: |
OUTFIL OVERLAY=(1:SEQNUM,8,PD,START=100000000000000,INCR=1) |
Do you expect the number of records to get large enough to be larger than sort's 100000000000?
If not, could you do something like this:
Quote: |
OUTFIL OVERLAY=(1:x'1000',3:SEQNUM,6,PD,START=0,INCR=1) |
? |
|
Back to top |
|
|
shuklas
New User
Joined: 21 Dec 2006 Posts: 20 Location: London
|
|
|
|
Hi William,
My requirement is that we have to start from 100000000000000 or any 15 digit number is there any alternative that can be used. |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
shuklas wrote: |
My requirement is that we have to start from 100000000000000 or any 15 digit number is there any alternative that can be used. |
I kind of figured that out, the question is will the sequence number ever get bigger than 11 digits?
If not. the top 4 digits can be emulated by a two byte hex '1000'. |
|
Back to top |
|
|
shuklas
New User
Joined: 21 Dec 2006 Posts: 20 Location: London
|
|
|
|
Thanks William,
That works for me, now even i am happy. |
|
Back to top |
|
|
|