Re: SQRW from command line

[Kathy Anderson <AndersoK@ROTARYINTL.ORG>]

Just one other bit of info regarding James response.

As he mentioned the syntax for the command line is
{SQR Executable Path and name} {Report Path and name}
{userid/password@database} {SQR Parameters}

The third piece of the command line is the connect string
(userid/password@database) and this is what you were missing.  The syntax
above works for Oracle (as James mentioned) so if you're on another platform
the connect string might vary slightly.  I know for MS SQL Server the syntax
is:
database/userid/password.  I'm not sure what it is for DB2 or Informix.

{SQR Executable Path and name} {Report Path and name}
{database/userid/password} {SQR Parameters}




> -----Original Message-----
> From: Smith, James O [SMTP:james.o.smith@USAGO.KSC.NASA.GOV]
> Sent: 25 July 2000 12:28 PM
> To:   SQR-USERS@list.iex.net
> Subject:      Re: SQRW from command line
>
> I use the following syntax to run sqr against an oracle database from the
> command line:
>
> {SQR Executable Path and name} {Report Path and name}
> {userid/password@database} {SQR Parameters}
>
> Note: There is a space between the each of the four bracketed sections
> shown
> above and do not include the brackets at the command line.
>
>
> James
>
> > ----------
> > From:         Nadav Karpenkop[SMTP:nadavk@BUSINESSLAYERS.COM]
> > Sent:         Tuesday, July 25, 2000 2:19 PM
> > To:   SQR-USERS@list.iex.net
> > Subject:      SQRW from command line
> >
> >
> > Hi
> > I'm trying to execute the sqrw.exe from the command line without getting
> > the SQR V4.3.4 screen so I need to pass the username , password ,
> database
> > and another
> >
> > parameter  but without success.
> > This is my command line : sqrw c:\temp\test.sqr -id:\psoft\hr75\sqr\
> > -fc:\temp\ -ZIFd:\psoft\hr75\sqr\pssqr.ini
> > I tried the -U parameter for the username the -DB or -N parameter for
> the
> > database parameter and again without any success.
> >
> > The other parameter is an integer parameter that I'm using with the ASK
> > function inside the SQR.
> >
> > Is it possible to execute sqrw in the command line without getting the
> SQR
> > dialog?
> >
> > Thanks
> >         Nadav
> >
> >
> >
> >