Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: BTEQ Problems
 
From:   Tressler, Dara C.

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016