Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Help for generic named pipe
 
From:   Tressler, Dara C.

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