SQL Insert AS400

Could someone help me in the following problem:
If I would like to Insert rows into an AS400 file via execSQL service, can I do it in one step for all the records stored in a record list, or I have to do it line by line.
Thanks for any guidence in advance.

If you are using execSQL, you will have to do it line by line. Try writing a stored procedure or something like that.
Good Luck!