Remove

[Katie_Pentz@xxxxxxxxxxxxxxxxx]

                      java400-l-request@m
                      idrange.com                To:       
java400-l@midrange.com
                      Sent by:                   cc:
                      java400-l-admin@MID        Subject:  JAVA400-L digest, 
Vol 1 #475 - 1 msg
                      RANGE.COM


                      10/17/02 01:00 PM
                      Please respond to
                      java400-l










Send JAVA400-L mailing list submissions to
 java400-l@midrange.com

To subscribe or unsubscribe via the World Wide Web, visit
 http://lists.midrange.com/cgi-bin/listinfo/java400-l
or, via email, send a message with subject or body 'help' to
 java400-l-request@midrange.com

You can reach the person managing the list at
 java400-l-admin@midrange.com

When replying, please edit your Subject line so it is more specific
than "Re: Contents of JAVA400-L digest..."


Today's Topics:

   1. RE: Writing to Physical File Members (Override) with JAVA (Clapham,
   Paul)

--__--__--

Message: 1
From: "Clapham, Paul" <pclapham@core-mark.com>
To: java400-l@midrange.com
Subject: RE: Writing to Physical File Members (Override) with JAVA
Date: Wed, 16 Oct 2002 12:09:50 -0700
Reply-To: java400-l@midrange.com

I use an "alias" to do that.  The SQL statement to create an alias looks
like this:

CREATE ALIAS aliasname FOR file(member)

Once you have executed this, you can proceed as if "aliasname" were a real
file in your system, i.e. you can do SELECTs over it and so on.  There's
also a DROP ALIAS aliasname statement in SQL which you should use when you
remove the underlying member.

PC2

-----Original Message-----
From: Jerrold_Bisera@countrywide.com
[mailto:Jerrold_Bisera@countrywide.com]
Sent: October 15, 2002 17:35
To: JAVA400-L@midrange.com
Subject: Writing to Physical File Members (Override) with JAVA


This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
I have some java code that is running SQL Insert/Update Statements in
Batch.  How do I direct these statements to update a particular member in
a file? Is there something similar to the ovrdbf command?


--__--__--

_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
digest list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.



End of JAVA400-L Digest