View previous topic :: View next topic
|
Author |
Message |
abhijit.nayak01
Active User
Joined: 22 Mar 2009 Posts: 161 Location: South Africa
|
|
|
|
Hi,
Can anybody please assist me on the below issue.
I got a table and the table description as follows:
A DECIMAL 3
B CHAR 20
C DECIMAL 4
D CHAR 8
E CHAR 80
F CHAR 1
G DECIMAL 5
H CHAR 1
When I am doing the insert by using spufi with following insert:
INSERT INTO ABCD.XYZ
(A
,B
,C
,D
,E
,F
,G
,H)
VALUES
(01
,'210000-1011 00 00'
,0
,' '
,' N N N '
,'Y'
,0
,' ')
The following error I am getting:
DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL ",0". SOME SYMBOLS THAT MIGHT
BE LEGAL ARE: MICROSECONDS MICROSECOND SECONDS SECOND MINUTES MINUTE
HOURS |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Suggest you work with the dba and verify that the B column is really defined as CHAR. |
|
Back to top |
|
|
Prasanthhere
Active User
Joined: 03 Aug 2005 Posts: 306
|
|
|
|
Code: |
DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL ",0". SOME SYMBOLS THAT MIGHT
BE LEGAL ARE: MICROSECONDS MICROSECOND SECONDS SECOND MINUTES MINUTE
HOURS
|
This suggests the field might be TIMESTAMP. check in sysibm.syscolumns and check the coltype field. |
|
Back to top |
|
|
abhijit.nayak01
Active User
Joined: 22 Mar 2009 Posts: 161 Location: South Africa
|
|
|
|
Hi,
Sorry for late response.
Fortunetely it worked in morning and I didnt even changed anything.
Thanks for ur assistance. |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
Praise be to ? the almighty, he/she/it fixed the problem. |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
abhijit.nayak01 wrote: |
Hi,
Sorry for late response.
Fortunetely it worked in morning and I didnt even changed anything.
Thanks for ur assistance. |
Well, I don't think so. If it didn't work, and you (or anyone else) didn't change anything, it won't work when you just run it again.
So, something has changed. There is no "fortune" in such things, only trouble. Maybe it was a wrong definition and someone, without you knowing, fixed it. I'd suggest, for peace of mind if nothing else, finding out what changed. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
Fortunetely it worked in morning and I didnt even changed anything. |
Something changed. . . Possibly the underlying database definition.
As Bill suggests, you really want to know so that something more important doesn't "fall over" some night. . . |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Craq Giegerich wrote: |
Praise be to ? the almighty, he/she/it fixed the problem. |
Almighty! Almighty! |
|
Back to top |
|
|
|