search

luboshl / aseisql

Automatically exported from code.google.com/p/aseisql
0 stars 0 forks source link

Integration Proxy-Tables #53

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
It would be a nice feature if aseisql can handle proxytables.

The best solution would be a seperate branch in the object browser ( like 
Sybase Central ).

If this is not possible it would be nice when "Table DDL" writes the 
missing "external table at ... " 

Greets from Germany
Stefan

Original issue reported on code.google.com by stefan.w...@telekom.de on 19 Oct 2009 at 12:59

GoogleCodeExporter commented 9 years ago 
Ok. 
I think it will be a separate branch.

Original comment by daggett....@gmail.com on 19 Oct 2009 at 1:27

GoogleCodeExporter commented 9 years ago 
short analysis:

the type of the proxy table in sysobjects is 'U' (strange).
to filter out proxy tables we can use 
select * from sysobjects where sysstat2 & 1024 = 1024
definition stored in  sysattributes
definition types (sysattributes.object_info2):
 1 table (view) ???
 2 directory
 3 rpc
 4 file
 5 function
 6 internal

Original comment by daggett....@gmail.com on 19 Oct 2009 at 7:52

GoogleCodeExporter commented 9 years ago

Original comment by daggett....@gmail.com on 24 Oct 2009 at 2:34

GoogleCodeExporter commented 9 years ago 
For now proxy tables will be located in tables as soon the type in sysoobjects 
is the
same as for usual tables.

In revision #185 there is a correction for DDL generation.
It's not fully tested with directory, file, rpc remote table types.

Original comment by daggett....@gmail.com on 1 Nov 2009 at 9:09