Re: Calling an SQR from an SQR

[Andrew Rivers <andrew.rivers@CWCOM.NET>]

Patricia
Yes.
See the statement in my first email below:
        call system '...       databaseConnectionString  ... '
 
Assume:
    database name:         yourDB
    user name:                yourUN
    your password:        yourPW

Using these values, the databaseConnectionString within the string that is 
passed to the system call will be, for Oracle:
                        yourDB/yourPW@yourUN
or
                        yourDB   yourUN    yourPW
or something similar...
    I think that the database connection string is database dependent.

You can also pass other parameter, e.g. parm1 param2 etc.- see below:

You could hard code the database string in the first instance.
Alternatively, you could hold the database connection string in a field in the 
database, or make a user/database selection (and concatenate the various 
strings returned ) to get the required database connection string in the 
calling sqt routine .

Andrew

----- Original Message ----- 
From: Patricia Stanley <pjstanle@SYR.EDU>
To: <SQR-USERS@list.iex.net>
Sent: Monday, October 01, 2001 2:55 PM
Subject: Re: Calling an SQR from an SQR



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?