Re: SQL and ALTSEQ

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

ALTSEQ is ignored, IIRC, and as you've found. To get similar function, take 
a look at the sort sequence setting in interactive SQL (F13, option 1). 
Also, I think there is a language ID.

HTH
Vern

At 05:36 AM 10/14/2004, you wrote:
> Is there a way to make SQL respect the DDS ALTSEQ keyword?
>
> For example, given a table 'TESTFILE' with the following DDS definition:
>
> A                                          ALTSEQ(QASCII)
>
> A              R RECORD
>
> A                FIELD          4A
>
> A              K FIELD
>
>
> If I put 3 records into the file, with the values for 'FIELD' of '0001'
> '0002' and '000A', the collating sequence specified should index the records
> in the following order:
>
> 0001
> 0002
> 000A
>
> In RPG a *HIVAL SETGT followed by a READP correctly returns 000A as being
> the last record.
>
> However when attempting access the table with SQL, the ALTSEQ keyword isn't
> being respected.
>
> SELECT MAX(FIELD) FROM TESTFILE
>
> Results in:
>
> MAX ( FIELD )
>     0002
>
> SELECT FIELD FROM TESTFILE ORDER BY FIELD
>
> Results in:
>
> FIELD
> 000A
> 0001
> 0002
>
> Looking at the DB2 manuals it seems that DB2 looks for a collating sequence
> specified at database level - not at file level and so is not respecting my
> ALTSEQ keyword - can I force it to?
>
> Thanks in advance,
> Stu
>
> Stuart Bramley
> Senior Technical Developer
> Skandia Life::GroupIT
> Southampton
> t: 023 80 72 64 29 e: stu.bramley@xxxxxxxxxxxxx
> IBM Certified Specialist
> If you are not the intended recipient, please notify the sender by return 
> email and then delete the message from your computer. The Skandia UK Group 
> reserves the right to monitor e-mail communications through its networks.
>
> No contract may be concluded on behalf of the Skandia UK Group by email.
>
> Skandia Life Assurance (Holdings) Limited Skandia Life Assurance Company 
> Limited Skandia MultiFUNDS Limited, Skandia Investment Management Limited.
>
> Registered Nos: 1606702, 1363932, 1680071, 4227837, England
> Registered Office: Skandia House, Portland Terrace, Southampton SO14
> 7EJ, United Kingdom
>
> Royal Skandia Life Assurance Limited Registered No : 24916 Isle of Man
> Registered Office: Skandia House, King Edward Road, Onchan, Isle of Man 
> IM99 1NU, British Isles
>
> Skandia Life Assurance Company Limited, Skandia MultiFUNDS Limited, 
> Skandia Investment Management Limited and Royal Skandia Life Assurance 
> Limited are authorised and regulated by the Financial Services Authority for UK
> investment business.
>
> Internet: www.skandia.co.uk
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.