Anyone knows has to pass passwords in QM procedure for SQL conn ect

["Corteville, Thierry" <Thierry.Corteville@xxxxxxxxx>]

I have to quary date, combining data from both a remote system and a local
system...
Therefore I've created a QM-procedure to automate this a much as possible

 

I thougt of first querying the remote system, and save the result of that
query in a temp-file 

on the local system (to be used on a second query with local data).

 

In short the procedure looks like this... 

'CONNECT TO Remote system USER="remote user" PASSWORD=remote password '


'RUN QUERY QTEMP/EENQM (DISPLAY=NO'                                      

'CONNECT RESET'                                                          

'SAVE DATA  AS QTEMP/Workfile  (CONFIRM=NO    ACTION= REPLACE'            

 

running this manually.. (entering line by line) works fine.... But when
running this through a STRQMPRC fails on the connect command..

 

I've tried all combinations for entering the password (with single quotes,
double qoutes....) 

I get error QWM2157 (parameter user should be entered wth extended
interface)

 

I do not know what is meant with this 'extended interface' does anyone know
how to solve this problem.... Or have other suggestions on querying data
from multiple systems in an automated way..

 

 

Thierry Corteville 
IT- Manager 
Quadrant CMS ERTA NV 
* +32 (0) 51 423 255 
* +32 (0) 41 423 470 
www.quadrantcms.com