/opt/teradata/client/bin/fexp <<EOP

.LOGTABLE load_work.datastore_log1 ;
.LOGON BOX/userid,password;
.BEGIN EXPORT
SESSIONS 20;
.EXPORT OUTFILE $path MODE RECORD FORMAT TEXT;

select
trim(cast(PROC_YYMM_DT as char(5))) (title ''),
cast('~' as char(1)),
trim(cast(ACCNO as char(21))) (title ''),
cast('~' as char(1)),
(CASE
WHEN ACC_CO_NO IS NULL
THEN CAST('?' AS CHAR(1))
ELSE trim(CAST(ACC_CO_NO AS char(21)))
END) (title ''),
cast('~' as char(1)),
trim(cast(ACC_APPSYS_ID as char(3))) (title ''),
cast('~' as char(1)),
(CASE
WHEN ACC_CHFGL_MT_TR_AM IS NULL
THEN CAST('?' AS CHAR(1))
ELSE trim(CAST(ACC_CHFGL_MT_TR_AM as char(18)))
END) (title ''),
cast('~' as char(1)),
(CASE
WHEN ACC_CHFGL_LT_TR_AM IS NULL
THEN CAST('?' AS CHAR(1))
ELSE trim(CAST(ACC_CHFGL_LT_TR_AM as char(18)))
END) (title ''),
cast('~' as char(1)),
(CASE
WHEN ACC_RECGL_LT_TR_AM IS NULL
THEN CAST('?' AS CHAR(1))
ELSE trim(CAST(ACC_RECGL_LT_TR_AM as char(18)))
END) (title ''),
cast('~' as char(1)),
(CASE
WHEN BNKRPT_NOTIFTN_DT IS NULL
THEN CAST('?' AS CHAR(1))
ELSE CAST(CAST(BNKRPT_NOTIFTN_DT AS FORMAT 'YYYY-MM-DD')
AS CHAR(10))
END) (title '')
from vrtl.core_rcvry
where
proc_yymm_dt = 10811 and
acc_appsys_id in ('599');

.END EXPORT ;
.LOGOFF;
EOP

~ as delimiter

i am using the following query to fast export.. but i getting some junk characters prefixed to each column value ... what is the problem??.... it queries perfectly in teradata though..

To keep the forums high quality for all users, please take the time to format your posts correctly.

First of all, use Code Tags when you post any code or data samples so others can easily read your code. You can easily do this by highlighting your code and then clicking on the # in the editing menu. (You can also type code tags [code] and [/code] by hand.)

Second, select an appropriate forum for your post. A long script in a scripting language most people have never heard of does not belong in "dummies questions and answers".

Thank You.

The UNIX and Linux Forums