All Forums Tools
tonez01 6 posts Joined 08/10
25 Jun 2016
FastExport : SET SESSION SEARCHUIFDBPATH

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

Ivyuan 63 posts Joined 01/10
28 Jun 2016

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!

You must sign in to leave a comment.