Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
Gisung
Advisor
Advisor
0 Kudos

Here are explanations of redirection change of dbisqlc.


[Problem]


After upgrading to IQ15.4, redirection output is empty when using dbisqlc like below.


> dbisqlc -c dsn=xxx -q "select @@version" > output.log

> ls -al output.log -- 0 byte (empty) output is generated.


[Cause]


An Output redirection in dbisqlc was changed in IQ 15.2 ESD#3 (CR# 679284).


[Resolution]

From 15.2 ESD#3 SQL "output redirection" should be managed with the ">&" syntax instead of ">" at the command line like below.

> dbisqlc -c dsn=xxx -q "select @@version >& output.log"

        A dbisql redirection's has not been changed, and dbisqlc is deprecated.

        Recommend to use a dbisql not dbisqlc.

If you want to redirect to output file with input file,
you need to use a read statement and enclose the input/output file with double qoute symbol.
And need to change the redirect from > to >& like below.

> dbisqlc -c dsn=xxx -q -nogui "read input.sql >& output_file"

[input.sql]

select @@version;

An output_file is generated with above way like below.

Ex)
[hpita:/gjang]dbisqlc -c dsn=hpita_iqdemo -q -nogui "read a.sql >& a.log"

[hpita:/gjang]cat a.log
    ...
  'SAP IQ/16.0.0.808/150105/P/sp08.22/ITANIUM/HP-UXi 11.31/64bit/2015-01-05 12:04:21'

[Reference]

** dbisqlc Interactive SQL Classic Utility (Deprecated)  --IQ15.4 Utility Guide

(SyBooks Online)

HTH

Gi-Sung Jang