Skip to Content
0
Former Member
Oct 13, 2005 at 01:00 PM

HOW to execute SQL STMTS in testprogram?

19 Views

Hi all,

I have got many traced SQL stmts with timestamps. The stmts follow directly on each other. This means stmt1 is executed at 04:11:12pm and stmt2 is executed at 04:11:13 for example.

I have got approximately 60.000 thouand stmts that will be executed over a timeframe of one or two hours.

I think it does not make sense to read the stmts from a file in a loop. This takes too much time. Moreover the data, got back by executed stmts has to be stored in internal tables.

Reading the stmts from a file would take too much time. So the time-gap between the stmts would not be extended.

Do you think, I should just paste 60.000 stmts into an ABAP program?

How would you solve that problem?

thanks