Re: System Tables in DB2/400

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

If you don't have SYSIBM, there is always the single record table QSQPTABL 
in library QSYS2.

Vern

At 12:25 AM 4/15/2005, you wrote:
> Hi
>
> I am using the following Query in STRSQL
>
> SELECT current timestamp FROM SYSIBM.SYSDUMMY1.
>
> But i am getting the error as such there is no table exist as 
> SYSIBM.SYSDUMMY1.
> Also while using an other query with the system tables such as 
> SYSIBM.SYSRELS and SYSIBM.SYSFOREIGNKEYS , i am getting same kind of error.
>  I know these are the table hold the system details in DB2.
> Could anyone tell the corresponding table in DB2/400?.
>
> Any pointer for this could also be helpful.
>
> Thanks,
> Siva
>
>
> ---------------------------------
> Do you Yahoo!?
>  Yahoo! Small Business - Try our new resources site!
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.