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 CDT
