548 Error: LS:DO- Field ID is out of range

This error is returned from an agent run on an AS400 R6 server which connects to an AS400 DB2 database via LSXODBC. If the server is restarted and no DECS activities are started, the code runs fine. Once a DECS activity is started… even if later stopped, LXSODBC access fails. The DECS and the scripted access co-existed and worked fine prior to upgrade from R5.0.11 to R6.01. The LSXODBC failure is for any database on the server… not just ones that have some sort of assiciated DECS activity.

Subject: 548 Error: LS:DO- Field ID is out of range.

I have a client that is having the same problem. Has anyone been able to come up with a resolution or explanation?

Subject: RE: 548 Error: LS:DO- Field ID is out of range.

I was able to solve my errors by referring to the the data in the result set by column number instead on name. Thus, used the result.getvalue(2)