10 More Discussions You Might Find Interesting
1. How to Post in the The UNIX and Linux Forums
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. Shell Programming and Scripting
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... (8 Replies)
Discussion started by: amit.mathur08
8 Replies
3. Shell Programming and Scripting
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 (0 Replies)
Discussion started by: jakSun8
0 Replies
4. Shell Programming and Scripting
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; (1 Reply)
Discussion started by: shirdi
1 Replies
5. Shell Programming and Scripting
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.
... (1 Reply)
Discussion started by: barani75
1 Replies
6. Programming
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... (3 Replies)
Discussion started by: justchill
3 Replies
7. Shell Programming and Scripting
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... (1 Reply)
Discussion started by: mac4rfree
1 Replies
8. Shell Programming and Scripting
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... (1 Reply)
Discussion started by: hidnana
1 Replies
9. Shell Programming and Scripting
Hi
I have a stored procedure which should be called from KSH.
Could ayone please help me with this.
Thanks (1 Reply)
Discussion started by: BlAhEr
1 Replies
10. Shell Programming and Scripting
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 (2 Replies)
Discussion started by: Leojhose
2 Replies
fileutil::magic::cfront(n) file utilities fileutil::magic::cfront(n)
__________________________________________________________________________________________________________________________________________________
NAME
fileutil::magic::cfront - Generator core for compiler of magic(5) files
SYNOPSIS
package require Tcl 8.4
package require fileutil::magic::cfront ?1.0?
package require fileutil::magic::cgen ?1.0?
package require fileutil::magic::rt ?1.0?
package require struct::list
package require fileutil
::fileutil::magic::cfront::compile path...
::fileutil::magic::cfront::procdef procname path...
::fileutil::magic::cfront::install path...
_________________________________________________________________
DESCRIPTION
This package provides the frontend of a compiler of magic(5) files into recognizers based on the fileutil::magic::rt recognizer runtime
package. For the generator backed used by this compiler see the package fileutil::magic::cgen.
COMMANDS
::fileutil::magic::cfront::compile path...
This command takes the paths of one or more files and directories and compiles all the files, and the files in all the directories
into a single recognizer for all the file types specified in these files.
All the files have to be in the format specified by magic(5).
The result of the command is a Tcl script containing the generated recognizer.
::fileutil::magic::cfront::procdef procname path...
This command behaves like ::fileutil::magic::cfront::compile with regard to the specified path arguments, then wraps the resulting
recognizer script into a procedure named procname, puts code setting up the namespace of procname in front, and returns the result-
ing script.
::fileutil::magic::cfront::install path...
This command uses ::fileutil::magic::cfront::procdef to compile each of the paths into a recognizer procedure and installs the
result in the current interpreter.
The name of each new procedure is derived from the name of the file/directory used in its creation, with file/directory "FOO" caus-
ing the creation of procedure ::fileutil::magic::/FOO::run.
BUGS, IDEAS, FEEDBACK
This document, and the package it describes, will undoubtedly contain bugs and other problems. Please report such in the category fileutil
:: magic of the Tcllib SF Trackers [http://sourceforge.net/tracker/?group_id=12883]. Please also report any ideas for enhancements you may
have for either package and/or documentation.
SEE ALSO
file(1), fileutil, magic(5)
KEYWORDS
file recognition, file type, file utilities, mime, type
CATEGORY
Programming tools
fumagic 1.0 fileutil::magic::cfront(n)