Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 07 Nov 2000 @ 13:16:11 GMT


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


Subj:   VARTEXT Fastload and MVS
 
From:   Jeff Ohlman

Is there a secret to using the VARTEXT command in Teradata's FastLoad on MVS? I am able to use this command on UNIX with no problem. However, on MVS I get this message:

**** 08:34:02 FDL4800 Invalid FastLoad statement

FastLoad MVS version is same as UNIX FastLoad verison (7.02.00). I have heard that FASTLOAD VARTEXT is not available on channel attached (MVS) systems. Is that true?

Here is the pertinent portion of the FastLoad script:

      DEFINE
      SAAN                        (VARCHAR(12)),
      ACCT_SEQ                    (VARCHAR(1)),
      ACCT_NO                      (VARCHAR(13))
      DDNAME=INFILE;

      SET RECORD VARTEXT ',';

      INSERT INTO SPCL.JLO_TEST
      (
      SAAN
      ,ACCT_SEQ
      ,ACCT_NO
      )
      VALUES
      (
      :SAAN
      ,:ACCT_SEQ
      ,:ACCT_NO
      )
      ;

      END LOADING ;

      LOGOFF ;


     
  <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