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 almost c...

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 use the ...