David,
Still the problem even when i do "SELECT WRVINV FROM TABLE ORDER BY
WRVINV". I have about 10 rows which look like datetime and it is a string.
The data is Invoice numbers not a date !!! What can i do ?

Thanks






"David J. Rubin " <[Email address protected]
28/06/2005 11:11 AM

To
"Ness, Maxim @ OYCBRE" <maxim.[Email address protected]
cc

Subject
RE: Order by problem - it's URGENT !!!






**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


I know this is called LazyDBA, but don't get lazy :)

Never issue "select *" for any production environment as it "ties" the
hand
of the database designer... ALWAYS explicitly list the columns you want to
retrieve... try that (with a from clause included) and if it doesn't work,
email/post again.

David

-----Original Message-----
From: Maxim Ness
[Email address protected]
Sent: Tuesday, June 28, 2005 11:02 AM
To: LazyDBA Discussion
Subject: Order by problem - it's URGENT !!!

Hello All,

I have a problem with order by in one table. I am able to view the data
using select * statement but when i try to do "select * order by
column_name" i get:

SQL0181N The string representation of a datetime value is out of range.
SQLSTATE=22007

sqlcode : -181

I don't have any datetime columns in the table. Environment is DB2 UDB
8.1.8.762 on Windows 2003 server.

This is production issue please advise.


Thanks !!!




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html









DB2 & UDB email list listserv db2-l LazyDBA home page