It almost sounds like the variable is only being initialized when youThat was good advice. It didn't seem to make a difference in this case,
first call the function. Could this be that the function is SQL and
therefore runs in the DFTACTGRP? And in my understanding the static
variable would retain it's value until the end of the activation group.
And the DFTACTGRP woldn't end until you signoff...
but I've found an article on DeveloperWorks by Birgita H., including some
example code for coding an API list read in a UDTF, so I'll reform my
program around that example and see how it goes.