Knowledge is made to be shared
Number of records
This job displays the number of records in each table:
static void getTableRecordCount(Args _args)
{
#AOT
Name name;
NumberOf recordCount;
TreeNode treeNode;
SysDictTable sysDictTable;
;
treeNode = TreeNode::findNode(#TablesPath);
treeNode = treeNode.AOTfirstChild();
while (treeNode)
{
name = treeNode.AOTname();
sysDictTable = SysDictTable::newTableId(treeNode.applObjectId());
recordCount = sysDictTable.recordCount(false);
if (recordCount)
info (strfmt("@SYS26868", name, recordCount));
treeNode = treeNode.AOTnextSibling();
}
}
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.