This example accesses ORACLE data ... When a PROC SQL view is created from a Pass-Through query, the query's DBMS connection information is stored with the view. Therefore, when you reference the PROC ...

Any data that does not fall into the traditional field structure (alpha, numeric, dates) of a relational DBMS. Examples of complex data types are bills of materials, word processing documents ...

See Using DBMS Data in Version 7 and Version 8 for examples. If you are using descriptors, you can specify them in the SQL procedure's INSERT, DELETE, and UPDATE statements. You can also use these ...