Bteq/Multiload to accept recent file

Tools
Enthusiast

Bteq/Multiload to accept recent file

Hi All,

 

Is there any way we can write Bteq/Multiload to accept most recent file from the folder? We do not have unix box in our machine. If yes what would be the command for BTEQ and for Multiload?

 

Thanks for taking your time.

 

Regards,

Hari k

2 REPLIES
Teradata Employee

Re: Bteq/Multiload to accept recent file

MultiLoad does not support this type of action. You must supply the exact file name.

I am sure BTEQ works the same way.

 

-- SteveF
Enthusiast

Re: Bteq/Multiload to accept recent file

Hi Feinholz,

 

Thanks for you reply. I coudn't do that way however I was able to write batch script to pull the latest file from the folder and also to dynamically apply the filename into bteq.