Note that the begin end code block should be added--/after Dbvisualizer execution
Note that the begin end code block should be added--/after Dbvisualizer execution
Note that the begin end code block should be added--/after Dbvisualizer execution
--the important thing to say three times (many code friends can not be executed because of no add)
1 --/Note that the begin end code block should be added--/after Dbvisualizer execution2 BEGIN 3 DeclareV_useridvaluedecimal( -); 4 SetV_useridvalue= 3477;5 forV asMyCursorCURSOR for SELECT * fromBa_employeelinfotemp_20180503bak6 Do7 BEGIN 8 SetV_useridvalue=V_useridvalue+1;9 INSERTTen into One Sys_user_20180502bak A ( - USERID, - EPID, the Usercode, - USERNAME, - PASSWORD, - Logincode, + Loginfunction, - Loginfunctionname, + loginerrcnt, A Exectaskid, at Sortno, - ISVALID, - MEMO, - Isonduty, - PHONE, - EMAIL, in Btpassword, - Reaccount to ) + VALUES - ( the V_useridvalue, * V.epid, $ V.epcode,Panax Notoginseng V.epname, - 'b1:40:2f:cf:bd:1d:92:05', the V.login_name, + "', A "', the 0, + NULL, - NULL, $ 1, $ "', - NULL, - NULL, the NULL, - NULL,Wuyi NULL the ); - END; Wu END for; - END About /Note that the begin end code block should be added--/after Dbvisualizer execution
DB2 executing begi/end statement block on Dbvisualizer client