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 for Me (Login required).

Search for additional results

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