Re: JDBC2.1 and Informix LOAD query

Posted in 2000

Obnoxio The Clown — Tue, 20 Jun 2000 11:32:43 BST — source: Informix-list mailing list archive (1991-1998)

From: Steph Monier <steph@reef.com> > >Using IFX2000 9.20 UC2 under Sun Solaris, I'm trying to pass through the >jdbc driver the query "load from xxxx.unl insert into table" with an >executeUpdate method. My unl files appear in the classpath, but jdbc >doesn't understand the query ... LOAD is an extension built in to dbaccess only. It's not part of "standard" SQL. So you have to look at invoking dbaccess, or using dbload or HPL. Or writing your own. Or something. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com