12-11-2008
This isn't really a scripting question so much as a DB2 question, because the return codes for different error or warning conditions while executing DB2 are entirely defined by DB2.
Perhaps if you check the DB2 documentation it will describe what codes are returned under what conditions, and thereby allow you modify your shell script to handle them appropriately. Maybe it would be safe for you to ignore error code 1, and only report other error codes.
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have a file "dbshot.xml" that contains lines that need replacing in a batch format but the parameters are based on two lines.
Ex.
<role roletype="01">
<status>1
needs to be changed to
<role roletype="01">
<status>0
I can't use simply "<status>1" replace since the... (2 Replies)
Discussion started by: E Orgill
2 Replies
2. UNIX Desktop Questions & Answers
Issue resolved:
The 'culprit file' was .bash_aliases. It had the naughty (ASCII for the octal string Bash was detecting and returning an error about). I cleaned it up in Pico (see my post to the thread on favorite editors if you want background on why I use Pico/Nano), re-sourced it via... (0 Replies)
Discussion started by: SilversleevesX
0 Replies
3. Shell Programming and Scripting
Hi All,
Does anyone has script to align java/c/c++ code? or pls advice
I need it very badly...... :-(
Thanks in advance (4 Replies)
Discussion started by: askumarece
4 Replies
4. Shell Programming and Scripting
I have another Question:
I tried to run the following script: (I actually wanted to print out the second field in the text field.)
#!/usr/bin/ksh
set -x
readfile=/dir1/data.txt
cat $readfile | while read line
do
x = `echo $line|awk '{print $2}'`
echo $x
done
But, it shows the... (3 Replies)
Discussion started by: ss3944
3 Replies
5. Shell Programming and Scripting
I am writing a wrapper to one of the .ksh script. The wrapper script should capture the error/fatal(if any) and exit out of the script. Here is the script:
#!/bin/sh
. main_script.ksh <arg1> <arg2> > mainscript.log 2>&1
cnt=`grep 'ERROR' -c mainscript.log`
if ; then
echo "Error"
... (6 Replies)
Discussion started by: stunnerz_84
6 Replies
6. Red Hat
I am running a script that runs a loop and executes a command on ${i} until the end of the for loop.
From time to time the command generates an error ( which is good) for example ERROR0005:
How can I trap the error and send an email echoing the ${i} variable in the loop and the error ?
... (2 Replies)
Discussion started by: pcpinkerton
2 Replies
7. Shell Programming and Scripting
Hi
i need code to get sql queries through a shell script for a text file input which contain the service ids
iputfile
I-H-2048-10GB-M
I-H-4096-12GB-M
I-H-2048-p1000-M
the code should contain below queries among which service_id is replacable with value from input file.
... (4 Replies)
Discussion started by: surender reddy
4 Replies
8. Shell Programming and Scripting
Hey Friends, its me again! :o
I was asked to create a script that would go into our backup directories and delete/purge anything in the directory after a certain amount of days, normally I would be able to write something up that goes to the directory finds it and deletes it.
cd... (12 Replies)
Discussion started by: gkelly1117
12 Replies
9. Red Hat
I have an application rpm which when installed is failing to get installed with error
error: Failed dependencies:
libc.so.6 is needed by testSam-4.7.x86_64
libc.so.6(GLIBC_2.0) is needed by testSam-4.7.x86_64
libc.so.6(GLIBC_2.1) is needed by testSam-4.7.x86_64
... (1 Reply)
Discussion started by: rupeshkp728
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)