dbload - sintaxe error

dbload - sintaxe error

Post by Obnoxio The Clow » Sun, 31 Dec 1899 09:00:00




Quote:

>command
>dbload -d dbpplay -c inf -l erro -e 1 -n 1
>-----------------------------------------------------------------------
>FILE teste.txt  (a 1-10, b 11-30, c 31-50, d 51-59)

You need a semi-colon (;) at the end of this line.

Quote:>INSERT INTO teste VALUES (a,b,c,d)

You need a semi-colon (;) at the end of this line.

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

 
 
 

1. dbload - sintaxe error

command
dbload -d dbpplay -c inf -l erro -e 1 -n 1
-----------------------------------------------------------------------
FILE teste.txt  (a 1-10, b 11-30, c 31-50, d 51-59)
INSERT INTO teste VALUES (a,b,c,d)

Syntax error occurs on statement above.
Line 2          Character 1
---------------------------------------------------------------------
File teste.txt
12345678910111213141516171819202122232425262728293031323334353637383940
----------------------------------------------------------------------
table teste
a                    char(20)                       yes
b                    char(30)                       yes
c                    char(40)                       yes
d                    char(50)                       yes
--
Thanks in Advanced

Fbio Antunes
Fanix Consultoria Ltda.
Brasil - SP

Sent via Deja.com http://www.deja.com/
Before you buy.

2. request for database bug 'war stories'

3. sintaxe

4. Nederlandsetalige Microsoft developers OPGELET!

5. help! dbload fails without error message

6. Error message 8961

7. dbload error

8. postgres bombs for continous selects....

9. Dbload error trapping

10. Dbload error