I have createda procedure and it was success but while execuing the call procedure statement by passing the parameter values I am facing an error stating Failure 3706:syntax error expected GLOBAL TEMPORARY.
I have not defined any temporary tables insie the PRO.
I have created a belo procedure for table baackup, But I am getting the error'3706 syntax error expected global temporary'
Please help on me on this....
Thanks in advance..
You need to add some spaces, currently you try to execute this
CREATE TABLEdb.tb_bkpASdb.tbWITH DATA and STATS
I am not able call this procedure with parameteres, "Failure 3706:syntax error expected GLOBAL TEMPORARY."
Just give me How call this procedure....?
you need to fix the source code before you can call this procedure :-)
As I already wrote: your SET statement results in an invalid CREATE TABLE statement in SqlTxt.
Could you please give me the correct statement with calling parameters values.
SET SqlTxt = (' CREATE TABLE' || DATABASENAME ||'.'|| TABLENAME1_bkp || 'AS' || DATABASENAME ||'.'||TABLENAME1|| ' WITH DATA and STATS' );