Hi Mark,

Good question. I am still using the temp DBC. The temp DBC & DBF are created this way to avoid that 2nd instance problem. I don't think having the same connection name od different DBC's will make much difference. But I could use the same method to create a unique connection name.

tempdbf = SUBSTR( SYS(2015), 3, 7 ) + "A.dbc"

Haven't had the chance to change the code over to SPT yet. I'd prefer not to create connections on the host DBC. I could delete the connection at the end of the progam. But would rather work locally. I know that the connection & views are all in the temp DBC. I'll have to see if by using SPT if the data retrieved is still done through this same connection.
Thanks again.