wait function

[Former Member]

Hi All,

Please provide me inputs, Here is my scenario.

I came up with  wait_for_file( $GV_FILE_PATH || '/' || $GV_FILE_TYPE || '*' || '.TXT',0,0,1,$GV_FILE_NAME);  to check the path and find the file to process. Finally assign it to $GV_FILE_NAME in one of the pre-processing script.

But the $GV_FILE_NAME is capturing the complete path where I don't it because I am assigning this value to source Flat file's file name(s).

Note : $GV_FILE_PATH  is defined as global variable with path as value.

If run the job ,it will throw error because path is already defined and wait_for_file function is pulling the complete path.

Cannot open file </test/Ecommerce/IBMMainFrame/Acknowledge_Files/test/Ecommerce/IBMMainFrame/Acknowledge_Files/POV_Confirm_1.TXT>.

All I need is pull just the file name from the wait_for_file.

Please advice.

[former_member187605 · Accepted solution]

$GV_FILE_NAME_ONLY = word_ext($GV_FILE_NAME,-1,'/');

[former_member106536 · Accepted solution]

Luckily most the places I use this are for index counts not for the specific word, but I know I have a bunch of compression code that's going to get looked at now. 

Thanks for that Dirk!!

Looks like this was an addition? as the reference manual describes the index as being non-negative, yet provides examples of negative usage.  

[former_member187605 · Accepted solution]

You're right. Negative numbers are explicitly excluded in the word_ext definition, but one of the examples states "A negative word number means count from right to left."

I knew I had seen it somewhere before, couldn't remember where though .