Archives of the TeradataForum

Message Posted: Fri, 11 Oct 2002 @ 15:02:37 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

BELOW IS THE FIRST LINES OF THE BTEQ (Ignore -------------)
--------------------------------------------------------------------

.RUN FILE ..\secure\loginssa.sql

.SET ERRORLEVEL 3807 SEVERITY 0

/******************************************************************
 * Volatile Temp Table for Transactions                           *
 * by Day, Store, Transaction, Inv_Type, Product, and Barcode     *
 ******************************************************************/

CREATE VOLATILE TABLE TranbodySummaryVTEMP,
    NO FALLBACK, NO BEFORE JOURNAL, NO AFTER JOURNAL

    (
    DayID DATE FORMAT 'YYYYMMDD' NOT NULL,
    TransactionID INTEGER NOT NULL,
    StoreNumber INTEGER NOT NULL,
    InventoryType CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
    ProductID VARCHAR(12) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
    Barcode VARCHAR(15) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
    RSUPackSize SMALLINT NOT NULL,
    DispenserNumber BYTEINT,
    Units DECIMAL(17,3),
    RSUUnits DECIMAL(14,3),
    RetailAmount DECIMAL(17,2),
    ExtendedRetailAmount DECIMAL(17,2),
    CostAmount DECIMAL(17,4))
UNIQUE PRIMARY INDEX ( DayID, StoreNumber, TransactionID, InventoryType, ProductID, Barcode, RSUPackSize )
ON COMMIT PRESERVE ROWS;
------------------------------------------------------------------------

below is the ..\secure\loginssa.sql file with the passwords blanked out
...note this is the EXACT same file I have been using for the last two
years

------------------------------------------------------------------------
.logon emcuds2/i06,********;

database ssa;
------------------------------------------------------------------------

This program is currently running in production WITHOUT problems.

Truly frustrating!

Thanks,

Dara

	<Prev	Next>		<<First	<Prev	Next>	Last>>