[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: SQL LOAD Invalid in SQR?



LOAD ASCII is not a SQL command, and it's not a command that your database
recognizes: it's a command that SQL Query recognizes to simplify loading data to
your database.  SQR sends the command to your database for processing.  If the
database recognizes it, no problem, even if it's not part of the SQL standard.
However, this is not the case with the load ascii command.  To the equivelant in
SQR, you'll have to read the file and send it to the database with insert
statements.

Good luck,
Tim





Mary Mullinax <marymullinax@MINDSPRING.COM> on 06/16/99 11:27:05 AM

Please respond to SQR-USERS@list.iex.net

To:   Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
cc:    (bcc: Tim Green/HWRD/ASG_Louisville/NAD)
Subject:  SQL LOAD Invalid in SQR?




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
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