8 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
2. UNIX for Dummies Questions & Answers
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
3. Shell Programming and Scripting
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
4. Shell Programming and Scripting
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
5. Shell Programming and Scripting
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... (1 Reply)
Discussion started by: autosys_nm
1 Replies
6. UNIX for Advanced & Expert Users
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
7. UNIX for Dummies Questions & Answers
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
8. UNIX for Dummies Questions & Answers
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