| View previous topic :: View next topic |
| Author |
Message |
issac1029
Intermediate
Joined: 10 Dec 2005
Posts: 159
Topics: 75
|
 Posted: Fri Mar 17, 2006 1:14 am Post subject: INSERT RETURN -180 ;How to know which column? |
 |
|
| Quote: | DSNT408I SQLCODE = -180, ERROR: THE DATE, TIME, OR TIMESTAMP VALUE IS INVALID
DSNT418I SQLSTATE = 22007 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRIVB SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -140 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF74' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION |
Can I know which column disobey the rule by analysing the information display above ? |
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Fri Mar 17, 2006 5:54 am Post subject: |
|
|
issac1029,
Look at the columns which are defined as DATE or TIME or TIMESTAMP. You only get a -180 sqlcode if you do not have a valid value on one those columns
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
issac1029
Intermediate
Joined: 10 Dec 2005
Posts: 159
Topics: 75
|
| Posted: Fri Mar 17, 2006 6:00 am Post subject: |
|
|
| There are so many column defined as |
|
| Back to top |
|
|
CZerfas
Intermediate
Joined: 31 Jan 2003
Posts: 211
Topics: 8
|
| Posted: Wed Mar 22, 2006 7:34 am Post subject: |
|
|
A nice way to get around this unspecified error message is to run this statement (if possible) from QMF. Here you usually get a line and column number (of the sql statement) where the error occured.
regards
Christian |
|
| Back to top |
|
|
issac1029
Intermediate
Joined: 10 Dec 2005
Posts: 159
Topics: 75
|
| Posted: Thu Mar 23, 2006 2:33 am Post subject: |
|
|
ISPD212
Invalid PGM name
Link to 'DSQQMFE' failed,
QMF can't work.......  |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose
|
| Posted: Thu Mar 23, 2006 6:32 am Post subject: |
|
|
| Quote: |
Invalid PGM name
Link to 'DSQQMFE' failed,
QMF can't work
|
issac1029,
You need to talk to your DBA about Activating QMF. It seems that they haven't setup QMF at your shop.
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
