SCRIPT
BEGIN
   DECLARE TableCheckCursor CURSOR for TableCheck;
 
-- Create the work table after first checking for and dropping it if it exists
  PREPARE TableCheck FROM '
     Select * From information.TemporaryTables Where Name = ?
  ';
 
  BEGIN
    OPEN TableCheckCursor using 'UTBidImport';
    IF RowCount(TableCheckCursor) > 0 then
      EXECUTE IMMEDIATE 'Drop Table UTBidImport';
    END IF;
    CLOSE TableCheckCursor;
   EXCEPTION
  END;
 
  EXECUTE IMMEDIATE '
      Create Temporary Table "UTBidImport" (
      "BidGUID" VARCHAR(38) COLLATE "UNI" DEFAULT ''{8470740F-5D17-41EF-8709-ABC583D597C7}'',
      "StockCode" VARCHAR(20) COLLATE "UNI",
      "Amount" INTEGER DEFAULT 0
      )
  ';
 
-- Load the work table from the text    file
  EXECUTE IMMEDIATE '
      Import Table UTBidImport from "UTBidPrice.txt" In Store "Temp" (StockCode, Amount) Delimiter Char #9
  ';
 
END