Can you provide the DDL for the table and the exact syntax of the SELECT statement you are attempting?

-----Original Message-----
From: Maxim Ness
[mailto:db2udbdba-ezmlmshield-x40637829.[Email address protected]
Sent: Tuesday, June 28, 2005 10:17 AM
To: LazyDBA Discussion
Subject: RE: Order by problem - it's URGENT !!!


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










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



CONFIDENTIALITY NOTICE

This e-mail and any attachments, as well as any documents from a file server of International Truck
and Engine Corporation or its affiliates, are intended for the addressee and may contain information
that is privileged, confidential, proprietary, or otherwise protected by law. Any dissemination,
distribution, or copying is prohibited. If a confidentiality or nondisclosure agreement exists
between International and the recipient or the recipient's employer, this e-mail and any attachments
hereto, as well as any documents from a file server of International Truck and Engine Corporation or
its affiliates, this notice serves as marking as CONFIDENTIAL information of International Truck and
Engine Corporation or its affiliates. If you have received this communication in error, please
contact the original sender.

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