The Question is:
Running a SQL query within a DCL script,
is it possible to pass data retrieved from a SQL select statement back into DCL?
SELECT var INTO :newvar from tablename WHERE ...
Can the variable ':newvar' be passed to DCL?
The Answer is :
The OpenVMS Wizard is, as the name implies, the OpenVMS Wizard and not
the third-party application Wizard nor the SQL database Wizard.
The OpenVMS Wizard would request you contact the database vendor or
support organization about access to DCL symbols from within SQL or
other third-party application-specific scripting languages, and about
any potential application access to available OpenVMS Run-Time Library
(RTL) routines such as lib$set_symbol and lib$set_logical.
One common source of confusion: you cannot SPAWN to create new symbols
in this context, as these and any symbols created in a subprocess are
not copied back to the parent process when thesubprocess exits.
But again, please contact the application vendor for assistance.