Re: Sort Sequence of SQL Scripts

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Maybe shared lang id can be set in the connection properties.

At any rate, in my experience, the shared sequences look as if they are 
sorting as ASCII rather than EBCDIC - IIRC, numbers end up before 
letters, which is the opposite of EBCDIC.

Cheers
Vern

On 5/1/2018 1:00 PM, Rob Berendt wrote:
> SET OPTION does not seem to be executable from within Run SQL scripts.
>
>
> Rob Berendt
> -- IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 
> 1600 Mail to: 2505 Dekko Drive Garrett, IN 46738 Ship to: Dock 108 
> 6928N 400E Kendallville, IN 46755 http://www.dekko.com From: "Luis 
> Rodriguez" <luisro58@xxxxxxxxx> To: "Midrange Systems Technical 
> Discussion" <midrange-l@xxxxxxxxxxxx> Date: 05/01/2018 01:48 PM 
> Subject: Re: Sort Sequence of SQL Scripts Sent by: "MIDRANGE-L" 
> <midrange-l-bounces@xxxxxxxxxxxx> Hi all, Not near a machine right now 
> (today is a holiday in Venezuela) and not sure if anyone has posted 
> this before but, have you tried to use the SET OPTION SRTSEQ() 
> statement? One of the parameters (*langidshr?) *may* give you the sort 
> sequence you need. HTH, Luis Rodriguez