Use of prompted values in sql-cursor code

[Leslie Tsukamoto]

Everyone - we are still running version 7.33d3 of cognos quiz on an HP9000.
Years ago when we installed the product we were migrating from an HP3000
environment in which we used Robelle's Suprtool product to perform high
speed extracts of data to pre-populate empty quiz subfiles in a faster
manner.  When we migrated to the hp9000 there was a thought that we could
address not having to bring the suprtool logic over as Quiz now supported
sql code in sql cursors.  We attempted to test this to determine if we
needed to purchase Suprtool for HPUX as well and what we found at that time
was that if we coded a data extract using the sql cursor logic and used HARD
CODED values for the extract -then the quiz sql cursor extract response time
was pretty much equal to the suprtool for HPUX response time in extracting
the data and pre-populating the quiz subfile that would be used in
subsequent passes - however, as we tried to build into the sql cursor code -
logic that would reference prompted values that were defined in a quiz DEF
statement - we had problems - the version of quiz we had was not allowing us
to code in that manner - when we talked with cognos support - they noted
that QTP for HPUX did allow that syntax and the usage of prompted values in
sql cursors but at that time that quiz did not.

We ultimately purchased Suprtool and have been using it ever since -
however, now that we are looking to move off of the HP box and over to a SUN
box we have found out that Suprtool is not supported and does not run on the
SUN platform - so we are back to trying to get a high speed extract for our
quiz solution - my question was - does anyone know if the newer version of
Quiz support referencing prompted values in sql cursor code?

Sincerely,  Leslie

Leslie J. Tsukamoto
Manager of Programming, CAE SimuFlite
ph:  407-445-0226
fax: 407-295-9493
email: leslie.tsukamoto@cae.com