Single Nickname Reference

Description

Each nickname specified as a table-reference must identify an existing nickname at the application server. The intermediate result table is the result of the nickname.

Click here to navigate to the IBM DB2 docs page for this syntax.

NickName References are not supported in Snowflake

Grammar Syntax

Sample Source Patterns

First, let's see an example of a CREATE NICKNAME

IBM

CREATE TABLE TestTable ( ID INT, NAME VARCHAR(20) );

CREATE NICKNAME NickNameForTestTable FOR TestTable;

As you can see, the CREATE NICKNAME is using the TestTable as a reference. Now, the name given to the NICKNAME can be used in a Select, like in the following example.

IBM

Select * from NickNameForTestTable;

Known Issues

Currently, SnowConvert does not support the CREATE NICKNAME command and, is, therefore, unable to identify the name NickNameForTestTable as a nickname. The current translation for the above example might have functional differences if the NickNameForTestTable represents a nickname.