Help Center> Data Warehouse Service> Tool Guide> DSC - SQL Syntax Migration Tool> SQL Syntax Migration Reference> DB2 Syntax Migration> Statement
View PDF

Statement

CURRENT SCHEMA

SET CURRENT SCHEMA

DB2 Syntax

Syntac After Migration

 
CREATE NICKNAME  sc2.emp FOR sc.emp;
 
CREATE SYNONYM sc2.emp FOR sc.emp;

GET DIAGNOSTICS with ROW_COUNT

DB2 Syntax

Syntac After Migration

 
CC_ORDER_HY_CUSTORCOUNT SET '              
          ||STR_CUST_COUNT||'_COUNT='||char(CUST_COUNT)||' ,'                              
          ||'SELF_UPDATE_TIME ='||''''||STR_DATE||''''||' ,' 
          ||'SUB_UPDATE_TIME ='||''''||STR_DATE1||''''||',' 
          ||'REPORT_STATE ='||''''|| STR_CHAR ||'''' 
          ||' WHERE ORG_CODE ='||''''||TEMP_ORG_CODE||''''
         ||' AND Y='||char(TEMP_YEAR)||' AND HY='||char(TEMP_HY)
          ||' AND REGION_CODE='||''''||TEMP_SALE_REG_CODE||''''||' AND BRAND_CODE='||''''||TEMP_BRAND_CODE||''''
          ||' AND exists (select 1 from CC_ORDER_HY_CUSTORCOUNT'
          ||' where ORG_CODE ='||''''||TEMP_ORG_CODE||''''
         ||' AND Y='||char(TEMP_YEAR)||' AND HY='||char(TEMP_HY)
          ||' AND REGION_CODE='||''''||TEMP_SALE_REG_CODE||''''||' AND BRAND_CODE='||''''||TEMP_BRAND_CODE||''''||')';--
PREPARE S1 FROM STR_UPDATE1;
EXECUTE S1;  --
GET DIAGNOSTICS V_NUMRECORDS = ROW_COUNT;    
V_NUMRECORDS = SQL%ROWCOUNT;
Parent topic: DB2 Syntax Migration