DB Software Laboratory - supplier of Business Automation and ETL software - Re:How do I check to see if a table is empty?

Client Login

	Support Forum	Forum Threaded View Rules Help

Welcome, Guest
Please Login or Register. Lost Password?

Support Forum

Forum

Support

Re:How do I check to see if a table is empty? (1 viewing) (1) Guests

Favoured: 0

TOPIC: Re:How do I check to see if a table is empty?

Forum Tools

#771

Frank (User)

Fresh Boarder

Posts: 6

How do I check to see if a table is empty? 2 Months ago	Karma: 0
As one of the routines in my package, I would like to check to see if a SQL table is empty, or populated. If the table is empty, then the next part of the package will process. If the table has any data in it, the package will fail and abort. I am using ELT PRocessor Pro

Report to moderator Logged

Logged

The administrator has disabled public write access.

#772

admin (Admin)

Admin

Posts: 148

Re:How do I check to see if a table is empty? 2 Months ago

Karma: 0

Frank

All you need to do is to use SQL Data Check _object_.

SQL Data Check uses SQL _script_s to check data in the data_base_.
For example user may write following SQL:

Select count(*) from table

Execution will be successful if the value of first field of query is more than 0
Execution will fail if the value of first field of query is equals to 0 or less than 0 or field type is not numeric.

Peter

Report to moderator Logged

Logged

The administrator has disabled public write access.