All Forums Database
sunni1221 7 posts Joined 11/07
24 Dec 2012
Fast Load - Insert Select Statement

 

Hi All,

 

Is is possible to have 'Insert/Select' statement in fast load utility.

 

Example:

fastload << !

<load empty TableB through file>

Insert into TableA

select * 

TableB;

!

 

Thanks for your hlep.

 

Thanks,

Sunil

Qaisar Kiani 337 posts Joined 11/05
03 Jan 2013

You can use fastload to insert the values that are already defined via DEFINE in the script.

sunni1221 7 posts Joined 11/07
03 Jan 2013

Thank you for the input.
Trying to load the target table through stage table within the fastload. This might not be possible so using the bteq to do that.
 
Regards,
Suneel

Qaisar Kiani 337 posts Joined 11/05
04 Jan 2013

Normally in this case fastexport/multiload scripts are used, but if you just have an adhoc request then bteq scripts should servce the purpose.

sunni1221 7 posts Joined 11/07
08 Jan 2013

Thank you Qaisar.

You must sign in to leave a comment.