FastExport : SET SESSION SEARCHUIFDBPATH

Tools
Enthusiast

FastExport : SET SESSION SEARCHUIFDBPATH

Hi,

How do I go about issuing a SET SESSION SEARCHUIFDBPATH for a UIF in a fastexport? 

thanks

1 REPLY
Teradata Employee

Re: FastExport : SET SESSION SEARCHUIFDBPATH

Hi,

You can send the SQL after the LOGON statement and before .BEGIN EXPORT statement. Here is an example:

.LOGTABLE fexplog;

.LOGON <the tdpid>/<the user id>, <the user password>;

The SQL statement(s); /*<==Here it is!*/

.BEGIN EXPORT  SESSIONS 2;

.EXPORT OUTFILE 'unload.txt';

SELECT * FROM TARGET_EMP_TABLE;

.END EXPORT;

.LOGOFF;

.QUIT;

Thanks!