How can i insert Long string through JCL

Rajen · New User Joined: 05 May 2005 Posts: 61

Hi Can anyone please tell me how can i insert Long string through JCL SYSTSIN parameter.

I have to insert a long error message in DB2 table.

Example query is given below.

INSERT INTO table
error_message
VALUES ( 'please enter date...(some big message) in valid format -- yyyy/mm/yy')

Now the problem with this message is, it is going beyong 72th (even 80th) column and i need to continue this error message in the next line.

Can anyone tell me how to give continuation in SYSTSIN in JCL?

I tried with continuation at 72th column but its abending giving message like ' Passing string too long'

priyesh.agrawal · Posted: Sat Nov 04, 2006 11:17 pm

Try like this... putting a plus sign at last for continuation...

Rajen · New User Joined: 05 May 2005 Posts: 61

Hi Priyesh,
Thanks A lot for reply.

Can you please tell me where should i place that plus '+' sign.

I think it should be at 72th column but just to make sure i am asking.

Thanks,
Rajen.

Kevin · Active User Joined: 25 Aug 2005 Posts: 234

You could also just make the dataset's LRECL larger, so that you might be able to fit the data on one record.

Just a thought.

priyesh.agrawal · Posted: Tue Nov 07, 2006 2:30 am

Do you really need a continuation. Below query works just fine for me.

Rajen · New User Joined: 05 May 2005 Posts: 61

Hi Priyesh,
Thanks again for reply.
I guess u have used comma (,) on 7th or 8th charactor. Earlier i mentioned about that continuation charactor.

priyesh.agrawal · Posted: Thu Nov 09, 2006 4:34 am

Hi Rajen,

That comma (",") is a part of my string to be loaded onto Table, not a continuation character. Thus my field value after upload would looks like below.