Hi,

I am trying to run following query in a DB2 database,

INSERT INTO &DATABASE..SLCT_DFN
VALUES(123,'','2010-1-1','2012-1-1',0,'Test',''
,
'This is a very long line. This is a very long line. This is a '||
'very long line. This is a very long line. This is a very long '||
'line. This is a very long line. This is a very long line. This'||
' is a very long line. This is a very long line.','TH','')

but not able to get any success. I have attached screenshot of the error i am getting.
Can some one help?

I am sorry i dont know from where to get the DB2 version and other stuff. I tried DB2LEVEL command but may be at wrong panel.

R you trying in db2 Luw i believe the os is of mainframes. In tht case u r in wrong blog and the error says invalid '?' found please chk tht.

regds
Paul

you can get mainframe help here as well as LUW. A forum that is monitored by more folks on the mainframe is IDUG's DB2-L.
How are you performing these inserts? as stated above, it seems however you are doing it, the concat operators are being translated to ?. you may want to try writing "concat "instead of "||"

Dave Nance

on my mainframe !! is interpreted as the concat operator.

I think your problem may be that you appear to be doing a line break after the || on your input file. A string (including concats) must all be on one line (or least no line breaks before the end of the string).