Re: Insert Data to iseries

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.