Question Re: wait function in Technology Q&A

wait function

Former Member — Thu, 25 Jun 2015 21:33:19 GMT

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.

Re: wait function

former_member106536 — Fri, 26 Jun 2015 13:50:32 GMT

Heres a custom function to do it. (I use the word count function all over the place)

custom function:

$ret_fn = word_ext($InputFilePath,JB_WordCount($InputFilePath,'/'),'/');

Return($ret_fn);

word count function:

$SubstrIdx = 0;

begin

while(word_ext($StringInput,$SubstrIdx + 1,$Delimiter) <> '')

begin

$SubstrIdx = $SubstrIdx + 1;

end

return($SubstrIdx);

Re: wait function

Former Member — Mon, 27 Jul 2015 13:53:26 GMT

Can you explain with an example ??

I didn't understand in this area $ret_fn = word_ext($InputFilePath,JB_WordCount($InputFilePath,'/'),'/');

Re: wait function

former_member187605 — Mon, 27 Jul 2015 14:49:41 GMT

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

Re: wait function

former_member106536 — Mon, 27 Jul 2015 15:43:58 GMT

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.

Re: wait function

former_member187605 — Mon, 27 Jul 2015 19:38:09 GMT

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 .