Hi,
I am using Erwin to develop my database.
But how do I define an index with the descending index parts ?
Best regards,
Martin Bos - mailto:martin.bos@cargomate.com
CargoMate BV - Meerwal 21 B - 3432 ZV - Nieuwegein - NL
tel. +31(0)30-6048811 - fax +31(0)30-6090000 -<http://www.cargomate.com/>
CargoMate - Global Logistics Software Solutions
Bangkok - Dubai - Amsterdam - Miami - San Francisco - Los Angeles
To unsubscribe, e-mail: dev-unsubscribe@icf.possenet.org
For additional commands, e-mail: dev-help@icf.possenet.org
Hi Martin,
Not to directly answer your question about ERWIN.
But if you intend to use any of the Progress Dataservers (Oracle and MSSQL)
then descending elements within an index are not supported.
If you can avoid using them by supplying an inverted key I would do that
instead.
For Integer/Decimal use a sort key defined as decimal or Integer and set
to (0 - Original key).
For Date use a sort key defined as integer and set to
(0 - Int(Original Date field)).
Character keys fields are much more difficult to solve without breaking a
load of internationalisation rules.
Oracle will allow you to access a whole index in either ascending or
descending mode and you can use INDEX-HINTS to control this. MSSQL
Dataserver does not support INDEX-HINTS at the moment.
Regards
David.
David Cassere
Soft Solutions Ltd
Matrix House, Bradford Road,
Wrenthorpe, Wakefield
WF2 0QH, England
Tel: +44 1924 200344 Extn 208 Fax: +44 1924 200418
EMAIL:david@impactxp.com Website:www.impactxp.com
-Original Message-
Sent: 20 March 2003 13:15
To: 'dev@icf.possenet.org'
Subject: Erwin
Hi,
I am using Erwin to develop my database.
But how do I define an index with the descending index parts ?
Best regards,
Martin Bos - mailto:martin.bos@cargomate.com
CargoMate BV - Meerwal 21 B - 3432 ZV - Nieuwegein - NL
tel. +31(0)30-6048811 - fax +31(0)30-6090000
-CargoMate - Global Logistics Software Solutions
Bangkok - Dubai - Amsterdam - Miami - San Francisco - Los Angeles
To unsubscribe, e-mail: dev-unsubscribe@icf.possenet.org
For additional commands, e-mail: dev-help@icf.possenet.org
To unsubscribe, e-mail: dev-unsubscribe@icf.possenet.org
For additional commands, e-mail: dev-help@icf.possenet.org
David,
Thanx for this warning.
I didn't know that.
We have another application running on oracle.
I'll check this.
Martin
-Original Message-
Sent: Thursday, March 20, 2003 2:56 PM
To: 'dev@icf.possenet.org'
Subject: RE: Erwin
Hi Martin,
Not to directly answer your question about ERWIN.
But if you intend to use any of the Progress Dataservers (Oracle and MSSQL)
then descending elements within an index are not supported.
If you can avoid using them by supplying an inverted key I would do that
instead.
For Integer/Decimal use a sort key defined as decimal or Integer and set
to (0 - Original key).
For Date use a sort key defined as integer and set to
(0 - Int(Original Date field)).
Character keys fields are much more difficult to solve without breaking a
load of internationalisation rules.
Oracle will allow you to access a whole index in either ascending or
descending mode and you can use INDEX-HINTS to control this. MSSQL
Dataserver does not support INDEX-HINTS at the moment.
Regards
David.
David Cassere
Soft Solutions Ltd
Matrix House, Bradford Road,
Wrenthorpe, Wakefield
WF2 0QH, England
Tel: +44 1924 200344 Extn 208 Fax: +44 1924 200418
EMAIL:david@impactxp.com Website:www.impactxp.com
-Original Message-
Sent: 20 March 2003 13:15
To: 'dev@icf.possenet.org'
Subject: Erwin
Hi,
I am using Erwin to develop my database.
But how do I define an index with the descending index parts ?
Best regards,
Martin Bos - mailto:martin.bos@cargomate.com
CargoMate BV - Meerwal 21 B - 3432 ZV - Nieuwegein - NL
tel. +31(0)30-6048811 - fax +31(0)30-6090000
-CargoMate - Global Logistics Software Solutions
Bangkok - Dubai - Amsterdam - Miami - San Francisco - Los Angeles
To unsubscribe, e-mail: dev-unsubscribe@icf.possenet.org
For additional commands, e-mail: dev-help@icf.possenet.org
To unsubscribe, e-mail: dev-unsubscribe@icf.possenet.org
For additional commands, e-mail: dev-help@icf.possenet.org
To unsubscribe, e-mail: dev-unsubscribe@icf.possenet.org
For additional commands, e-mail: dev-help@icf.possenet.org
Martin,
To set the descending property of an index field in ERwin, follow these steps:
- Select the physical model
- Select the index in the Progress Index Editor
- Select the field you want set descending in the right selection list (Members Tab)
- Right below the index fields selection list there is toggle-box DESC
Note: I'm using Erwin 3.5.2, possibly the user-interface changed in version 4.
Regards,
Dirk Mouthaan
Caesar Vitalogic
Internet wordt pas leuk als je mee kunt doen. Ga naar http://www.hetnet.nl
To unsubscribe, e-mail: dev-unsubscribe@icf.possenet.org
For additional commands, e-mail: dev-help@icf.possenet.org