View previous topic :: View next topic
|
Author |
Message |
deepak_shrivastava
New User
Joined: 05 Jan 2016 Posts: 8 Location: India
|
|
|
|
Hi, Can any one please tell the exact difference between DB2 SQL Error code -180 and -181 with example ? |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10872 Location: italy
|
|
Back to top |
|
|
RahulG31
Active User
Joined: 20 Dec 2014 Posts: 446 Location: USA
|
|
|
|
Read the links and try to run below mentioned queries:
SQLCODE -180:
Code: |
SELECT TIMESTAMP('XYZ') AS TS
FROM SYSIBM.SYSDUMMY1
WITH UR; |
SQLCODE -181:
Code: |
SELECT TIMESTAMP('2015-99-24-00.00.00.000000') AS TS
FROM SYSIBM.SYSDUMMY1
WITH UR; |
. |
|
Back to top |
|
|
deepak_shrivastava
New User
Joined: 05 Jan 2016 Posts: 8 Location: India
|
|
|
|
RahulG31 wrote: |
Read the links and try to run below mentioned queries:
SQLCODE -180:
Code: |
SELECT TIMESTAMP('XYZ') AS TS
FROM SYSIBM.SYSDUMMY1
WITH UR; |
SQLCODE -181:
Code: |
SELECT TIMESTAMP('2015-99-24-00.00.00.000000') AS TS
FROM SYSIBM.SYSDUMMY1
WITH UR; |
. |
Thank You !! |
|
Back to top |
|
|
deepak_shrivastava
New User
Joined: 05 Jan 2016 Posts: 8 Location: India
|
|
|
|
Thank You Very much !! |
|
Back to top |
|
|
|