SELECT statements

You can use SELECT statements on SMI tables wherever you can use SELECT against ordinary tables.

For example, you can use SELECT statements ordinary tables from DB-Access, in an SPL routine, with Informix® ESQL/C, and so on.
Restriction: You cannot meaningfully reference rowid when you query SMI tables. SELECT statements that use rowid do not return an error, but the results are unpredictable.
All standard SQL syntax, including joins between tables, sorting of output, and so on, works with SMI tables. For example, if you want to join an SMI table with a non-SMI table, name the SMI table with the following standard syntax:
sysmaster[@dbservername]:[owner.]tablename

Copyright© 2019 HCL Technologies Limited