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 ONE Support launchpad (Login required).

Search for additional results

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