This topic provides information about datatype default values that can be set for mobile business object (MBO) attributes and parameters.
select ... from my_table t where t.last_modified >= ... and t.x >= :XIf X is NULL, no rows are returned, since (t.x >= :X) is false in the database if X is NULL.
The default value is set according to the nullability and datatype of the argument, synchronization parameter, or personalization key. For nullable types, the initial default value is set to NULL, for non-nullable types, a valid value is set according to the datatype (for example, string "", boolean "false", decimal "0", integer "0", float "0", and so on).
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)"