Excluding system views/tables from 'show rec' in QSHOW ?

[Michel Adam]

Does anyone know of a way to exclude the system views when doing a 'show
rec' in QSHOW 8.41G (Windows platform)?

 

I have a relational db (SQL Server) which has the standard 'dbo' schema,
but a 'show rec' will also list all the views (sys, INFORMATION_SCHEMA
...), and will issue an error message when it comes across a 'record'
that is greater than 32768.

 

I tried using 'pattern' and 'to' but to no avail. Show rec patt "dbo@"
in xyzdb will not return anything.

 

Thanks  

 

Michel Adam

michel_adam at gov.nt.ca

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20120712/9628eb49/attachment.htm>