10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, I am new to shell scripting and Sybase database i need a help that i try to execute a SYBASE stored procedure from a Unix shell script and wanna write the output of the SP into a Text File.somehow i try to find a solution but whwn i try to run the script i am not getting the output file with... (1 Reply)
Discussion started by: Arun619
1 Replies
2. Post Here to Contact Site Administrators and Moderators
Hi, I am new to shell scripting and Sybase database i need a help that i try to execute a SYBASE stored procedure from a Unix shell script and wanna write the output of the SP into a Text File, somehow i tried to find a solution but when i try to run the script i am not getting the output file with... (1 Reply)
Discussion started by: Arun619
1 Replies
3. Shell Programming and Scripting
Greeting everyone. Ok, I have spent the past few days googling for this and I keep hitting a wall. Many results brought me here, but the solutions were not quite right for this.
Basically my script (ksh) is run with an arg for a csv. My script so far appears to be storing the values from my... (4 Replies)
Discussion started by: dezdiggler
4 Replies
4. Shell Programming and Scripting
below code is not executing the stored procedure,not sure what the issue.Even sqllog is blank.please help me its very urgent.
sqlplus -s $connect_str@$DB_ORACLE_SID >> ${SQL_LOG_FILE} << EOF
set serverout on
set feed off
set head off
set pages 0
set colsep ,
set tab off
set lin 150... (3 Replies)
Discussion started by: katakamvivek
3 Replies
5. UNIX and Linux Applications
I have a very simple set up
I am connecting to a MS SQL db using SQSH statement from a shell script
In this sqsh connection i am trying to execute a stored proc
However I want to capture the value returned by the stored proc.
I haven't really come across anything useful so far which would... (0 Replies)
Discussion started by: shishirkotkar
0 Replies
6. Shell Programming and Scripting
Hi,
I am writing a script that needs to call a stored proc which would update a column in a table based on a condition.
I need to also capture the number of rows updated.
However, When I execute the script I keep getting this error:
./test_isql.sh: syntax error at line 33: `end of file'... (3 Replies)
Discussion started by: karthikk
3 Replies
7. Shell Programming and Scripting
Greetings,
I need to make an open server call to a shell script from inside a Sybase Stored procedure.
Coul any one please provide a sample code?
TIA (0 Replies)
Discussion started by: rajpreetsidhu
0 Replies
8. UNIX for Dummies Questions & Answers
Hi All,
Want to know if is it possible to run / execute any stored procedures (sybase) from unix command prompt.?
Thanks for your help in Advance.
Regards,
Arvind S. (0 Replies)
Discussion started by: Arvind_temp
0 Replies
9. Solaris
All,
We are contemplating a port of an existing software product and would like to expend as little effort as possible. Our new database would be MS-SQL, and we would write stored procedures to perform common db operations. We'd like to call these stored procedures from C or C++ code running... (3 Replies)
Discussion started by: mparks
3 Replies
10. UNIX for Dummies Questions & Answers
Can someone tell me how to execute an Oracle Stored Procedure from a Korn Shell Script.
Previously, I'm able to execute standard sql using the following:-
The_Output=`sqlplus................. << EOF
select count(*) from abc
/
... (3 Replies)
Discussion started by: Vinny_Mitchell
3 Replies
Child::Link::Proc(3pm) User Contributed Perl Documentation Child::Link::Proc(3pm)
NAME
Child::Link::Proc - Proc object used by Child.
SEE ALSO
This class inherits from:
Child::Link
METHODS
$bool = $proc->is_complete()
Check if the child is finished (non-blocking)
$proc->wait()
Wait until child terminates, destroy remaining zombie process (blocking)
$proc->kill($SIG)
Send the $SIG signal to the child process.
NOTE: kill() is unpredictable on windows, strawberry perl sends the kill signal to the parent as well as the child.
$proc->pid()
Returns the process PID.
$proc->exit_status()
Will be undef unless the process has exited, otherwise it will have the exit status.
Note: When you call exit($N) the actual unix exit status will be bit shifed with extra information added. exit_status() will shift the
value back for you. That means exit_status() will return 2 whun your child calls exit(2) see unix_exit() if you want the actual value
wait() assigned to $?.
$proc->unix_exit()
When you call exit($N) the actual unix exit status will be bit shifed with extra information added. See exit_status() if you want the
actual value used in exit() in the child.
HISTORY
Most of this was part of Parrallel::Runner intended for use in the Fennec project. Fennec is being broken into multiple parts, this is one
such part.
FENNEC PROJECT
This module is part of the Fennec project. See Fennec for more details. Fennec is a project to develop an extendable and powerful testing
framework. Together the tools that make up the Fennec framework provide a potent testing environment.
The tools provided by Fennec are also useful on their own. Sometimes a tool created for Fennec is useful outside the greator framework.
Such tools are turned into their own projects. This is one such project.
Fennec - The core framework
The primary Fennec project that ties them all together.
AUTHORS
Chad Granum exodist7@gmail.com
COPYRIGHT
Copyright (C) 2010 Chad Granum
Child is free software; Standard perl licence.
Child is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or
FITNESS FOR A PARTICULAR PURPOSE. See the license for more details.
perl v5.10.1 2011-03-07 Child::Link::Proc(3pm)