Problem in fast export

UDA
Enthusiast

Problem in fast export

Hi all,
I was trying to fast export 2 columns of a table.The export file contained two dots in prefixed to the data value.
Ex: If the table consisted value say 125, i use to get ..125 or .125
Then i tried by changing the MODE=RECORD. But then also its not working.

One more question is, if the table consists of junk values or LOW-VALUES (those whose value is less than x'00'), then how can i export them?

Awaiting for your reply.
4 REPLIES
Enthusiast

Re: Problem in fast export

it might help solving ur problem if u post the fast export script.
Enthusiast

Re: Problem in fast export

I have seen this problem before when exporting and not specifying the record length. You could try to make sure you are casting all columns to a set format. Are you exporting to mainframe of another host? Like previously mentioned can you post the script?

Enthusiast

Re: Problem in fast export

Yes.I have casted and also gave proper record length. We use mainframes + teradata.
Enthusiast

Re: Problem in fast export

You could try this script....it uses BTEQ to export though.
You may have to change the job card / system variables...

//TERAEXPO JOB 'TERAEXPO',
// NOTIFY=&USERID,TIME=(0,30),
// MSGCLASS=X
//************************************************************
//EXPORTAB EXEC PGM=BTQMAIN,REGION=0M
//STEPLIB DD DSN=SYS3.DBC.&VDBC..APPLOAD,DISP=SHR
// DD DSN=SYS2.DBC.&VDBC..TRLOAD,DISP=SHR
//OUTFILE DD DSN=TERADATA.TERAEXPO,
// DISP=(NEW,CATLG,DELETE),UNIT=DISK,
// SPACE=(CYL,(1,2),RLSE),
// DCB=(LRECL=64,RECFM=FB)
//* DISP=SHR
//SYSPRINT DD SYSOUT=*
//SYSIN DD *

.LOGON ;

.EXPORT DATA DDNAME=OUTFILE;
.SET FORMAT ON
.SET RTITLE OFF
.SET HEADING OFF
SELECT DATABASENAME (CHAR (32))
,TABLENAME (CHAR (32))
FROM DBC.TABLES
SAMPLE 10
;

.QUIT;