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
 

 

Upload DB2 error 104
Goto page 1, 2  Next
 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
soumen2255

New User


Joined: 25 Jun 2008
Posts: 24
Location: Pune

PostPosted: Wed Jun 09, 2010 7:11 pm    Post subject: Upload DB2 error 104
Reply with quote

Can Anyone please help me out with what this error means while DB2 insert-

SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: ,;( + - ? : CASE CAST NULL USER <FLOAT> CURRENT DEFAULT NEXTVAL
Back to top
View user's profile Send private message

dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Wed Jun 09, 2010 7:23 pm    Post subject:
Reply with quote

The following is from the -104 description and response paragraphs,
which obviously you have read:

Quote:
A syntax error in the SQL statement was detected at 'token'

Examine the statement in the area of the specified token.If you are executing the SQL statement dynamically under TSO, be sure that if the data set containing the DSNHDECP load module has not been included in your LINKLSTxx, it has been included in STEPLIB statements in:1. The DB2 start-up procedure 2. The TSO logon procedure or batch job JCL.


since you have not bothered to provide us with ANY information about
what are you trying to do
what does the data look like
what does the ddl for the table look like

you are on your own.
Back to top
View user's profile Send private message
Craq Giegerich

Senior Member


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

PostPosted: Wed Jun 09, 2010 7:23 pm    Post subject: Re: Upload DB2 error 104
Reply with quote

soumen2255 wrote:
Can Anyone please help me out with what this error means while DB2 insert-

SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: ,;( + - ? : CASE CAST NULL USER <FLOAT> CURRENT DEFAULT NEXTVAL


Any chance you could cut and paste the original sql statement so we could see it.
Back to top
View user's profile Send private message
soumen2255

New User


Joined: 25 Jun 2008
Posts: 24
Location: Pune

PostPosted: Wed Jun 09, 2010 7:32 pm    Post subject: Re: Upload DB2 error 104
Reply with quote

Craq Giegerich wrote:
soumen2255 wrote:
Can Anyone please help me out with what this error means while DB2 insert-

SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: ,;( + - ? : CASE CAST NULL USER <FLOAT> CURRENT DEFAULT NEXTVAL


Any chance you could cut and paste the original sql statement so we could see it.


Hi Craq,

Fot security reasons I cannot post the insert statement,It has 90 columns with the following datatypes : DECIMAL(10,0)
CHAR(4)
DATE
CHAR(3)
CHAR(7)
CHAR(2)
CHAR(6)
CHAR(1)
DECIMAL(15,2)
CHAR(9)
DECIMAL(15,0)
CHAR(10)
VARCHAR(120)
TIMESTAMP

Thanks in advance.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Wed Jun 09, 2010 7:40 pm    Post subject: Reply to: Upload DB2 error 104
Reply with quote

Quote:
For security reasons I cannot post the insert statement

if You cannot provide the requested info, why waste everybody' s time ???
have Your support people start earning their salary
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Wed Jun 09, 2010 7:57 pm    Post subject:
Reply with quote

soumen2255 wrote:
SQLCODE: -104, SQLSTATE: 42601, SQLERRMC: ,;( + - ? : CASE CAST NULL USER <FLOAT> CURRENT DEFAULT NEXTVAL
The above message is nice, but what does the actual -104 message show for the "token'?
-104 ILLEGAL SYMBOL "token". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: token-list
And where in your insert is that "token" being used?
Back to top
View user's profile Send private message
soumen2255

New User


Joined: 25 Jun 2008
Posts: 24
Location: Pune

PostPosted: Wed Jun 09, 2010 8:10 pm    Post subject: Re: Reply to: Upload DB2 error 104
Reply with quote

enrico-sorichetti wrote:
Quote:
For security reasons I cannot post the insert statement

if You cannot provide the requested info, why waste everybody' s time ???
have Your support people start earning their salary


hERE IS MY INSERT STATEMENT :

Code:
INSERT INTO DEMO.TEST(DCC_N,EDC_FJZ_C,ED_EFF_D,ED_END_D,DJN_I,DCC_DDKE_I,DJN_DGK_C,ZJD_UNIG_I,ZJD_HD_I,DCC_HZEN_D, DCC_CLK_D,DCC_CLK_JKN_C,DCC_HJIGBN_C,DCC_KBDB_C,DCC_CHNGN_KBDB_C,DCC_HDNZ_BYZ_C, DCC_DHC_KBKFY_C,DHC_CZZLNC_C,DCC_DJ_CDJD_CK_C,CDC_DJ_CDJD_BYZ_C,IHD_BYZ_9_C,IHD_BYZ_2_C, IHD_BYZ_9_C,IHD_BYZ_9_C,IHD_D,IHD_D,IHD_UZD_EGNB_C,IHD_JBJN_HDJG_C,IHD_JKK_ZJBY_9_C, IHD_JKK_ZJBY_2_C,IHD_JKK_ZJBY_9_C,CDC_IHD_UZD_D,CUJ_C,CDC_DKCLJ_HDJN_C,CDC_HBKD_ZHK_C, CDC_BYZ_C,CDC_CDD_JGKBN_C,KF_C,CDC_NKBD_KF_C,IZ_BIN_BYZ_C,CDC_DDDL_JDBE_C,DI_ZJHCD_DIKZ_C, DI_ZYZB_KJCE_C,DI_DIKDB_FJEQY_C,DI_INCZ_DIKZ_C,DI_KBK_KZLB_DIKZ_C,DI_CEJBF_DIKZ_C, DI_CEJBF_KJCE_C,DI_XFJ_INKBJN_C,ZYI_BYZ_C,CDC_BDX_HFFK_C,CDC_CZN_BYZ_C,CDC_CKZ_C, CDC_CFZ_KUZJ_C,CDC_DCDB_ZNDG_C,CDC_CZN_DDK_C,CDC_HHHLD_C,CDC_CHJ_KUD_CHJ_C,DDK_I, KYK_DDK_CDD_KEND_C,KYK_DDK_CDD_KEND_D,KYK_DDK_JZD_KEND_C,KYK_DDK_JZD_KEND_D,CDC_JKND_JZD_C, CDC_JKND_DNK_C,CDC_ZDINC_JIKKC_C,CDC_ZDINC_DDILL_C,CZN_LDKB_KBZB_D,HZB_DKCLJ_KENB_D, CDC_ID_ZXY_DUBH_C,CDC_ID_ZXY_DUBH_D,KYK_DNK_HNE_JKND_C,KYK_DNK_HNE_JKND_D,CDC_ZDCC_ZFL_C, CDC_JZD_KDZ_DLK_C,CDC_KF_DLK_D,CDC_DZG_DZZGL_C,CDC_DZG_DZZGL_D,CDC_BDX_BYZ_C,CDC_UZD_D, ED_UKD_I,ED_UZD_Z,CDC_HZB_KIGN_D,CDC_ZKCJ_LBY_DNK_C,CDC_ZKCJ_LBY_FEE_C,CDC_EFB_GND_C,IZ_BIN_I,  CDC_BBL_NZE_B, DCC_KJCH_KHJB_X) VALUES (9792900,'0000','2009-99-90','',' DD',' 99599 ','02','K79970','DD02  ','2009-99-90','', '   ','   ','D',' ','07',' ',' ','C',' ','  ','  ','  ','  ',,'','   ','D','Z',' ',' ', '2009-99-90','   ','Y',' ',' ','JD','029',' ','K',' ','B','D',' ','9','5','L','N','F',' ',' ', ' ',' ',' ',' ',' ',' ','   ',799990955929090,' ','',' ','',' ',' ',' ',' ','2009-09-99','', ' ','',' ','',' ',' ','',' ','','9','2007-09-92','JCDDZ209  ','2009-09-05 29:09:00.000990','', ' ',' ',' ','097799799', 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX', 'Dd')
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Wed Jun 09, 2010 8:26 pm    Post subject:
Reply with quote

apparently you have a NULLable column?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Wed Jun 09, 2010 8:28 pm    Post subject: Reply to: Upload DB2 error 104
Reply with quote

no wonder Your support does not want to get involved!

did You check Your statement for typos ?

did You check for the correct column names ?
( i see quite a few duplicate names there )
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Wed Jun 09, 2010 8:30 pm    Post subject:
Reply with quote

My goodness, that is one ugly insert......
William Thompson wrote:
...but what does the actual -104 message show for the "token'?
-104 ILLEGAL SYMBOL "token". SOME SYMBOLS THAT MIGHT BE LEGAL ARE: token-list
And where in your insert is that "token" being used?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Wed Jun 09, 2010 8:33 pm    Post subject:
Reply with quote

is IHD_D a nullable column
if not, you have forgotten a value.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Wed Jun 09, 2010 8:50 pm    Post subject: Reply to: Upload DB2 error 104
Reply with quote

I had noticed that too, but I was more curious about the duplicate column names icon_biggrin.gif
never used it, nor seen it
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 Jun 09, 2010 8:58 pm    Post subject: Reply to: Upload DB2 error 104
Reply with quote

Quote:
Fot security reasons
There is percieved security in confusion and non-readability. . . icon_cool.gif
Back to top
View user's profile Send private message
soumen2255

New User


Joined: 25 Jun 2008
Posts: 24
Location: Pune

PostPosted: Wed Jun 09, 2010 11:55 pm    Post subject:
Reply with quote

dbzTHEdinosauer wrote:
is IHD_D a nullable column
if not, you have forgotten a value.



Yes the column is nullable and the two column names are NOT identical,I am extreamly sorry that while sanitising the data it was a mistake on my part to put identical column names...

Please help..
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Jun 10, 2010 12:02 am    Post subject:
Reply with quote

Quote:
sanitising


we spend 10 posts trying to get info to help you
and then all you provide is garbage............
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 645
Location: Pennsylvania

PostPosted: Thu Jun 10, 2010 12:32 am    Post subject:
Reply with quote

soumen2255,

Do you understand the problem here?

You have a SYNTAX ERROR in your insert statement.

Nobody here can help you if:
1) You can not give the actual statement (for security purposes of course)
2) Give a santisized version of the statement (it has now been changed)

Even so, the actual (not santized) and complete error message is what really is required.
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 Jun 10, 2010 12:35 am    Post subject:
Reply with quote

Hello,

What happens if you execute this using only the first 10 columns and associated values? The next 10? etc. . .

Shoot the author. . .

d
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 Jun 10, 2010 1:38 am    Post subject: Reply to: Upload DB2 error 104
Reply with quote

Oops. . . My bad icon_redface.gif

Forgot where i was and fell back to a method used in a prior life. . .

Sorry for the mis-cue, and thanks to DBZ for reminding me,

d
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Thu Jun 10, 2010 2:03 am    Post subject:
Reply with quote

wait until soumen2255 finally bothers to correct his sql,
gets past the -104
and then runs into RI Violations!!!!
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Thu Jun 10, 2010 3:05 am    Post subject: Reply to: Upload DB2 error 104
Reply with quote

Quote:
For security reasons I cannot post the insert statement


given the names of the columns I would say ... security by obfuscation
such poor/confusing naming conventions are prone to cause lots of pain to the developers 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
Goto page 1, 2  Next
Page 1 of 2

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm
No new posts Invoke Webservice Fails with DFHPI100... divated CICS 2 Thu Nov 24, 2016 5:57 pm
No new posts Error during restore rename archanamuthukrishnan All Other Mainframe Topics 2 Fri Oct 14, 2016 3:30 pm
No new posts Error IEC161I 052(009,XXXRS00)-084 wh... amitc23 JCL & VSAM 10 Wed Oct 12, 2016 5:00 pm
No new posts IDMS/DC-COBOL program - SNAP error wh... rakeshsekar1987 IDMS/ADSO 5 Tue Sep 13, 2016 8:28 pm


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