The Stambia User Community is moving to Semarchy! All the applicable resources have already been moved or are currently being moved to their new location. Read more…
Hello,
I have to send a message whenever I don’t find a specific file. So I tried to recuperate the name of each file in a variable and then test if exist or not, and here I got the error
OK, how does this variable get data from "ind_session_file_op_lst" ?
What is the variable's value when the file was not found ?
Sorry for all the questions, but we cannot guess all this, please provide as much information as possible about how the process works and what you need to do
At first, I used the FileWait to implement the table (ind_session_file_op_lst) so that I can know the files that I did get.
Then I cried variables in which I put the name of the file by using “ select file_name from ind_session_file_op_lst where file_name like 'name of the file' ”
When the file was not found I think that the variable will get “null” as value, in that case I have to send a msg in order to declare that there is a missing file which is for example “schenker air”