|
|
Sponsored Content
Top Forums
Programming
How to call sqlloader from stored procedure!!! Advise
Post 302324968 by Haque123 on Friday 12th of June 2009 10:15:23 AM
06-12-2009
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
I am using sqlplus.
I have the stored procedure name.
How can i print the stored procedure content? (2 Replies)
Discussion started by: kamil
2 Replies
2. 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
3. Shell Programming and Scripting
Hi GUYS,
I need to trigger 3 stored procedure at the same time..
I know how to trigger the stored procedure. If anybody can tell me how to trigger 3 different process at the same time parallelly.. that would be helpful..
Thanks for your help in advance,
Magesh (1 Reply)
Discussion started by: mac4rfree
1 Replies
4. Shell Programming and Scripting
Hi
i want to call a oracle stored procedure from unix (using bash shell).
consider this is my oracle stored procedure with parameter
create procedure testproc(name IN varchar, age IN Number, id OUT Number )
AS
begin
id=1;
dbms_output.put.line('successfull validation')
end;... (6 Replies)
Discussion started by: barani75
6 Replies
5. 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
6. Shell Programming and Scripting
Hi,
I want to create MySQL stored procedure and call the stored procedure using perl.
I tried like this:
use DBI;
my $dbh = DBI->connect ("DBI:mysql:test",
"root", "ibab",
{ RaiseError => 1, PrintError => 0});
$create_procedure =... (5 Replies)
Discussion started by: vanitham
5 Replies
7. Shell Programming and Scripting
How to call a stored procedure from shell program (1 Reply)
Discussion started by: noorm
1 Replies
8. Shell Programming and Scripting
I have written a stored procedure in oracle database, which is having a CLOB OUT parameter. How can i call this stored procedure from shell script and get the CLOB object in shell script variable? (0 Replies)
Discussion started by: vel4ever
0 Replies
9. 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
10. Shell Programming and Scripting
How to call a stored procedure inside a loop
export PATH=$ORACLE_HOME/bin:$PATH
ORACLE_SID=xxxx; export ORACLE_SID ORAENV_ASK=NO
TODAY_DATE=$(date +"%Y%m%d")
LOGFILE=/var/opt/gogd/cust/scripts/${TODAY_DATE}_sap_cust_rel.log
echo 'Connected'
PARCUST=sap_cust_rel.par
sqlldr... (1 Reply)
Discussion started by: ashwanth
1 Replies
LEARN ABOUT PHP
db2_procedures
DB2_PROCEDURES(3) 1 DB2_PROCEDURES(3) db2_procedures - Returns a result set listing the stored procedures registered in a database SYNOPSIS
resource db2_procedures (resource $connection, string $qualifier, string $schema, string $procedure) DESCRIPTION
Returns a result set listing the stored procedures registered in a database. PARAMETERS
o $connection - A valid connection to an IBM DB2, Cloudscape, or Apache Derby database. o $qualifier - A qualifier for DB2 databases running on OS/390 or z/OS servers. For other databases, pass NULL or an empty string. o $schema - The schema which contains the procedures. This parameter accepts a search pattern containing _ and % as wildcards. o $procedure - The name of the procedure. This parameter accepts a search pattern containing _ and % as wildcards. RETURN VALUES
Returns a statement resource with a result set containing rows describing the stored procedures matching the specified parameters. The rows are composed of the following columns: +------------------+---------------------------------------------------+ | Column name | | | | | | | Description | | | | +------------------+---------------------------------------------------+ | PROCEDURE_CAT | | | | | | | The catalog that contains the procedure. The | | | value is NULL if this table does not have cata- | | | logs. | | | | | PROCEDURE_SCHEM | | | | | | | Name of the schema that contains the stored pro- | | | cedure. | | | | | PROCEDURE_NAME | | | | | | | Name of the procedure. | | | | |NUM_INPUT_PARAMS | | | | | | | Number of input (IN) parameters for the stored | | | procedure. | | | | |NUM_OUTPUT_PARAMS | | | | | | | Number of output (OUT) parameters for the stored | | | procedure. | | | | | NUM_RESULT_SETS | | | | | | | Number of result sets returned by the stored pro- | | | cedure. | | | | | REMARKS | | | | | | | Any comments about the stored procedure. | | | | | PROCEDURE_TYPE | | | | | | | Always returns 1, indicating that the stored pro- | | | cedure does not return a return value. | | | | +------------------+---------------------------------------------------+ SEE ALSO
db2_column_privileges(3), db2_columns(3), db2_foreign_keys(3), db2_primary_keys(3), db2_procedure_columns(3), db2_special_columns(3), db2_statistics(3), db2_table_privileges(3), db2_tables(3). PHP Documentation Group DB2_PROCEDURES(3)