How to compile a stored procedure that is there with in a script file(.sql) in unix

10 More Discussions You Might Find Interesting

1. How to Post in the The UNIX and Linux Forums

Calling a Sybase Stored procedure from a UNIX Script

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

2. Shell Programming and Scripting

Execute stored procedure through script in sybase database and store the output in a .csv file

Hi, I have a sybase stored procedure which takes two input parameters (start_date and end_date) and when it get executed, it gives few records as an output. I want to write a unix script (ksh) which login to the sybase database, then execute this stored procedure (takes the input parameter as...

3. Shell Programming and Scripting

Call and redirect output of Oracle stored procedure from unix script

Hi, Can you assist me in how to redirect the output of oracle stored procedure from unix script? Something similar to what i did for sybase isql -U$MYDBLOG -D$MYDBNAME -S$MYDBSVR -P$MYDBPWD -o$MYFILE<< %% proc_my_test 8 go %% Thanks in advance - jak

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

5. Shell Programming and Scripting

how to store the return values of stored procedure in unix shell script.

hi i am calling a oracle stored procedure(in the database) from unix shell scripting (a.sh). the called stored procedure returns some values through OUT variables i want to assign the return values of stored procedure in to unix shell script variable. can you provide me the code. ...

6. Programming

Help with pl/sql stored procedure

Hi, Can anyone please let me know where to check if a particular stored procedure exists. If the procedure exists I want to display some message and if the procedure does not exists i want to exit with error message. checking from dba_objects doesnt help. suprisingly the procedure i...

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

8. Shell Programming and Scripting

Invoking Oracle stored procedure in unix shell script

Here's a shell script snippet..... cd $ORACLE_HOME/bin Retval=`sqlplus -s <<eof $TPDB_USER/april@$TPD_DBCONN whenever SQLERROR exit 2 rollback whenever OSERROR exit 3 rollback set serveroutput on set pages 999 var status_desc char(200) var status_code...

9. Shell Programming and Scripting

calling a PL/SQL stored procedure from KSH

Hi I have a stored procedure which should be called from KSH. Could ayone please help me with this. Thanks

10. Shell Programming and Scripting

Calling an Oracle Stored Procedure from Unix shell script

hai, can anybody say how to call or to execute an oracle stored procedure in oracle from unix... thanks in advance.... for ur reply.... by, leo

LEARN ABOUT DEBIAN

h5cc

h5cc(1) 						      General Commands Manual							   h5cc(1)

NAME

       h5cc - Helper script to compile HDF5 applications.

SYNOPSIS

       h5cc [OPTIONS] <compile line>

DESCRIPTION

       h5cc can be used in much the same way MPIch is used to compile an HDF5 program. It takes care of specifying where the HDF5 header files and
       libraries are on the command line.

       h5cc supercedes all other compiler scripts in that if you've used them to compile the HDF5 library, then h5cc also uses those scripts.  For
       example,  when compiling an MPIch program, you use the mpicc script. If you've built HDF5 using MPIch, then h5cc uses the MPIch program for
       compilation.

       Some programs use HDF5 in only a few modules. It isn't necessary to use h5cc to compile those modules which don't use HDF5. In fact,  since
       h5cc is only a convenience script, you are still able to compile HDF5 modules in the normal way. In that case, you will have to specify the
       HDF5 libraries and include paths yourself.

       An example of how to use h5cc to compile the program hdf_prog, which consists of modules prog1.c and  prog2.c  and  uses  the  HDF5  shared
       library, would be as follows:
	      # h5cc -c prog1.c # h5cc -c prog2.c # h5cc -shlib -o hdf_prog prog1.o prog2.o

OPTIONS

       -help  Prints a help message.

       -echo  Show all the shell commands executed.

       -prefix=DIR
	      Use the directory DIR to find the HDF5 lib/ and include/ subdirectories.	Default: prefix specified when configuring HDF5.

       -show  Show the commands without executing them.

       -shlib Compile using shared HDF5 libraries.

       -noshlib
	      Compile using static HDF5 libraries [default].

       <compile line>
	      The  normal compile line options for your compiler. h5cc uses the same compiler you used to compile HDF5. Check your compiler's man-
	      ual for more information on which options are needed.

ENVIRONMENT

       HDF5_CC
	      Use a different C compiler.

       HDF5_CLINKER
	      Use a different linker.

       HDF5_USE_SHLIB=[yes|no]
	      Use shared version of the HDF5 library [default: no].

SEE ALSO

       h5fc(1), h5c++(1)

																	   h5cc(1)

Shell Programming and Scripting