Keep these points in mind when working with Adaptive Server® Anywhere uniqueidentifiers.
CREATE TABLE dba.YorkTable ( UniqueColumn UNIQUEIDENTIFIER NOT NULL DEFAULT NEWID(), Characters VARCHAR(10) NOT NULL, ) IN SYSTEM ; ALTER TABLE dba.YorkTable ADD CONSTRAINT ASA126 PRIMARY KEY NONCLUSTERED (UniqueColumn) ;
"INSERT INTO sampledb.dba.YorkTable (UniqueColumn, Characters) VALUES (:UniqueColumn, :Characters)"
"INSERT INTO sampledb.dba.YorkTable (Characters) VALUES (:Characters)"