CREATE TABLE "OdsTab" (
"BizonCreator" VARCHAR(30) COLLATE "ANSI_CI" DEFAULT CURRENT_USER DESCRIPTION 'Twórca',
"BizonCreated" TIMESTAMP DEFAULT CURRENT_TIMESTAMP DESCRIPTION 'Utworzono',
"BizonModifier" VARCHAR(30) COLLATE "ANSI_CI" DESCRIPTION 'Ostatnio modyfikowal',
"BizonModified" TIMESTAMP DESCRIPTION 'Ostatnia modyfikacja',
"BizonSearch" CLOB COLLATE "PLK_CI" DESCRIPTION 'Indeks slów',
"Id" VARCHAR(10) COLLATE "PLK_CI" DESCRIPTION 'Symbol tabeli',
"Nazwa" VARCHAR(30) COLLATE "PLK_CI" DESCRIPTION 'Nazwa tabeli',
"Skala" SMALLINT DEFAULT 0 DESCRIPTION 'Skala',
CONSTRAINT "PK_ODSTAB" PRIMARY KEY ("Id"),
CONSTRAINT "UC_ODSTAB_NAZWA" UNIQUE ("Nazwa"),
CONSTRAINT "CK_ODSTAB_ID" CHECK (CHARACTER_LENGTH(Id) > 0),
CONSTRAINT "CK_ODSTAB_NAZWA" CHECK (CHARACTER_LENGTH(Nazwa) > 0),
CONSTRAINT "CK_ODSTAB_SKALA" CHECK (Skala IS NOT NULL))
DESCRIPTION 'Tabele odsetkowe' 
VERSION 1 
UNENCRYPTED 
INDEX PAGE SIZE 4096
BLOB BLOCK SIZE 512
MAX ROW BUFFER SIZE 32768
MAX INDEX BUFFER SIZE 65536
MAX BLOB BUFFER SIZE 32768

CREATE TEXT INDEX "BizonSearch" ON "OdsTab" (BizonSearch)

SELECT * FROM ODSTAB WHERE BizonSearch CONTAINS 'p*'