Hi,

where is the problem with this on SAPDB 7.3.0.29:

CREATE TABLE salutation
(
    id serial,
    name varchar (50) NOT NULL,
    text varchar NOT NULL,
    comment varchar (80),
    valid_id smallint NOT NULL,
    create_time timestamp NOT NULL,
    create_by integer NOT NULL,
    change_time timestamp NOT NULL,
    change_by integer NOT NULL,
    PRIMARY KEY(id),
    UNIQUE (name)
)

INSERT INTO salutation
   (name, text, comment, valid_id, create_by, create_time, change_by, change_time)
   VALUES
   ('system standard salutation', 'Dear CUSTOMER_REALNAME Thank
you for your request', 'std salutation', 1, 1, timestamp, 1, timestamp)

Syntax error or access violation;-3005 POS(1) Invalid SQL statement.

it seems to be correct for me :-(


CU,

   Wolfgang


_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to