output to a flat file from a B2/400 table

Hey Everyone,



Well, I'm trying to use Scott's JDBC code for RPG (For everything else
it works great Scott. Great learning tool as well.) to place the
contents of a DB2/400 table into a flat file in the IFS.



Everything works just fine up to the point of jdbc_ExecUpd() on
statement SELECT * INTO OUTFILE /home/mydir/myfile.txt FROM MYLIB/MYFILE
on our V5R4 system. I'm using jtopen rather than the installed Java
SDK.



I keep getting a RNX0301 error - Java exception received when calling
Java method.



Message ID . . . . . . : RNX0301 Severity . . . . . . . : 50


Message type . . . . . : Escape


Date sent . . . . . . : 05/05/11 Time sent . . . . . . :
15:16:53




Message . . . . : Java exception received when calling Java method.


Cause . . . . . : RPG procedure JDBC_EXECU in program MONNIG/JDBCR4
received

Java exception "java.sql.SQLException: [SQL0104] Token OUTFILE was not


valid. Valid tokens: :. Cause . . . . . : A" when calling method


"executeUpdate" with signature "(Ljava.lang.String;)I" in class


"java.sql.Statement".


Recovery . . . : Contact the person responsible for program
maintenance to

determine the cause of the problem.


Technical description . . . . . . . . : If the exception indicates
that the

Java class was not found, ensure the class for the method is in the
class

path. If the exception indicates that the Java method was not found,
check

the method name and signature. If the signature is not correct, change
the

RPG prototype for the method, or change the Java method, so that the
return

type and parameter types match. You can determine the signatures for
all the

methods in class XYZ using command QSH CMD('javap -s XYZ').



Abstract class executeUpdate is in class java.sql.Statement. Here's the
QSH output.



public abstract int executeUpdate(java.lang.String);

throws java/sql/SQLException

Signature: (Ljava/lang/String;)I



We are running



java version "1.4.2"

Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_19-b04)

Classic VM (build 1.4, build JDK-1.4, native threads, jitc_de)



Was SELECT * INTO UPDATE /flatfilename introduced in a more recent
version, am I doing something incorrectly or both?



Thanks in advance,



Gary Monnier