Dynamic SQL

[Quoted] Currently I'm in the process of designing a COBOL program to interface with an Oracle Database. I'm looking at simply retrieving the data from the tables via relatively simple SELECT statements. However, I was trying to compare the differences between static Embedded SQL statements and Dynamic SQL statements. From what I have read, I realize that Dynamic SQL provides open ended flexibility in the program that I am writing, however if I know all the possible queries that I can run, what benefit would I get from using Dynamic SQL. In addition, are there any performance issues that I should be aware of when comparing static Embedded SQL and Dynamic SQL. Received on Tue Apr 15 1997 - 00:00:00 CEST