SQL time field & CCSID?

[David Gibbs <david@xxxxxxxxxxxx>]

Folks:

Anyone know why, when I create a time field in a table using SQL, it is
assigned a CCSID (37 in my case).

Logically date, time, or timestamp fields are absolute values and not
subject to character set variations.

When I execute the following SQL statement ...

ALTER TABLE DEVDMGWRK/AUTLIST ALTER COLUMN FIELD1 SET DATA TYPE TIME NOT
NULL WITH DEFAULT ccsid 37

... I get the error 'FOR DATA or CCSID clause not valid for specified
type.'.

However, when I do a DSPFFD on the file and look at the fields...

FIELD1     TIME            8       8       129        Both     FIELD1
  Time Format . . . . . . . . . . . . . . . :  *ISO
  Coded Character Set Identifier  . . . . . :     37

... I see the time field as a CCSID associated with it.

Is this just a default value that really has no relevance?

Thanks!

david