insert into security.sms_list (MOB_NO,
NAME, CATEGORY, MAIL_ID)
When I am trying with only one insert , it is working fine. But when I am trying to give two insert statements it is throwing the error in the second statement,I suppose the scope of the parameter is ending at the terminating semicolon.
S0022(-206)[IBM][CLI Driver][DB2/AIX64] SQL0206N "EMOBILE_NO" is not valid in the context where it is used. SQLSTATE=42703
The scope of the parameter is becoming local and gets terminated by semi colon.