-181 SQLCODE

[nxm150]

Our DB2 tables were moved from 1 region to another. I did make a change to my pgm but did not touch the cursor that is causing the following error. Why am I getting this all of a sudden?


SQLCODE = -181, ERROR: THE STRING REPRESENTATION OF A DATETIME VALUE
IS NOT A VALID DATETIME VALUE

 

[gregsimpson]

nxm150,

If your 100% sure your program change isn't at fault, it could be your territory and therefore your date format are different in this new region. The following link details this towards the bottom.

http://www-106.ibm.com/developerworks/db2/library/techarticle/0211yip/0211yip3.html

Cheers
Greg