|
I've been trying to read an ascii delimited file into a temp
table in my SQR by using the following procedure (after creating the temp table
in the Setup Section).
begin-procedure Insert_Temp_Data
begin-SQL LOAD ASCII c:\temp\cssxfer.txt
PS_TEMP_TRAIN
end-sql commit end-procedure Insert-Temp-Data The SQR blows up every time saying
"Invalid SQL Command - LOAD" yet when I cut/paste the LOAD
command to SQL Query it works perfectly.
I have verified that the temp table is
there when the program bombs.
Any ideas? I have written about a 1/2 page procedure to read in
the variables from a fixed format file to replace the one line but can't
understand why it won't work.
SQL Query version is V3.2.0
SQRW Version is V2.5.5
Many thanks...Mary
Mullinax marymullinax@mindspring.com
|