SAP Knowledge Base Article - Preview

2295344 - Is there an equivalent function in SAP IQ similar to get_env() in Oracle 11g which can access environmental variables via PL/SQL query ?

Symptom

  • Is there an equivalent function in SAP IQ similar to get_env() in Oracle 11g which can access environmental variables via PL/SQL query as shown in example ?

    SQL> var oracle_home clob;
    SQL> exec dbms_system.get_env('ORACLE_HOME', :oracle_home);
    SQL> print oracle_home
    ORACLE_HOME
    --------------------------------
    /oracle/base/product/db11204ee

  • What are the other basic facts about such function which end-user should generally be aware of ? 


Read more...

Environment

  • IQ Any version

Product

SAP IQ 16.0

Keywords

KBA , BC-SYB-IQ , Sybase IQ , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.