Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 7306

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 Problem reading GTF trace output danik56 ABENDS & Debugging 7 Thu Mar 16, 2017 1:02 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Inserting records based on conditions vickey_dw DFSORT/ICETOOL 9 Wed Feb 22, 2017 1:33 pm
No new posts Join of more than one table dibyendumandal11111 DB2 6 Mon Feb 13, 2017 11:36 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us