AW: SQL Table with non-unique key - possible?

Hi,

Just a tip:
Do a reverse engineering with iSeries Navigator, i.e. let the iSeries
Navigator generate the SQL statement for your DDS described physical file.
If it is not possible you'll get a comment in the SQL script generated by
the iSeries Navigator. If it is possible you'll

- Open iSeries Navigator
- Open your connection
- Database
- Schema/Bibliothek auswählen
- auf physische Datei im Schema positionieren
- right click
- generate SQL

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Jeff Crosby
Gesendet: Thursday, July 05, 2007 20:49
An: 'Midrange Systems Technical Discussion'
Betreff: RE: SQL Table with non-unique key - possible?


That's the way the DDS file was created.

If it can't be done in SQL, then I'll create a nonkeyed table, along with an
non-unique keyed index.

I just thought it odd that it could not be done in SQL. But I did a lot of
searching and came up with no examples.