Archives of the TeradataForum

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

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

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>>