SPL and environment

I have a stored procedure that dumps a row of information to an interface file. This procedure runs on two different boxes, with a different output path for each box. Currently, I develop the SP and debug it, then, before placing it onto our production system, I manually alter the output path and create the SP. I know that SPL can use dbinfo('dbhostname'), but is there any way that I can determine the INFORMIXSERVER? (Of course, maybe dbinfo would be the way to go, anyway!!??) Thanks in advance John Carlson Informix DBA WHSmith USA

I'm not sure, but maybe you could do the following select: SELECT cf_effective INTO ...variable... FROM sysmaster:informix.sysconfig WHERE cf_name = "DBSERVERNAME" Hope this helps, Chris