Use of proxy table in sybase IQ

[Former Member]

Please help me on this what is the use of proxy table and on what purpose we should use

[tayeb_hadjou]

Hi Goyal,

Proxy table named also existing tbale, is a table visible in SAP IQ database and mapped to a different table which physically exists in a remote Database SAP IQ, SAP ASE, Oracle or others.

They can be used to copy data from/to local IQ Database and remote database, query remote data etc.

Regards,

Tayeb.

[Former Member]

Hi Tayeb,

          Thanks now i am able to understand

[Former Member]

Hi Tayeb,

               Kindly resolve my below problem

     How can i union of three table sp_iqconnection() and sp_iqtransaction and sp_iqcontext()

i want output in below format(add one more column for IDLE and INTENSIVE query)

if query running more then 30 minutes means its an intensive query

if user is not doing anything past 30 minutes means its idle

i want output in below format

connectio type	ConnHandle	Userid	LastReqTime	LowestIQCursorState	IQthreads	TempWorkspace	Nodeaddr	LastIdle(in hours)	cmd
IDLE	10	xxx	17:13.4	None	10	200	10.12.12.12	1	select * from tmp
INTENSIVE	11	yyy	15:10:05	fetching	20	300	10.14.13.19	NA	select * from sp_iqcontecx

if there is any new method please help me

[tayeb_hadjou]

Updated in your other post http://scn.sap.com/thread/3688516 .

[Former Member]

Hi Tayeb,

               Can you write complete this query ?? that could make me full understanding

because i am not able to add new column and map with IDLE and INTENSIVE

Hope you will write full query