IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Problem while inserting 0 to table in spufi


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
abhijit.nayak01

Active User


Joined: 22 Mar 2009
Posts: 161
Location: South Africa

PostPosted: Wed Jul 27, 2011 9:12 pm
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Jul 27, 2011 9:40 pm
Reply with quote

Hello,

Suggest you work with the dba and verify that the B column is really defined as CHAR.
Back to top
View user's profile Send private message
Prasanthhere

Active User


Joined: 03 Aug 2005
Posts: 306

PostPosted: Thu Jul 28, 2011 10:48 am
Reply with quote

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
View user's profile Send private message
abhijit.nayak01

Active User


Joined: 22 Mar 2009
Posts: 161
Location: South Africa

PostPosted: Thu Jul 28, 2011 7:08 pm
Reply with quote

Hi,
Sorry for late response.
Fortunetely it worked in morning and I didnt even changed anything.
Thanks for ur assistance.
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


Joined: 19 May 2007
Posts: 1512
Location: Virginia, USA

PostPosted: Thu Jul 28, 2011 7:23 pm
Reply with quote

Praise be to ? the almighty, he/she/it fixed the problem.
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Thu Jul 28, 2011 7:27 pm
Reply with quote

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
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Thu Jul 28, 2011 9:18 pm
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Wed Aug 03, 2011 1:53 pm
Reply with quote

Craq Giegerich wrote:
Praise be to ? the almighty, he/she/it fixed the problem.
Almighty! Almighty! icon_biggrin.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts DELETE SPUFI DB2 1
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Map Vols and Problem Dataset All Other Mainframe Topics 2
No new posts Adding QMF and SPUFI to the ISPF menu DB2 20
Search our Forums:

Back to Top