SQR to UNIX


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers SQR to UNIX
# 1  
Old 08-24-2005
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 SQR to UNIX ?

Thanks
 
Login or Register to Ask a Question

Previous Thread | Next Thread

9 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... (1 Reply)
Discussion started by: Aswathy88
1 Replies

2. Shell Programming and Scripting

File Transfer from Window server to UNIX and UNIX to UNIX

Dear All, Can someone help to command or program to transfer the file from windows to Unix server and from one unix server to another Unix server in secure way. I would request no samba client. (4 Replies)
Discussion started by: yadavricky
4 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. 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

6. 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... (1 Reply)
Discussion started by: autosys_nm
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. 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

9. 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
log(8)							      System Manager's Manual							    log(8)

NAME
log - Records input and output from a program SYNOPSIS
/usr/sbin/log <logfile> <command> OPERANDS
The file in which to record the interaction being logged. The command to execute. DESCRIPTION
The log program runs <command> and logs the input to and output from <command> to the <logfile> file. Input and output are logged until <command> exits, the log program exits, and the exit status of <command> is returned. The log program is used by the system installation procedure and the it(8) command to create the /var/adm/smlogs/install.log and /var/adm/smlogs/it.log installation log files. RESTRICTIONS
Because the log program is used in the installation standalone environment, program size was the greatest concern in its implementation. The log program does not search for the PATH variable to locate <command> and error messages are terse. The log program causes <command> to take standard input from and write standard output and standard error to UNIX pipes. Some commands will not be able to operate in this environment; therefore, it is suggested that you use the script(1) command instead. UNIX shells will not issue prompts when run from log unless the shell is started with an explicit interactive switch (-i for most shells). For example, log foo.tmp /sbin/sh -i In the previous example, foo.tmp is the name of <logfile>. The log program intercepts end-of-file (usually Ctrl/d). Therefore programs which normally receive end-of-file as an exit command must exit by some other means. ERRORS
Log open error Explanation: The log program was unable to open <logfile>. Verify that the directory exists and that ownerships and permissions are set correctly. Exec Error Explanation: The log program was unable to execute <command>. Verify that you specified a full pathname for <command> and that <command> is an exe- cutable file. Fork Error Explanation: The log program was unable to create one of the processes it requires to log data. SEE ALSO
Commands: it(8), script(1) log(8)