lennart@kommunicera.umea.se wrote:

> Knut Stolze wrote:
>> lennart@kommunicera.umea.se wrote:
>>
>> > If not mistaken, type is a reserved word in sql so you should concider
>> > changing it to car_type or whatever
>>
>> Changing the column name is not necessary as (DB2) SQL is a
>> context-sensitive language and you can use keywords as
>> schema/table/column/funcgtion/... names. For example, the following is
>> valid SQL:
>>
>> SELECT select select
>> FROM from.from from
>> WHERE where = where
>>
>> (assuming the proper table definition.)
>>
>
> IMHO type is to vauge in most cases.

You are right, but that is a completely different question.

> But more important, using reserved
> words makes porting to another dbms more difficult. But that is perhaps
> nothing to worry about ;-)

If those other systems also implement SQL, then it should not be a problem
at all. "Should"...

--
Knut Stolze
DB2 Information Integration Development
IBM Germany