LOAD is not an SQL command. I'm not sure what database you are using, but that looks
a lot like SQL*Loader control file syntax. DBI implements valid SQL commands.
-----Original Message-----
From: Liu, Jenny [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 01, 2001 11:05 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: load file into table, get syntax error
I tried to load some data from a text file into a table. The statements and
the error message are as following:
Please advise.
Thanks
Jenny
$Sql_stmt = "LOAD FROM cac_pos_format.load INSERT INTO cac_pos_format";
$sth = $dbh->do($Sql_stmt);
SQL error: -201
Error text: SQL: -201: A syntax error has occurred.
Error: Start Rollback....10:58:17
Error: Rollback Completed....10:58:17
