Re: Calling an SQR from an SQR

[Patricia Stanley <pjstanle@SYR.EDU>]

I finally got a successful call to an SQR from an SQR.  Here's my next dilemma. 
 Is there a way to pass the userid/password from the calling SQR to the SQR 
being called.

Thanks for the help in advance!
>>> andrew.rivers@CWCOM.NET 09/30/01 07:41AM >>>
Patricia

    call system '..\sqrwtPath\sqrwt.exe    ..\sqrProgramPath\yourSRQprogram.sqt 
 databaseConnectionString   parm1  param2'

Note: Only one string is passed to the system.

    databaseConnectString may be database dependant:
        databaseName  userName  password

    Oracle:
        databaseName/password@userName

If you do not need to pass any parameters then omit param1, param2, etc.

Andrew

----- Original Message ----- 
From: Patricia Stanley <pjstanle@SYR.EDU>
To: <SQR-USERS@list.iex.net>
Sent: Monday, September 24, 2001 4:31 PM
Subject: Calling an SQR from an SQR


I have written a homegrown SQR and would like it to call a Peoplesoft SQR that 
is delivered with their Mass Change capabilty.  How do I do this?

BEGIN:VCARD
VERSION:2.1
X-GWTYPE:USER
FN:Patricia Stanley
ORG:;Information Systems
TEL;PREF;FAX:315.443.2376
EMAIL;WORK;PREF;NGW:pjstanle@syr.edu
N:Stanley;Patricia
X-GWUSERID:pjstanle
END:VCARD