Archives of the TeradataForum

Message Posted: Wed, 30 Oct 2002 @ 15:00:45 GMT

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

I am trying to write a named pipe which will automatically load a given table with the input contents of a pipe.

    .BEGIN IMPORT MLOAD
      TABLES Tranhead
          WORKTABLES  NP_WT_Tranhead
          ERRORTABLES NP_ET_Tranhead
                      NP_UV_Tranhead
          ERRLIMIT 50
          AMPCHECK ALL;

    .LAYOUT INPUTLAYOUT INDICATORS;

    .TABLE SSA.Tranhead;

    .DML LABEL NP_INSERTS;

    INSERT INTO SSA.Tranhead .*;

    .IMPORT INFILE \\.\pipe\Tranhead axsmod NP_AXSMOD = 'ff=fbTranhead.log cfd=n ll=6 b=65535'
          FORMAT FASTLOAD
          LAYOUT INPUTLAYOUT
          APPLY  NP_INSERTS;

    .END MLOAD;

I looked into the documentation for Multiload and it says that this is valid. I get the following error:

------------------------
    **** 09:53:12 UTY0817 Multiload submitting the following request:
         BT;
    **** 09:53:12 UTY0817 Multiload submitting the following request:
         USING TRANSACTION_DATE(DATE), TRANSACTION_ID(INTEGER), STORE_NUM(SMALLINT),
         TRANSACTION_TIME(CHAR(8)), CLERK(CHAR(9)), DISCOUNT_AMT(DECIMAL(10,2)),
         TAX_AMT(DECIMAL(9,2)), REFUND_AMT(DECIMAL(10,2)), MOP1(CHAR(3)),
         PAID1_AMT(DECIMAL(10,2)), MOP2(CHAR(3)), PAID2_AMT(DECIMAL(10,2)),
         CHANGE_AMT(DECIMAL(10,2)), DRAWER_NUM(BYTEINT), SHIFT_NUM(BYTEINT),
         REGISTER_NUM(BYTEINT), BILL_STATUS(CHAR(1)), VOID_CODE(CHAR(3)),
         ESTABLISHEDDATE(DATE) INSERT SSA.Tranhead .*;
    **** 09:53:12 UTY0805 RDBMS failure, 3706: Syntax error: expected something between the word
         'Tranhead' and '.'.

I do not understand why this is happening. Anyone know?

Thanks,

Dara Tressler
Speedway SuperAmerica LLC

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