Hi all,

I am trying to execute a insert query in a JCL using IKJEFT01. One of the columns to be inserted is of picture clause CHAR(80). But when I execute the query only first 72 characters in the file are considered and the query fails.

Is there any way to overcome this situation?

P.S I need to execute this query using insert statement alone. I cannot use anything else.

thanks.

How about concatenating shorter strings.
Like this:
INSERT INTO ....
VALUES
('abcd...' ||
'efgh....' ||
'xyz....'
, ....
)

Is the data in a sepate file with lrcl of 80 or larger? JCL files are typically only 72 so that the line numbers are visble on the screen.

Thanks a lot for your replies,

Query is in a separate file of record length 200.

the sqlcode you get ?
maybe because of utf db and special characters - 80 characters will not fit in char(80)

Query fails with incompatible datatype for the successive fields. When I check the log for query, I see that only first 72 characters are present in query other characters are ignored.


Just wanted to know if there is anyway to input a larger record length input file. I dont think there is any method to do that. For now I have used the solution mentioned by Tonkuma and its working fine.

thanks for all your replies.