> Any idea what I have forgotten in my script?
>

well PASSWD definitely needs to be OCTETS
Alan

> (By the way, I know that it is possible to declare the view without
> using a procedure, but this here is just an example and the final result
> will be a bit more complicated)
>
> /******* START SCRIPT *********/
>
> CREATE TABLE USERS2 (
> USER_NAME USER_NAME NOT NULL,
> SYS_USER_NAME USER_NAME,
> GROUP_NAME USER_NAME,
> UID UID,
> GID GID,
> PASSWD PASSWD,
> PRIVILEGE PRIVILEGE,
> COMMENT COMMENT,
> FIRST_NAME NAME_PART,
> MIDDLE_NAME NAME_PART,
> LAST_NAME NAME_PART,
> FULL_NAME COMPUTED BY (first_name || _UNICODE_FSS ' ' ||
> middle_name || _UNICODE_FSS ' ' || last_name )
> );