Sponsored Content
Top Forums Shell Programming and Scripting Help needed with error code.. Post 302267190 by Annihilannic on Thursday 11th of December 2008 08:30:28 PM
Old 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

Find and Replace code help needed

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

Help needed tracing source of bash error

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

Script needed to align java/c/C++ code

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

Error running the script.... Help needed. Please

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

Help needed with error handling

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

KSH script help needed ( nice error trap routine ?)

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

Code needed to get sql queries

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

Value Too Great for Base Error, Explanation and Workout needed

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

RPM Install error: libc.so.6 is needed by

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
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)
All times are GMT -4. The time now is 02:14 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy