View previous topic :: View next topic
|
Author |
Message |
anandinmainframe
Active User
Joined: 31 May 2007 Posts: 171 Location: India
|
|
|
|
Hi,
i have an input file which has values from A to Z
and i am fetching a value through a cursor which has values from A to Z.
now if the one in the input is greater than the fetched one then i need that alphabet. |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
More information is needed, examples? code? anything beyond
Quote: |
i have an input file which has values from A to Z
and i am fetching a value through a cursor which has values from A to Z.
now if the one in the input is greater than the fetched one then i need that alphabet. |
would be helpful..... |
|
Back to top |
|
|
anandinmainframe
Active User
Joined: 31 May 2007 Posts: 171 Location: India
|
|
|
|
i have an input file
00000000000000000A00000000000000000
00000000000000000Z00000000000000000
00000000000000000W00000000000000000
like this and
i am using a DB2 cursor & i am fetching a value which has codes like A to Z
now i want to compare the one in the input file with the one i am fetching
if the i/p file has A and the one i fetched is B then i dont need it
if the i/p file has Z and the one i fetched is A then i need that value
where the value for A=1,B=2.......Z=26.
i hope this is clear |
|
Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
anandinmainframe wrote: |
i have an input file
Code: |
00000000000000000A00000000000000000
00000000000000000Z00000000000000000
00000000000000000W00000000000000000 |
like this and
i am using a DB2 cursor & i am fetching a value which has codes like A to Z
now i want to compare the one in the input file with the one i am fetching
if the i/p file has A and the one i fetched is B then i dont need it
if the i/p file has Z and the one i fetched is A then i need that value
where the value for A=1,B=2.......Z=26.
i hope this is clear |
If i/p > fetch then ignore.
If i/p < fetch then use.
The hex characters are have values, you don't need to convert them, unless you are trying to avoid the non alphabetic ones.... |
|
Back to top |
|
|
anandinmainframe
Active User
Joined: 31 May 2007 Posts: 171 Location: India
|
|
|
|
Hi All,
Thank you for your support
the issue is solved by using an internal table. |
|
Back to top |
|
|
|