Create table question: i do have to put " " ???

[myroot]

Hi folks:

I am using the 'getting started manual sql Version 7' from IBM. Starting with the first easy statement create table.
But, i typed corrrectly the info in the create table statement table : create table pers (id smallint not null,
name varchar, etc ) i get an error message. But when i use the create table wizard, and afterwards, saving the results as sql script, db2 saves it but using "" to define column
name, Why ??

create table pers ("id" smallint not null, "name".... )

Why does db2 use the " " to define column name(how do u call these.. in english.. semicollons ??)

is this the default or can i change it ?? I would like to do it manually and i do not want to use " ", if possible

please help

 

[sathyarams]

The column names and table names have to be enclosed within double-quotes (&quot if you wish to have a space in the tablename/column name ...

When DB2 'generates' SQL Statements, the col and tab names are enclosed within the quotes as a standard ...

You do not necessarily have to have "" for normal stuff ...

HTH

Sathyram
BTW, what is the error you get ?

More DB2 questions answered at

http://www.dbforums.com/f8