EncodeFilename
Determines if the local file path in DownloadObjects Stored Procedure should be encoded.
データ型
bool
デフォルト値
true
解説
Determines if the local file path in DownloadObjects Stored Procedure should be encoded. Ex.
In the following query:
EXECUTE DownloadObjects
Object='SBatch100k_ORDERS_cdata_replicate_temporary_table/20201106023735184_0.csv',
Bucket='actiantest',
LocalFolderPath='C:\Users\User\Desktop\amazons3test'
The final destination of the file will be C:/Users/User/Desktop/amazons3test/SBatch100k_ORDERS_cdata_replicate_temporary_table%2F20201106023735184_0.csv if EncodeFilename=true
and C:/Users/User/Desktop/amazons3test/SBatch100k_ORDERS_cdata_replicate_temporary_table/20201106023735184_0.csv if EncodeFilename=false.
In addition you can use CreateFoldersOnDownload connection property if and only if EncodeFilename=false. If CreateFoldersOnDownload is set to true
it will automatically create the folder in which the file is going to be downloaded.