New answers tagged sybase
Sybase ASE retrieves port numbers for the listeners from the interfaces file. On *nix systems, this is typically in the Sybase Home directory ($SYBASE/interfaces) On Windows systems it's called interfaces.ini and can be found in %SYBASE%, which is likely to be c:\sybase (I think..been a while since I've run on Windows). I believe you can launch the GUI ...
I've promoted about 2X speed by named pipe. First step:(create a named pipe) mkfifo p1 Second step:(waiting to convert) cat p1| iconv -f GBK -t UTF-8 > target.file Last step:(export to p1, see the sql scripts below) SET OPTION TEMP_EXTRACT_NAME1 = 'p1'; SELECT * FROM MY_TABLE; SET OPTION TEMP_EXTRACT_NAME1 = '';
I'm using a function derived_stat() for selecting indexes/tables on which should be executed a reorg rebuild command
Top 50 recent answers are included