IIAS version: 22.214.171.124
Customer: Summit, Kadokawa, Sompo Japan, Coop Deli
Title: dbsql should support "BEGIN END" statement like as Netezza
Netezza customers use "BEGIN END" statement for their batch jobs.
Db2 has similar function but not the same function.
Here is the differences:
Netezza transactions ( https://www.ibm.com/support/knowledgecenter/SSULQD_7.2.1/com.ibm.nz.dbu.doc/r_dbuser_commit.html ) :
begin; <---- please notice a semicolon ";" after the keyword "begin" insert into cities values ('Boston', 'Massachusetts'); <--- SQL statements only insert into cities values ('Houston', 'Texas'); commit;
db2 anonymous block statements ( https://www.ibm.com/support/knowledgecenter/no/SSEPGG_11.1.0/com.ibm.db2.luw.apdv.plsql.doc/doc/c0053848.html ):
BEGIN <--- please notice there is NO semicolon ";" after "BEGIN" keyword dbms_output.put_line( 'Hello' ); <--- SQL or PL/SQL statements (body of procedures) END;
Netezza BEGIN statement for transactions are NOT the same as db2 BEGIN statement for anonymous block statement. db2 does NOT support BEGIN transaction blocks from Netezza. Please check the explanation for "BEGIN" in db2 compatibility documentation: https://www.ibm.com/support/knowledgecenter/en/SS6NHC/com.ibm.swg.im.dashdb.apdv.porting.doc/doc/compat_SQL.html
Why is it useful?
|Who would benefit from this IDEA?|
How should it work?
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "firstname.lastname@example.org" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions