FW: ASE 15.7: Create a Remote Server to SAP IQ 16.0

ASE 15.7: Create a Remote Server to SAP IQ 16.0
March 12, 2014

Create the remote server entry in the interfaces file; sql.ini (Windows) or interfaces (UNIX).

[myIQServer]
master=TCP,myIQHost,4091
query=TCP,myIQHost,4091

Read more at ARBIME
syLogo

Share Button

FW Howto: List Invalid Views and fix the views in SAP Sybase IQ

From the fine folks at ARBIME:

select U.user_name + '.' + T.table_name 
from sysobject O, systab T, sysuser U 
where T.object_id = O.object_id 
  and U.user_id = T.creator  
  and O.status = 2 /* Invalid */   
  and O.object_type = 2 /* views */

http://arbime.wordpress.com/2013/02/11/list-invalid-views-in-sybase-iq/

You can usually fix the invalid views by simply recompiling:

alter view MY_VIEW recompile

and enabling:

alter view MY_VIEW enable

You should review the changes made to any referenced tables/views to ensure that the invalid view doesn’t need to be rewritten.

Share Button