Fast Load - Insert Select Statement

Database
Enthusiast

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

Tags (2)
4 REPLIES
Enthusiast

Re: Fast Load - Insert Select Statement

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

Enthusiast

Re: Fast Load - Insert Select Statement

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

Enthusiast

Re: Fast Load - Insert Select Statement

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

Enthusiast

Re: Fast Load - Insert Select Statement

Thank you Qaisar.