Fastexport data Display

Tools

Fastexport data Display

Hi All,

Please can anyone advise how do i display the data that i read from an input file
in my job output log or say Console.

Either using BTEQ /Fastexport --> .import command.

We have the command called .display var_name to console/file.

But if i am reading from a file using .import command and the layout is specified , then
i can i display the Field names in the console.

My Script:-

.logtable fxp_rst_log_cust;
.dateform integerdate;

.run file 'C:\Program Files\NCR\Teradata Client\bin\logon\log_file.txt';

.begin export
sessions 2
Tenacity 5
Sleep 6 ;

.layout details;

.FIELD dbname * char(6);
.FIELD tbname * char(9);

.import infile 'C:\Program Files\NCR\Teradata Client\bin\testdata\customers\cust_imp1.txt'
layout details;

.display dbname to file console; /* gives an error */

.end export;

.logoff;

-------------
Errors :-

**** 12:16:47 UTY0005 Bad data in the DISPLAY command at position 9, the name be
ginning with
"dbname" is not a valid string.
----

2 REPLIES

Re: Fastexport data Display

Hi All,

Please can anyone advise how do i add a text like "START OF FILE"...at the begining and "END OF FILE" at the end..In FASTEXPORT...
N/A

Re: Fastexport data Display

Why do you need that?
Is it so hard to find out where's the start and the end of a file? ;-)

The only way i know is to add another select:
select top 1 'START OF FILE' from dbc.dbcinfoV;

your actual select;

select top 1 'END OF FILE' from dbc.dbcinfoV;

Dieter