Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Problem while inserting 0 to table in spufi

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
abhijit.nayak01

Active User


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

PostPosted: Wed Jul 27, 2011 9:12 pm    Post subject: Problem while inserting 0 to table in spufi
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

Site Director


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

PostPosted: Wed Jul 27, 2011 9:40 pm    Post subject:
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    Post subject:
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: 157
Location: South Africa

PostPosted: Thu Jul 28, 2011 7:08 pm    Post subject:
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    Post subject:
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7314

PostPosted: Thu Jul 28, 2011 7:27 pm    Post subject:
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

Site Director


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

PostPosted: Thu Jul 28, 2011 9:18 pm    Post subject:
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

Senior Member


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

PostPosted: Wed Aug 03, 2011 1:53 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Having a problem FTP'ng to the MF pahiker All Other Mainframe Topics 2 Fri Nov 10, 2017 8:20 pm
No new posts Update table without cursor Ron Klop DB2 3 Wed Oct 11, 2017 1:06 pm
No new posts Table(Unicode(Graphic) table) loading... muralikrishnan_new DB2 0 Thu Oct 05, 2017 5:10 pm
No new posts LMINIT problem - not finding DDNAME Danielle.Filteau CLIST & REXX 7 Tue Sep 19, 2017 9:57 pm
No new posts Insert a Row_number into table useit DB2 2 Tue Sep 19, 2017 1:07 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us