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

DB2 UDB LUW Command Line Parameter

P: 5
I have the following in my procedure:


CREATE PROCEDURE x_proc ( IN from_date timestamp
, IN to_date timestamp
, IN data_center char(1)
, IN run_option int)

My db2 command line is:

db2 -t -v -z x_log "call x_proc('2007-02-09-01.00.00.000000', '2007-02-09-01.00.00.000000', 'X', 1)"

And I get the following error.

SQL0180N The syntax of the string representation of a datetime value is incorrect. SQLSTATE=22007

Something with the timestamp, but I haven't been able to figure it out just yet. Any thoughts? Thanks.
Feb 10 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.