Re: Insert Data to iseries

[Charles Wilt <charles.wilt@xxxxxxxxx>]

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.