Skip to Content

can someone tell me the usage of get_file_attribute function?

I am trying to read the trace log file and pick the time-stamp in the logs using a BODI ETL job. So in my EYL script I am trying to use the get_file_attribute function around the trace log file path but I am not sure on which attribute to be called.

$FileAtt = get_file_attribute($TraceFile,'??');

- I want to know what to fill inside the question mark since the file does not have any columns defined.

Can someone point me towards a turoial or syntax for this function?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 08 at 06:07 AM

    Hello,

    get_file_attribute( ) returns the attributes of a file like size, date_created and date_modified of any file.

    I’ve a file with name “Rajan.txt” placed on some shared path. I want to know its date_created and size of it.

    Now I want to find the size, date_created and date_modified values of this file in trace log.

    To find size, use a variable with double datatype.

    Upon executing the job,

    Now if I want to find the date_created for this file, change the datatype of variable from double to datetime.

    Upon executing the job,

    Hope it helps! :)

    Add comment
    10|10000 characters needed characters exceeded