>>Remote view using odbc to an AS400.
>>
>>Select * from myfile where keyfield = 'Somevalue'
>>runs sub second
>>
>>gn = sqlconnect("sameDSNin remote view connection","sameid","samepass")
>>sqlexec(gn,"Select * from myfile where ketfield ='Somevalue'","test")
>>runs in 30 to 40 seconds.
>>
>>both return less than 30 records.
>
>You don't specify how the remote view is getting connected. If it is using a DBC connection what are the settings? Perhaps one is doing a progressive fecth and the other isn't...
>
>Use SQLGetProp() on the views connection and check all the properties and compare them to the same properties on the SPT connection. I would bet that you find some different settings.
>
>BOb

Thanks, but our As400 people had made a change on their end and the problem went away. Don't you jest lov it!

Jeff