Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 05 Nov 2003 @ 15:43:07 GMT


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


Subj:   Re: FastExport with ACCEPT command
 
From:   Julie Flanagan

..BEGIN EXPORT SESSIONS 24;
..EXPORT OUTFILE XPOUT;

..ACCEPT SRCE_SYS, SRCE_INST FROM FILE EWSRCXX;

SELECT
  WH_ACC_NO                           (INTEGER)
 ,ACC_NO                              (CHAR(16))
 ,SRCE_SYS                            (SMALLINT)
 ,SRCE_INST                           (SMALLINT)
 ,GL_MAIN_ACC_NO                      (CHAR(6))
 ,GL_SUB_ACC_NO                       (CHAR(3))
 ,GL_CORPTN                           (CHAR(5))
FROM
  ACCOUNT_DETAIL_SUPER2
WHERE
  SRCE_SYS  = &SRCE_SYS
AND
  SRCE_INST = &SRCE_INST
;

..END EXPORT;

..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: 15 Jun 2023