Re: load from flat file

Gursoy YERLI wrote: > > Hi Folks, > > I am trying to create stored procedure to load data from flat file into > a table. > > load from "data.txt" > insert into table_name> > does not work. Is there any other way to accomplish this. Thank you. Can't do it. The 'load' command is NOT an SQL statement but a dbaccess built in command. It is therefore not available to SPL. If you have 4GL, 4GL also has the 'load' command built into the language so you can write commandline load programs using it and since SPL does not do dynamic statement execution the 4GL program will be much more powerful anyway. Art S. Kagel