HP OpenVMS Systems

ask the wizard

Third-party Application? (SQL)

» close window

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?
 
Example:
 
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.
 

  
     
     answer written or last revised on ( 24-FEB-2003 )
     » close window