Is there a way to make SQL respect the DDS ALTSEQ keyword?
For example, given a table 'TESTFILE' with the following DDS definition:
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
MAX ( FIELD ) 0002
SELECT FIELD FROM TESTFILE ORDER BY FIELD
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
Senior Technical Developer
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
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.
This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact