|
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.