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

DB2 UDB LUW Call to procedure from command line

P: n/a
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 9 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Feb 9, 12:18 pm, pspiv...@snet.net wrote:
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.
What happens when you execute

VALUES TIMESTAMP('2007-02-09-01.00.00.000000')

from the CLP?

--Jeff

Feb 10 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.