Pointing out the obvious was very helpful, thanks. Gives me great
confidence in dealing with IBM on odd issues such as this.
We're dealing with report code written by a vendor (who knows what bizarre
reason they had), and found the issue when the report wasn't returning
expected results. We know using external dates work. We know having a
dict item without the conversion works. We also know that using the
bizarre scenario of an internal date against an external field works. What
we don't know, and hence the question being posted, is why only this date
range of 14001 - 14365 does not work.
Gary P. Canedy
Database Analyst
ProMutual Group
(617) 757-6775
Timothy Snyder
<[EMAIL PROTECTED]
com> To
Sent by: [email protected]
[EMAIL PROTECTED] cc
stserver.u2ug.org
Subject
Re: [U2] UniVerse Internal Date
06/09/2006 11:02 Blackout
AM
Please respond to
[EMAIL PROTECTED]
er.u2ug.org
[EMAIL PROTECTED] wrote on 06/09/2006 10:16:08 AM:
> >SELECT TESTFILE WITH DATE > 14000
> Bad data "14000" for conversion "D2/". Unconverted data used for
> selection.
>
> 8 record(s) selected to SELECT list #0.
>
> > CLEARSELECT
>
> >SELECT TESTFILE WITH DATE > 14001
>
> 0 record(s) selected to SELECT list #0.
>
> >SELECT TESTFILE WITH DATE > 14365
>
> 0 record(s) selected to SELECT list #0.
>
> >SELECT TESTFILE WITH DATE > 14366
> Bad data "14366" for conversion "D2/". Unconverted data used for
> selection.
>
> 2 record(s) selected to SELECT list #0.
So why are you using internal date values against a date-formatted
dictionary item?!? If (for whatever bizarre reason) you want to do that,
just use a dict item that specifies a straight numeric value. For the
record, this is looking at 14001 as year 14, Julian date 001. 14365 is
Julian date 365 in year 14. 14366 is day 366 in year 14. Oh, wait, there
was no day 366 in year 14 - bad data. Hey, there was no day zero (14000)
either!
Make it easier on the humans and unambiguous for the computers. Use
external dates.
Tim Snyder
Consulting I/T Specialist , U2 Professional Services
North American Lab Services
DB2 Information Management, IBM Software Group
717-545-6403
[EMAIL PROTECTED]
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-----------------------------------------------------------
This email and any files transmitted with it are intended only for the
person or entity to which it is addressed and may contain confidential
and/or privileged material. If you received this email in error, please
contact the sender immediately and delete this email from your system. If
you are not the named addressee, you should not disseminate, distribute,
print, or copy the email, or take any action in reliance on its contents.
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
