View previous topic :: View next topic
|
Author |
Message |
Deepthy Jose P
New User
Joined: 07 Mar 2007 Posts: 40 Location: India
|
|
|
|
In SELCOPY inline command how can i compare a date field which is declared as text(alphanumeric) in a file with a constent date field
e.g IF POS 10 LT '01052010' |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
SELCOPY is a 3rd Party tool,
and not an IBM product.
Here is the SELCOPY Homepage.
manuals, tutorials, FAQs (among other things) are found there. |
|
Back to top |
|
|
Deepthy Jose P
New User
Joined: 07 Mar 2007 Posts: 40 Location: India
|
|
|
|
thanks Dick |
|
Back to top |
|
|
David Robinson
Active User
Joined: 21 Dec 2011 Posts: 199 Location: UK
|
|
|
|
IIRC (we don't have Selcopy at this site) you don't decalre fields as numeric or otherwise. so if you do a compare it will simply compare it as text data. As long as you've got numeric values in your file to compare with your constant date then it shouldn't be an issue.
If you do get non-numerics in your file, that's a different issue. It will consider "A" to be less than "1" for example, rather than throw any sort of error. But you could use a LT and a GT comparison to overcome that.
Bear in mind also, that in your example, you have the date in DDMMYYYY format, but to Selcopy it's just a string of numbers. So it will consider 01052010 to be less than 02052009, for example.
There may be date routines in Selcopy, although I've never used them. If you e-mail the guys at CBL with any queries, I've always found them to be extremely helpful. |
|
Back to top |
|
|
|