Trying to run big SQL script from IFS, using RUNSQLSTM

[inigo.redin]

Hi!


First time publishing here. Thanks for your ideas!

I'm trying to run a big SQL script.
It is composed by INSERT sentences. About 500.000.
Just to try one way to migrate one file into iSeries, from another DB.

It's ok, if the file...

[ankita]

Hi,
I am trying to execute a sql which is stored in a text file in IFS, using a CL program.
First I copied the file to a source file using CPYFRMSTMF then I need to ececute the RUNSQLSTM command.

Following is the command that I used in the code

RUNSQLSTM...