Is there a way to automated within a script to skip a tab. I have script that doesn't have to be run each time and want to put in something so when the script is run it can skip over a tab(s)?
the best way i found is to declare every tab as a subroutine, in this case I control the call for each one.
I use the 'If..then..elseif..else..end if'statement.
Example form the reference manual:
if a=1 then
load * from abc.csv;
sql select e, f, g from tab1;
if a=1 then; drop table xyz; end if;
So just wrap all the script around the if statement (on the tabs I may want to skip). Set A = 0 or 1? Then if A =1 it skips and if 0 if runs the script?
ok... mark a answered...please
That's up to you. Only you may do that.
You can move the tabs(that need to skipped) to the end and use Exit Script; before the scripts to be skipped.
Retrieving data ...