Archives of the TeradataForum

Message Posted: Sat, 05 Jul 2003 @ 16:02:54 GMT

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

The following are examples that I've used on MVS but should work for network attached systems.

---------------------------------------------------
FASTEXPORT:
.LOGON ;
.LOGTABLE WORKDB.TABLELOG;
.BEGIN EXPORT;

  SELECT *
   FROM EDW.CURRENCY;

  .EXPORT OUTFILE EXPOUT MODE INDICATOR;
  .END EXPORT;
  .LOGOFF;

----------------------------------------------------
FASTLOAD:
.LOGON ;
ERRLIMIT 1;
BEGIN LOADING
    WORKDB.CURRENCY
    ERRORFILES
      WORKDB.CURRENCY_ERR1,
      WORKDB.CURRENCY_ERR2
      INDICATORS
      CHECKPOINT 100000;
DEFINE

     DDNAME = INFILE;
     HELP TABLE WORKDB.CURRENCY;
     SHOW;
INSERT INTO EDW.CURRENCY.*
;

END LOADING;
LOGOFF;
.QUIT;

----------------------------------------------------

The "HELP TABLE" will only work if the table to be loaded is EXACTLY the same as the one you extracted from. Otherwise you'll need to DEFINE the columns.

The other option is to do a FASTEXPORT with a MLSCRIPT option on the EXPORT command. This will generate a MultiLoad script which you can then use to load the data.

Robert Meunier

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