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

How to insert a string of length 650 char into a Table


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

New User


Joined: 31 Aug 2005
Posts: 21

PostPosted: Mon Nov 14, 2005 5:12 pm
Reply with quote

All,

How to insert the long string in to field.

Database field :: length is 650.

By using Program i can update the filed and insert . there is no problem.

By using SPUFI and QMF , i can't insert and update field with more than 255 character. It's giving an error sql error -102.

Please anybody can advice me, how to success.

Thanks,
krishna...
Back to top
View user's profile Send private message
priyesh.agrawal

Senior Member


Joined: 28 Mar 2005
Posts: 1448
Location: Chicago, IL

PostPosted: Mon Nov 14, 2005 8:01 pm
Reply with quote

From the manual...

Quote:
The requested function is not available interactively. If the error occurred in the context of an SQL statement embedded in an application program, the desired result can be achieved by assigning the long string to a host variable, and substituting that variable for the string literal in the SQL statement.


Regards,

Priyesh.
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 Store the data for fixed length COBOL Programming 1
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Replace each space in cobol string wi... COBOL Programming 3
No new posts PARSE Syntax for not fix length word ... JCL & VSAM 7
No new posts Load new table with Old unload - DB2 DB2 6
Search our Forums:

Back to Top