Re: Insert Data to iseries

[James Perkins <jrperkinsjr@xxxxxxxxx>]

A physical file is basically just an SQL table. You're best to just use SQL
to do the insert.

For exceptions, you would/could see just the normal SQL exceptions that you
would see with any JDBC connection. Like any SQL insert there is no
guarantee that the statement will not be successful. If you're using
commitment control though, it shouldn't be an issue.
--
James R. Perkins


On Mon, Aug 2, 2010 at 14:35, 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.