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.