RE: SQL in Java - Performance

CRTLF   SRTSEQ(*LANGIDSHR)

or in the DDS source use the ALTSEQ file level keyword.


HTH,

Charles Wilt
--
iSeries Systems Administrator / Developer
Mitsubishi Electric Automotive America
ph: 513-573-4343
fax: 513-398-1121
 

> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx 
> [mailto:java400-l-bounces@xxxxxxxxxxxx]On Behalf Of Paul Holm
> Sent: Wednesday, June 29, 2005 1:19 PM
> To: java400-l@xxxxxxxxxxxx
> Subject: SQL in Java - Performance
> 
> 
> Charles,
> 
> Yes this is a very good tip.  Would there then be an 
> equivalent to create a
> keyed Logical File that ignores the case and provides index 
> optimization?
> >From our experience this is a very frequent need.
> 
> Thanks,  Paul Holm
> 
> Business: 760-432-0600   Cell:  760-415-8830
> PlanetJ - Makers of WOW  (AKA... WebSphere on Steroids)
> You Need Web?  You Need WOW!  www.planetjavainc.com
> WOW!!!!
> 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.
> 
> 
> 
> 
> 
> 
> 
> 
> **************************************************************
> **************
> ****
> The information in this message is confidential and may be legally
> privileged. It is intended solely for the addressee; access to this
> email by anyone else is unauthorised.
> 
> If you are not the intended recipient: (1) you are kindly requested
> to return a copy of this message to the sender indicating that you
> have received it in error, and to destroy the received copy; and (2)
> any disclosure or distribution of this message, as well as any action
> taken or omitted to be taken in reliance on its content, is prohibited
> and may be unlawful.
> **************************************************************
> **************
> ****
> 
> 
> 
> ------------------------------
> 
> --
> This is the Java Programming on and around the iSeries / 
> AS400 (JAVA400-L)
> digest 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.
> 
> 
> 
> End of JAVA400-L Digest, Vol 3, Issue 230
> *****************************************
> --
> No virus found in this incoming message.
> Checked by AVG Anti-Virus.
> Version: 7.0.323 / Virus Database: 267.8.6/33 - Release Date: 
> 6/28/2005
> 
> --
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.323 / Virus Database: 267.8.6/33 - Release Date: 
> 6/28/2005
> 
> 
> -- 
> 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.
> 
>