topic Re: HOW to execute SQL STMTS in testprogram? in Application Development and Automation Discussions

HOW to execute SQL STMTS in testprogram?

Former Member — Thu, 13 Oct 2005 13:00:13 GMT

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

Re: HOW to execute SQL STMTS in testprogram?

RichHeilman — Thu, 13 Oct 2005 13:08:54 GMT

If you are measure the overhead of the SQL statements and do not want any other factors, then I would say yes, you must have the SQL statements directly in the program.

Regards,

Rich Heilman

Re: HOW to execute SQL STMTS in testprogram?

Former Member — Thu, 13 Oct 2005 14:37:20 GMT

Well, you could upload the entire file and generate a report. (F1 on GENERATE.)

Rob