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.
SAP Knowledge Base Article - Preview