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
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.