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 , 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