Unix Stored Procdure Post: 302105756

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Where is my unix id stored in the system?

Hi, I logged in to a Sun unix box. I would like to know where my unix id is stored. So I did a "more /etc/passwd | grep <my unix id> but it did not show up. Where can I find my unix id and what is the command to see it? Thanks in advanced, XZOR

2. Solaris

Executing MS-SQL stored procedures from Unix/C Program?

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. UNIX for Advanced & Expert Users

Executing Stored Proc from unix prompt.

Hi All, I want to run/execute a stored procedure (sybase) from unix command prompt not by login in isql utility which is provided my Sybase guys. Is there way ..? Thanks in advance for your help !!! Regards, Arvind S.

4. Shell Programming and Scripting

Need to call stored procedure from unix script

Hi Guys, I have a stored procedure which has 5 out parameters. I need to call the stored procedure from the script. When i use the following in my script, db2 "CALL FCFM.PART_MASTER_TMP($Return_code,$Message,$Message1,$SQL,$Load_count)" >> $LOG_FILE I am getting an error.. Please...

5. Shell Programming and Scripting

Oracle Query results to be stored in variables using unix

I want to store the sql query output into a variable #!/bin/ksh ORACLE_SID=DB01; export ORACLE_SID; export FILE_PATH=/home/asg/Tmp # Order Checking echo " removing old files " rm $FILE_PATH/Malformed_Order.txt echo " Enter the Malformed Order ....!" read orders echo "Regrade...

6. UNIX for Dummies Questions & Answers

Calling stored procedure from unix

Hi, My stored procedure returns a value. How to retrieve the value and display in unix. Stored procedure CREATE OR REPLACE PROCEDURE gohan(num INT) IS BEGIN DBMS_OUTPUT.PUT_LINE('My lucky number is ' || num); END; Unix Scripting i used sqlplus -s...

7. Shell Programming and Scripting

Passing a value to stored procedure from unix shell script

Hi Dudes :) I want a unix shell script to pass value to SQL stored procedure. Below is the procedure declare res varchar2(10); begin odm_load_check('PRE_SANITY',res); dbms_output.put_line(res); end; select * from error_log; truncate table error_log; select * from test;

8. Shell Programming and Scripting

Unix path stored as a column in table

The db2 table stores the unix path as below PARM VALUE RootPath $SRootDir Target $SRootDir/target $SRootDir is set in the env variable as /home/test/root In the shell script i read the table value and store it in a variable pth=db2 -x "select VALUE from...

9. Shell Programming and Scripting

How to KIll a Stored procedure invoked by UNIX?

Hi, I am using sql server 2008 version and invoking the stored procedure using unix script. I want to know the procedure of killing the stored procedure in sql server. If I kill -9 the unix script will it also terminate the process at the SQL server. When I executed the kill -9 PID in unix...

10. Post Here to Contact Site Administrators and Moderators

Calling Sybase Stored proc from UNIX Shellscript.

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

LEARN ABOUT DEBIAN

pbuilder-dist-simple

PBUILDER-DIST-SIMPLE(1) 				      General Commands Manual					   PBUILDER-DIST-SIMPLE(1)

NAME

       pbuilder-dist-simple - simple multi-release pbuilder wrapper

SYNOPSIS

       pbuilder-<dist> operation [...]

DESCRIPTION

       pbuilder-dist-simple  is  a  wrapper  that makes it easy to use pbuilder with chroots for many different Ubuntu distributions.  If you need
       more features than pbuilder-dist-simple provides, have a look at pbuilder-dist(1).

USAGE

       Create one symlink to pbuilder-dist-simple for each distribution for which you want a build environment, naming them like "pbuilder-lucid",
       "pbuilder-natty", etc.

       Replace operation with the action you want pbuilder-dist-simple to do (create, update, build, clean, login or execute).

EXAMPLES

       pbuilder-natty create
	      Creates a pbuilder environment for Ubuntu Natty.

       pbuilder-lucid update
	      Updates an existing Ubuntu Lucid environment.

       pbuilder-lucid build ./sample_1.0-0ubuntu1.dsc
	      Builds the specified package on an already existing Ubuntu Lucid environment.

FILES

       By default, pbuilder-dist-simple will store all the files it generates in ~/pbuilder/.  This can be changed by modifying the BASE_DIR value
       on the top of the script to any other directory you want.  If the directory doesn't exit, it will be created at runtime.

SEE ALSO

       pbuilder(1), pbuilderrc(5), pbuilder-dist(1)

AUTHORS

       pbuilder-dist was originally written by Jamin W. Collins <jcollins@asgardsrealm.net> and Jordan Mantha <mantha@ubuntu.com>, and	this  man-
       page by Siegfried-A. Gevatter <rainct@ubuntu.com>.

       Both are released under the GNU General Public License, version 2 or later.

ubuntu-dev-tools						 February 25, 2008					   PBUILDER-DIST-SIMPLE(1)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Where is my unix id stored in the system?

Discussion started by: XZOR

2. Solaris

Executing MS-SQL stored procedures from Unix/C Program?

Discussion started by: mparks

3. UNIX for Advanced & Expert Users

Executing Stored Proc from unix prompt.

Discussion started by: arvindcgi

4. Shell Programming and Scripting

Need to call stored procedure from unix script

Discussion started by: mac4rfree