We are using SQL Global variables regularly in views from RPG. We need to add them to some PHP scripts. However we are experiencing problems.
It looks like the statement to set the global variable executes correctly. However when the select against the view happens we get an SQL error that the global variable was not found.
I'm at a loss as to what needs to happen differently.