<< Click to Display Table of Contents >> Navigation:  SshNetIbmi Class > SshNetIbmi Methods > CheckSqlTableExistsXmlSvc Method

Summary

Note: Only works for DDS defined or SQL defined tables. It appears that flat files created with CRTPF will not show up in SYSTABLES.

 

Internally uses SQL count query.

 

Ex: SELECT COUNT(*) as TABLECOUNT From QSYS2/SYSTABLES WHERE TABLE_SCHEMA='QIWS' and TABLE_NAME='QCUSTCDT'

 

Parameters

sTableName - SQL table name. Up to 30 characters

 

sTableLibrary - SQL table schema/library

 

Returns

True-Exists, False-Does not exist or error