Read field from Job Server file in Script and assign $GV

[Former Member]

Hi All,

I have a .txt file stored on the job server with appropriate permissions.

I want to read it in a script and assign the values in Field1 to a $GV.  Does anyone know how I can do that?

I also want to be able to update the values of the "Field1" via a script as well.

Your help will be appreciated!

[severin_thelen · Accepted solution]

Hey Ratu,

maybe you could use EXEC, to execute a batch script, which open the file and read its content.

In the past I use a CONFIG table in the database to do this. To access the database you could use the sql() function.

Regards

Severin

[Former Member · Accepted solution]

Thanks Severin.....

Actually i was able use the lookup_ext function to read the data off the .txt file and assign it to a $GV.  However, updating the text file from a script was challenging, so I just used a small dataflow to do that.

Thanks for you comment though!