SAP Knowledge Base Article - Preview

2537500 - DBISQL: query Execution time is missing and extraneous commas in row count - SAP IQ 16.1

Symptom

  • After upgrade to IQ 16.1 SP02 from IQ 15.4, the DBSISQL metadata output format changed.
     
  • The query execution time is not shown in IQ 16.1 while it is shown in IQ 15.4:
     
    • In IQ 15.4, using the -nogui mode shows Execution time:

>dbisql -c "uid=DBA;pwd=xxx;eng=xxxxx;links=tcpip(port=xxxx)" -nogui
(DBA)> select @@version, getdate()
@@version                                                                                                                        getdate()          
--------------------------------------------------------------------------------------------------------------------------------------------------------
Sybase IQ/15.4.0.3027/130221/P/ESD 3/RS6000MP/AIX 6.1.0/64bit/2013-02-21 11:27:49                                                2017-09-19 14:37:59.616
(1 rows)
Execution time: 0.008 seconds
(DBA)>

    • In IQ 16.1, using the -nogui mode does not show Execution time:

>dbisql -c "uid=DBA;pwd=xxx;eng=xxxxx;links=tcpip(port=xxxx)" -nogui
(DBA)> select @@version, getdate()
@@version                                                                   getdate()
-----------------------------------------------------------------------------------------------------
SAP IQ/16.1.020.528/10528/P/sp02/RS6000MP/AIX 7.1/64bit/2017-07-14 14:54:04 2017-09-19 14:38:19.53652
(1 rows)
(DBA)>

    • In IQ 16.1, executing a SQL script from a file does not show Execution time:

> more my.sql
select @@version, getdate()
 
>dbisql -c "uid=DBA;pwd=xxx;eng=xxxx;links=tcpip(port=xxxx)" my.sql
@@version                                                                     getdate()
-----------------------------------------------------------------------------------------------------
SAP IQ/16.1.020.528/10528/P/sp02/MS/Windows 2012 R2/64bit/2017-07-14 14:45:44 2017-09-20 14:55:51.714
(1 rows)

    • In IQ 16.1, the same issue exists if the output is redirected to a file like in:

>dbisql -c "uid=DBA;pwd=xxx;eng=xxxx;links=tcpip(port=xxxx)" my.sql > my.out
>more  my.out
@@version                                                                     getdate()
----------------------------------------------------------------------------------------------------
SAP IQ/16.1.020.528/10528/P/sp02/MS/Windows 2012 R2/64bit/2017-07-14 14:45:44 2017-09-20 15:44:11.27

(1 rows)

  • The number is rows in the result set is returned with a comma (“,”) in IQ 16.1, like:
     
                    3,602 rows
     
    while it used to be without a comma (“,”) in IQ 15.4, like:
     
                    3602 rows

Read more...

Environment

  • SAP IQ 16.1
  • Interactive SQL

Product

SAP IQ 16.1

Keywords

isql_command_timing, option, default, .isqlPreferences17_64, -d1, CR 810944, CR#810944, 810944, metadata , KBA , BC-SYB-IQ , Sybase IQ , Product Enhancement

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.