[rm-users] WHY THERE IS NO REPLY AT ALL....

[Steve Cavill]

Asha, try posting this at sqr-users (www.sqrug.org)   This message board is
for Brio.Portal - so maybe not so many SQR specialists on it.  sqr-ug ha a
lot more activity, you may have more luck there.
Steve.

-----Original Message-----
From: rm-users-admin@sqrug.org [mailto:rm-users-admin@sqrug.org]On
Behalf Of Asha Joseph
Sent: Friday, 7 November 2003 4:14 PM
To: rm-users@sqrug.org
Subject: [rm-users] WHY THERE IS NO REPLY AT ALL....


                I have already asked this ,...;....But  I didnt get any
reply till now.......Just give me a suggestion..Its urgent....

Actually I hav 2 change the database also..Connect method will only logs
off the current db and it will make another connection for the same
database.
I wanted to disconnect the database and it should connect with another
database..

The CONNECT method is also not working...It is giving the error
"CONNECT failed.Perhaps username/password incorrect"

Plz suggest a good method to overcome this method...
Plz suggest immediately...
Thank you very much for ur reply..
Expecting more valuable information from you.



The connect command is described as follows in the reference guide:
You would typically use it in the program or procedure section, i guess it
would work in the setup section also.

declare-connection is for DDO which is used for JDBC and non-relational
data
access.

Cheers, Steve.

Function

Logs off the database and logs on under a new username and password.

Syntax

CONNECT {txt_lit|_var|_col}[ON-ERROR=procedure
[(arg1[,argi]...)]]

Arguments

txt_lit|_var|_col

Specifies a username and password for the logon.

ON-ERROR

Specifies a procedure to be executed if the logon fails. If no ON-ERROR
procedure is specified and the logon fails, SQR halts with an error
message.
You can optionally specify arguments to be passed to the ON-ERROR
procedure.
Arguments can be any variable, column, or literal.

Description

The new username and password can be stored in a string variable, column,
or
literal.
After each CONNECT, the reserved variable $username is set to the new
username.
All database cursors or logons are closed before the CONNECT occurs. You
should not issue a CONNECT within a SELECT or an SQL paragraph while a
query
is actively fetching or manipulating data from the database.

Examples

connect  $new-user  on-error=bad-logon($new_user)

connect  'sqr/test'

Note:            The username/password is not encrypted, so beware of
security issues.

-----Original Message-----
From: rm-users-admin@sqrug.org [mailto:rm-users-admin@sqrug.org]On
Behalf Of Asha Joseph
Sent: Thursday, 6 November 2003 7:55 PM
To: rm-users@sqrug.org
Subject: RE: [rm-users] Sqr-Doubt,please reply


Hello Steve
Actually I am using Oracle database...While running the sqr v r giving the
connection string(username/pwd@db) to access the table in that db..
Instead of that,I wanted to give the connection inside the sqr
script....And while running the sqr ,i wanted to use some other database..
That means,my connection for the database should come inside the sqr
script..Hope u r clear now..
Please help me /...
I have used Declare -Connection inside Begin-Setup,but it is giving error
'command invalid';
I think it can be used only for SQR/DDO ports only..But I dono what is
SQR/DDO..

Also please tell ,where I have to use sqr CONNECT method..
Whether it should be inside Setup...
I am expecting a reply as early as possible...
Plz suggest immediately
Ur help will be appreciated..






Steve Cavill <steve.cavill@infoclarity.com.au>
Sent by: rm-users-admin@sqrug.org
06/11/2003 02:05 PM
Please respond to rm-users


        To:     rm-users@sqrug.org
        cc:
        Subject:        RE: [rm-users] Sqr-Doubt


Hi Asha,
I'm not sure exactly what you mean, but check the sqr CONNECT command.
That
allows you to change  your db connection while sqr is running.
Steve.

-----Original Message-----
From: rm-users-admin@sqrug.org [mailto:rm-users-admin@sqrug.org]On
Behalf Of Asha Joseph
Sent: Thursday, 6 November 2003 4:34 PM
To: rm-users@sqrug.org
Subject: [rm-users] Sqr-Doubt


Hi all

I want to access my table by giving the connection in the sqr script and i
would like to give another connection string in the command prompt while
running..
Plz suggest 4 this immediately.
Whether there is any way to access without giving connection string as
parameter while running the sqr..
Your valuable suggestions will be appreciated

_______________________________________________
rm-users maillist  -  rm-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/rm-users


_______________________________________________
rm-users maillist  -  rm-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/rm-users


_______________________________________________
rm-users maillist  -  rm-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/rm-users


_______________________________________________
rm-users maillist  -  rm-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/rm-users



_______________________________________________
rm-users maillist  -  rm-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/rm-users