Reload the query only if the first script executes successfully

[#1]

Hi,

Is there a way to reload data only when the first query succeeds. To be clear, Select count(*) from forec where desc='Final'. If the query returns '1', I need the other query which follows to execute. If the Query returns' 0', I need the reload to fail. The other queries are no way related to the above query. How to do that?

--Santhosh

[#2 · Accepted solution]

Maybe something like this:

Table1:

load x ;

sql Select count(*) from forec where desc='Final';

if peek('x') = 1 then

table2:

load y;

sql select...

else

exit script;

end if;