Skip to Content
0

can someone tell me the usage of get_file_attribute function?

Mar 07 at 08:15 PM

29

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Rajan Burad Mar 08 at 06:07 AM
2

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! :)


1.png (1.3 kB)
2.png (6.6 kB)
4.png (10.9 kB)
5.png (7.1 kB)
6.png (10.8 kB)
6.png (10.8 kB)
Share
10 |10000 characters needed characters left characters exceeded