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

NICKNAME

NICKNAME

Synonym is referred as Nickname in DB2.

DB2 Syntax

Syntac After Migration

 
CREATE NICKNAME  sc2.emp FOR sc.emp;
 
CREATE SYNONYM sc2.emp FOR sc.emp;
Parent topic: DB2 Syntax Migration