MVSFORUMS.com

pkrish_18 · Beginner Joined: 08 Apr 2005 Posts: 12 Topics: 7

Hi,

Thru spufi or QMF, if I try to Insert value for a VARCHAR(1190) db2 column, (the actual value which I am trying to insert is more than 300 chars length) , it through's an SQLCODE -102 LITERAL STRING IS TOO LONG. STRING BEGINS string .Can anyone pls let me know why this is happening?. Is there any way of avoiding this? or is there any alternative of doing this?

Regards,

Krish

rony&ruby · Posted: Sun Jun 05, 2005 7:45 am Post subject:

Hi pkrish_18:

Had you tried with IKJEFT01 jcl run? You can write you sql in instream statements or write them in a dataset.

Maybe spufi has restiction on long string connect, but I am not sure.
And make sure that your connection of each ling was ok.

Welcome to discuss.

Rony&Ruby
_________________
Ron Yang

kolusu · Posted: Sun Jun 05, 2005 8:57 pm Post subject:

pkrish18,

The error messages are self-explanatory. you cannot insert more than 255 characters using spufi or qmf. check this link for a detailed explanation of sql error code of -102

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNMCH11/2.1.6.9?SHELF=&DT=20010718150520&CASE=

why don't you load the table using load utility?

Check this link for a discussion about loading varchar colums using load utily

http://www.mvsforums.com/helpboards/viewtopic.php?t=244&highlight=varchar

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

rony&ruby · Posted: Tue Jun 07, 2005 2:55 am Post subject:

Thanks kolusu!
_________________
Ron Yang