What is sqr ?

8 More Discussions You Might Find Interesting

1. 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...

2. 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 ...

3. 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. 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...

5. Shell Programming and Scripting

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...

6. 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...

7. 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...

8. 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...

Shell Programming and Scripting