Lost Password?
No account yet? Register
Increase font size Default font size Decrease font size Narrow screen resolution Wide screen resolution Auto adjust screen size default color red color blue color yellow color orange color
Support Forum
Welcome, Guest
Please Login or Register.    Lost Password?
Re:How do I check to see if a table is empty? (1 viewing) (1) Guests
Go to bottom Post Reply Favoured: 0
TOPIC: Re:How do I check to see if a table is empty?
#771
Frank (User)
Fresh Boarder
Posts: 6
graphgraph
User Offline Click here to see the profile of this user
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
graph
User Online Now Click here to see the profile of this user
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.
Go to top Post Reply
Powered by FireBoard

Testimonials

If we compare to manual processing this program save more than 200 hours in month.

C Gandhi
Nesa-Canada

 

Free Newsletter

Please provide your Name and Email address so that we can tell you about latest releases, new features and free offers.






b.150.100.16777215.0..Screenshots.AdvancedETLEnt.Advanced_ETL_Processor_Ent_Ftp_action1.jpg
DB Software Laboratory - Intel Software PartnerDB Software Laboratory - My SQL Ready Partner
DB Software Laboratory Embacadero Technology Partner