>Hi all
>I have some tables with isl extension(written in Cobol).
>When I connect through ODBC I can retrive it and evrything works fine
>until I try to update it, then I have a problem, because my source table doesn't have a primary key.(I can find some combination of fields to be unique but remote view allows primary key only for one field not expression).
>?
>Thanks in advance
Miroslav,
You can use a comple primary key, just click all teh fiedls involved. SQL (views) is for relational databases. Relational database tables
all have primary keys, if a table does not have a PK it is not relational and SQL probably won't work on it.