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