Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 1.07 » View Incident Report |
Serious |
Reported By: Jochem Stemmermann Reported On: 11/21/2007 For: Version 1.06 Build 1 |
BEGIN use Sarakalib; execute immediate 'drop table debitor'; EXECUTE IMMEDIATE 'CREATE TABLE "Debitor" ( "Kundennr" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' '' NOT NULL, "Name1" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' '' NOT NULL, "Name2" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' '' NOT NULL, "Name3" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' '' NOT NULL, "Adresse1" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' '' NOT NULL, "Adresse2" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' '' NOT NULL, "Land" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' '' NOT NULL, "PLZ" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' '' NOT NULL, "Ort" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' '' NOT NULL, "Telefom" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' '' NOT NULL, "Fax" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' '' NOT NULL, "Code" VARCHAR(80) COLLATE "ANSI_CI" DEFAULT '' '' NOT NULL ) 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'; execute immediate 'IMPORT TABLE Debitor FROM ''c:\debitor.txt'' DELIMITER CHAR ''|'' USE HEADERS'; EXECUTE IMMEDIATE 'CREATE INDEX "ixKundenr" ON "Debitor" ("Kundennr" COLLATE "ANSI_CI")'; EXECUTE IMMEDIATE 'CREATE INDEX "ixName1" ON "Debitor" ("Name1" COLLATE "ANSI_CI")'; EXECUTE IMMEDIATE 'CREATE INDEX "ixName2" ON "Debitor" ("Name2" COLLATE "ANSI_CI")'; EXECUTE IMMEDIATE 'CREATE INDEX "ixName3" ON "Debitor" ("Name3" COLLATE "ANSI_CI")'; EXECUTE IMMEDIATE 'CREATE INDEX "ixOrt" ON "Debitor" ("Ort" COLLATE "ANSI_CI")'; EXECUTE IMMEDIATE 'CREATE INDEX "ixPlz" ON "Debitor" ("PLZ" COLLATE "ANSI_CI")'; EXECUTE IMMEDIATE 'CREATE INDEX "ixSuchen" ON "Debitor" ("Kundennr" COLLATE "ANSI_CI", "Name1" COLLATE "ANSI_CI", "Name2" COLLATE "ANSI_CI", "Name3" COLLATE "ANSI_CI", "Ort" COLLATE "ANSI_CI")'; END
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |