By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,924 Members | 1,793 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,924 IT Pros & Developers. It's quick & easy.

Vexing Problem with DB2 UDB Design Advisor? Any Suggestion, please!

P: n/a
Hello community,

My environment is DB2 UDB v8.2 LUW. I am experiencing a vexing problem
with using my DB2 Design Advisor. I submitted a SQL script to Advisor
for index recommendation and I am getting the error:

IBM][CLI Driver][DB2/LINUX] SQL0180N The syntax of the string
representation of a datetime value is incorrect.

SQLSTATE"007

Explanation:

The string representation of a date, time, or timestamp value
does not conform to the syntax for the specified or implied data
type.

The statement cannot be processed.

And here's the part of my SQL that I suspect is causing this error

"...and Updt.DT_When_CMPL BETWEEN (timestamp((current_date-
(day(current_date)-1)days -1 month),'00:00:00')) AND
(timestamp(Date(current_date-day(current_date)days ),'23:59:59'))"...

I have no errors running the complete SQL in Control Center Command
Editor, or Task Center but the Design Advisor seems to take an issue
with that construct.

Anyone run into this proble? Can anyone suggest a solution and if
possible share the step by step example/procedure how to resolve
this?

I thank you for your attention and help

Okonita

Sep 10 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.