Datacom

 View Only

  • 1.  SQL I/O program.

    Posted Jan 26, 1999 03:15 PM
    I am helping a customer that is having SQL performance problems. One thing
    they are doing that I am unsure of is the use of an SQL I/O program. They
    have moved all the SQL into one program, their online and batch programs
    call the I/O program with a parameter, and the I/O program executes the
    requested SQL statement and passes the data back to the program. The program
    uses static SQL and works fine, but is it a good idea? The bind for this
    program must be huge, is this being loaded every time this program is
    executed? Or is it very efficient?

    Thanks for you input

    Graham Climpson
    gclimpson@usa.net
    630 790 3228

    PS The program is using ISOLEVEL=C and PLNCLOSE=T