Hi Mark,

Is this a long the lines of what you are saying?

* These 2 lines at the startup?
CREATE CONNECTION myconnect DATASOURCE "XXXX" USERID "YYYY" PASSWORD "ZZZZ"
nhandle = SQLCONNECT('myconnect')

* This when I need the info?
SQLEXEC(nhandle, SELECT invc_ln.invc_ln_no, invc_ln.invc_no FROM PROD.invc_ln invc_ln WHERE invc_ln.invc_no IN (&invc_nos), 'invc_ln_cursor')

I hope I got your meaning.
Thanks again