MVSFORUMS.com

[SMS]

Hi,

I have been brainstorming for the following requirement.

From the front end, around 20,000 rows that are present on the grid needs to be saved to a DB2 table with the connection extablished thru DB2connect. But it's taking very very long time from the front end.

So we thought of passing the data to a stored procedure instead of saving in the front end to improve the performance. The stored procedure cannot directly pull the data from the source table and the data has to transmitted to SP only from the front end grid. So front end has to call the SP for each row. But there may be 20,000 calls to the stored procedure which is not an efficient design. Also, the option of saving the data to a text file and FTP-ing to the backend is also eliminated.

Is there any other way to pass these 20,000 rows (average row length 500byts) on the fly to a Stored Procedure ?

I would appreciate any suggestions from you experts.
_________________
Regards,
SMS

[dr_te_z]

Some kind of temp-table/MQT like solution
or
concider a federated database solution so you c

[SMS]

Thanks, I will look into it.
_________________
Regards,
SMS