Re: SERVER CRASH on execute UNLOAD CMD

#1

The UNLOAD statement can accept a variable containing the filename. Used
this way, you do not need to use EXECUTE IMMEDIATE. Since the statement is
not being re-parsed, the filename's backslashes do not need to be doubled.

It's not clear that you're seeing a server crash here, but rather just an
error being returned indicating that the filename is invalid.

set @f=getEDIROOT(@md)+@fn;
UNLOAD SELECT replace( @RESULT, '\x0A',char(13)+char(10) )
TO @f
QUOTES OFF ESCAPES OFF HEXADECIMAL OFF APPEND ON;

Whitepapers, TechDocs, bug fixes are all available through the iAnywhere
Developer Community at http://www.ianywhere.com/developer

"Torsten Brinkmann" <t.brinkmann (AT) svs_ungueltig (DOT) de> wrote

Quote:

Hello,
i' ve some probs with server crash while UNLOAD SELECT statement with
execute immediate command.
I use UNC Path to UNLOAD/LOAD data. The LOAD / UNLOAD needs 3 backslashes
in
path to work.

set @f=getEDIROOT(@md)+@fn;
execute immediate 'UNLOAD SELECT replace( @RESULT, ''\x0A'',
char(13)+char(10) ) TO '''+LPATH(@f)+''' QUOTES OFF ESCAPES OFF
HEXADECIMAL
OFF APPEND ON';
message @RESULT type info to client

Calling UNLOAD without LPATH function will show Access Error (File or path
does not exist).

-- Function LPATH because LOAD / UNLOAD need '\' 3x .
CALL DROPMETHODE('LPATH');
create function LPATH(@path_ char(255)) returns char(255) NOT
DETERMINISTIC
begin
if left(@path, 1) = '\' then
return '\\' + @path_;
else
return @path_;
end if;
end;
Im using Adaptive Server Anywhere 9.0.2.3244

Is it a bug or feature

? Some tips to workaround ? What is correct
usage
of UNC with LOAD / UNLOAD ?
Best regards,

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: SERVER CRASH on execute UNLOAD CMD

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general

Re: SERVER CRASH on execute UNLOAD CMD - 04-26-2006 , 09:22 AM