scottklement.com

Thanks Scott for the reply.

I found the sqljdbc.jar file

It's in the directory
/QIBM/UserData/Java400/ext

Perhaps I referred to an old article of yours in which you indicated this directory.

Thanks again

Thanks for the reply.

The problem was the CCSID.

I solved it like this:

CPYFRMSTMF FROMSTMF('/dir/file.txt')
TOMBR('/QSYS.LIB/LIBR.LIB/FILEX.FILE/FILEX.MBR')
MBROPT(*REPLACE)
STMFCCSID(1208)

Thanks again

I need to copy a txt file to as400.

If I do CPYFRMPCD or CPYFRMSTMF the accented characters move the length of the file 1 or 2 positions.

What can I do to avoid this?

Thank you

Thanks for the reply Scott.

If programs work ONLY if a CLASSPATH exists, I certainly did the ADDENVVAR command.

The question is, how do I see where I put the jar file?

If it's not in /java/jdbc/ where is it?

Is there a command to see where I put it?

Best regard

PS:
The ADDENVVAR command was ...

Good morning, I read data from a SQL server.

My as400 is V6R1

In Scott's manual, it says to:

Set CLASSPATH as follows:
ADDENVVAR ENVVAR(CLASSPATH) VALUE('/java/jdbc/jdts-1.3.1.jar')

In my as400 in the indicated directory:
/java/jdbc/
jdts-1.3.1.jar file is missing

How does it all work?

If I ...