I guess i worded my question wrong, how can I say to create a vlatile table if it does not exist? Like i need it to check first if that table is already out there first than create, if not just a insert of my select statement
1: Volatile table it is valid in that session only.So if there is a create statment for that table in session then it wuold be created else it would not exist.
2:If it is for permanent table and you are trying BTEQ script ,you can try something as follows
.SET ERRORLEVEL 3807 SEVERITY 0 ;
DEL FROM TAB2 ;
.If errorcode =0 then .goto tab2
Insert into tab2