
264 DB2 II and WPS Synergy
Figure B-29 Table structured file - Create nickname - setting page
Ensure the Column Delimiter is checked and set to (, ) as shown in
Figure B-29. Click OK to finish modifying the nickname properties, click OK to
finish creating the nickname.
Example B-13 displays the command line version of the
COMPETITIVERATES nickname.
Example: B-13 Table-structured file - Create nickname statement
CONNECT TO FEDDB
CREATE NICKNAME ADMINISTRATOR.COMPETITIVERATES (
COMPANY VARCHAR (15) NOT NULL ,
DRIVERS VARCHAR (15) NOT NULL ,
AGE VARCHAR (15) NOT NULL ,
POLICY_LEN VARCHAR (15) NOT NULL ,
Attention: Once a nickname is created, its name and ...