Archives of the TeradataForum

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

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

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