Re: Insert Data to iseries

Luis,

What is the format of the data in the file? If it's CSV, Tab
separated, or otherwise a delimited or fix length. The system has a
built in utility to load the data.

Copy From Import File - CPYFRMIMPF

To use CPYFRMIMPF, you'd need to copy the stream file into a directory
of the IFS unless the stream file is is a location accessible by the
system using the built in SMB or NFS clients.

Additionally, the IBM iSeries Access for Windows products include some
file transfer functionality to transfer directly from a PC file.

Lastly, if you chose to roll your own transfer using JDBC and you want
good performance you'll want to do batch inserts instead of one row at
a time. Take a look at the addBatch() methods available in
AS400JDBCStatement, AS400JDBCPreparedStatement, and
AS400JDBCCallableStatement.

HTH,
Charles Wilt


On Mon, Aug 2, 2010 at 5:35 PM, Luis Fernandes <agentelu@xxxxxxxxx> wrote:

Hi im java programmer ,

I have a text file that have 30,000 rows, and each row have 200 char. I need
to parse and insert this information into a physycal file., and a look for
the best way to do that.

I use the Jt400.jar in my project, and want to xecute insert via sql. But my
question is : this is the best way to insert data to iseries ? what about
the error ; what gonna happen if a exception comes ?

there is onother funtiolatity in iseries that allow me do the same job, but
handling the error ?

My fear is when somithing happen, i i use sql and something d«goes bad the
process stop in the middle, i dont want this.

Can someone help or show me the diferent ways to solv this issue ?

regards !

--
Luis Claudio
http://agentelu.blogspot.com/
www.backbone.it.ao
+244 923416616
--
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.