Data Manipulation in FastLoad


Data Manipulation in FastLoad

I have a number of delimited files, each of the same format and each has a date as a part of the filename.

Is there a way, using FastLoad, that I can add a column to the data during the load that contains the date portion of the file name?

I tried simply adding a SUBSTR to the INSERT statement but received the error "Expression not allowed in FastLoad"

Thanks for your help


I am using TTU 13.10

Tags (1)