LOAD file

Posted in 2006

zackary.evans@gmail.com — 16 Jun 2006 09:08:59 -0700 — source: Usenet: comp.databases.informix

since I can't use the LOAD command inside a stored proc in informix...how can I load a datafile into a table within a proc?

↪ replying to zackary.evans@gmail.com

zackary.evans@gmail.com — 16 Jun 2006 09:22:06 -0700 — source: Usenet: comp.databases.informix

zackary.evans@gmail.com wrote: > since I can't use the LOAD command inside a stored proc in > informix...how can I load a datafile into a table within a proc? is it possible to run an executable from INFORMIX, where I could execute the "dbload" command? this is v10 btw.

↪ replying to zackary.evans@gmail.com

Jonathan Leffler — 16 Jun 2006 09:55:36 -0700 — source: Usenet: comp.databases.informix

zackary.evans@gmail.com wrote: > zackary.evans@gmail.com wrote: > > since I can't use the LOAD command inside a stored proc in > > informix...how can I load a datafile into a table within a proc? > > is it possible to run an executable from INFORMIX, where I could > execute the "dbload" command? > > this is v10 btw. The SYSTEM statement in SPL can be used to run a shell script that runs DB-Access or DB-Load or ...