I have been developing in MS SQL Server for 15 years and I am new to DB2 LUW. Does anybody have a good resource on the Syntax differences between say SQL server 2008 R2 and DB2 LUW 9.7? I have been trying to create a simple statement and I get Syntax errors on every line.
DECLARE v_product CHAR(3);
SET v_product = 'ANN';
EXEC SQL 'values next value for CTRCTNUM.CTRCT_SER_NUM_' ||v_product'';