SQR error 5528


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting SQR error 5528
# 1  
Old 09-04-2008
SQR error 5528

Hi,

I'm trying to execute a script which calls a SQR.

The SQR is throwing an error
SQR 5528-sybase ct_connect error in cursor 0
Login falied
SQR 4701-Cannot connect to the database

I'm not sure where is the id/password specified as this is an existing script.

Any idea as where is the id/password specified in SQRs?

TIA
# 2  
Old 09-04-2008
As a guess - assume it is a positional parameter: scriptname user password Seeing the script would help a lot.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Print Error in Console and both Error & Output in Log file - UNIX

I am writing a shell script with 2 run time arguments. During the execution if i got any error, then it needs to redirected to a error file and in console. Also both error and output to be redirected to a log file. But i am facing the below error. #! /bin/sh errExit () { errMsg=`cat... (1 Reply)
Discussion started by: sarathy_a35
1 Replies

2. Shell Programming and Scripting

Running an SQR from shell script

Hi, I am trying to run an SQR from unix shell script. but the SQr errored out with the following message SQR (1201) Cannot open argument file (2) No such file. Can anybody help me ragrding this. I m using this to run the SQR. $2 is the sqr name and $3 is the parameter file name. sqrun... (1 Reply)
Discussion started by: Aswathy88
1 Replies

3. UNIX for Dummies Questions & Answers

Inserting subject for the mails sent through SQR

I am trying to insert subject for the mails sent through one of our sqr process using below code Let $Email_Command = 'uuencode ' || $filename || ' ' || $filename || ' | sendmail -F''' ||$subject || ''' ' ||$mailid1 || ''' ' ||$mailid2 CALL SYSTEM USING $Email_Command #return_code WAIT ... (5 Replies)
Discussion started by: thangaga
5 Replies

4. Shell Programming and Scripting

How to write a script in unix to get value from SQR?

hi this is naga, i had created one SQR , but i didnt include the code to get the notification(failure or success ) thats way every time its returning the status=0 SQR was went to success(if it failed also), without touching the code of the SQR can any one help to write script in unix to get... (4 Replies)
Discussion started by: nagavenkatesh
4 Replies

5. UNIX for Dummies Questions & Answers

> 5 ")syntax error: operand expected (error token is " error

im kinda new to shell scripting so i need some help i try to run this script and get the error code > 5 ")syntax error: operand expected (error token is " the code for the script is #!/bin/sh # # script to see if the given value is correct # # Define errors ER_AF=86 # Var is... (4 Replies)
Discussion started by: metal005
4 Replies

6. Shell Programming and Scripting

connecting to different database in sqr

Hi, My requirement is to generate a single text output which fetches data from two different databases. I have two different sqrs to generate text file1(data from db1) and file2(data from db2). can I execute both the sqrs from a single shell script? If yes, pls let me know how to connect to db2... (1 Reply)
Discussion started by: vimalr
1 Replies

7. UNIX for Advanced & Expert Users

Passing values from SQR to UNIX

UNIX script running a SQR program.... no problem passing values to SQR program... trying to pass values back to UNIX.... I'm currently creating a file from the SQR program and then using the Unix READ command to read the file and retrieve the value.... Is there an easier way to pass the... (2 Replies)
Discussion started by: seeuinoz
2 Replies

8. UNIX for Dummies Questions & Answers

SQR to UNIX

UNIX script running a SQR program.... passing values to SQR program... trying to pass values back to UNIX.... I'm currently creating a file from the SQR program and then using the Unix READ command to read the file and retrieve the value.... Is there an easier way to pass the values back from... (0 Replies)
Discussion started by: seeuinoz
0 Replies

9. Shell Programming and Scripting

What is sqr ?

Hi , I came along a command sqr in shellcscript. It was sqr process_name parameters. Could you please tell me what does it mean. Regards Ashish Malviya :) (1 Reply)
Discussion started by: Ashishm
1 Replies

10. UNIX for Dummies Questions & Answers

Changing persmissions for output file in UNIX box with SQR.

I am trying to change permissions on an output file from an sqr. The file is pushed out into a directory on the unix box. I am using the following code in the sqr to accomplish this. if $OUTPUT <> '' let $unix_call = 'chmod 664 '||$OUTPUT show $unix_call CALL SYSTEM Using... (1 Reply)
Discussion started by: evengetsteven
1 Replies
Login or Register to Ask a Question