issue for label on table

[sai2223]

I am using IBM DB2 9.5 version of windows

I am getting some issues while creating a table as well as Label on Table

Issues are :

1. LABEL ON TABLE WEBDEV.ADLLGIN 'ADL Login' It’s giving a below error



[IBM][CLI Driver][DB2/NT] SQL0104N An unexpected token "TABLE" was found following "NAPSHOT FOR LABEL ON". Expected tokens may include: "JOIN". SQLSTATE=42601


2. when creating table with following format


CREATE TABLE WEBDEV.ADLLGIN (

-- SQL150B 10 REUSEDLT(*NO) in table ADLLGIN in WEBDEV ignored.

-- SQL1506 30 Key or attribute for ADLLGIN in WEBDEV ignored.

USRLG CHAR(25) CCSID 37 NOT NULL DEFAULT '' )



It’s giving error at CCSID 37 .

If we remove the CCSID 37 this key word it’s working fine. Please help me solving this problem

[ganeshmn25]

Hi dude ,

I think creating Label for the Tabel is not possible in Windows but it is possible in z/os , anyway I am no sure about it !!!!!


Regards

Padmanaban.N
DB2 Associate
Vision Tech Solution
Trichy, India