Assuming you're using Bash as your shell, this is the ideal situation for the case statement. Consider the following example:
Here the script reads all the parameters one at a time from the file data.txt, and if they start with a lower- or upper-case J or M the appropriate function is called. If the parameter under consideration starts with any other character whatsoever, no function is called, and the script moves right on to the next parameter in the file, continuing in this manner until it reaches the end.
How to get exit value of an executable that gets called from function?
I have an executable called “myexec” which returns 0 on success and different values for different fail scenarios.
I need to call this (myexec) executable from “myprog()” function of other executable and get the exit value... (1 Reply)
Hi ,
I have three funcions f1, f2 and f3 .
f1 calls f2 and f2 calls f3 .
I have a global variable "period" which i want to pass to f3 .
Can i pass the variable directly in the definition of f3 ?
Pls help .
sars (4 Replies)
Hello,
I am new to unix hence struggling with my requirement.
I have a string like :
ECR/CHQ/GBP/12345.out
I need to get only the ECR/CHQ/GBP portion of the string(cut the string based on the third occurrence of / )...How do it do it?
Many thanks (3 Replies)
Hello Experts,
I am building a shell where I need to use case structure. The structure is in a function as in the sample code below:
# Shell mySh
#!/bin/sh
doThis(){
var=$1
case "$var" in
IT)
echo "ok 1 $var"
;;
... (7 Replies)
Hi Guys,
I am trying to pass arguments to the script i am wrinting.
When no argument is passed or wrong argument is passed, the script needs to output the way it needs to be called and exit.
Currently, when no arguments is passed, it is not getting exited but goes on assuming those... (3 Replies)
We have a program source C and is required to indicate how many times each function is called from the C program. also print the line number where there is a call.
I've tried something like this:
#!/bin/sh
for i in $*;do
if !
then
echo $i is not a C file.
else echo $i... (0 Replies)
Good day, I am a newbie here and thanks for accepting me
I have a task to modify input data where my input data looks like
123|34567|CHINE
1|23|INDIA
34512|21|USA
104|901|INDIASee that my input has two columns with different character length but max length is 5 and minimum length is 0 which... (1 Reply)
I have the below script which creates a directory or simply terminates without throwing error (exit 1) incase the directory exists.
bash-4.1$ vi mdir.sh
#!/bin/bash -e
shopt -s expand_aliases
alias mkdir=mkdir_s
mkdir_s(){
if ]; then
echo " directory EXISTS "
return
else
echo "... (3 Replies)
Hello,
I have this awk code in a bash script to perform a find and replace task. This finds one unique line in a file and substitutes the found line with a replacement.
#! /bin/bash
# value determined elsewhere
total_outputs_p1=100
# file being modified... (5 Replies)
Discussion started by: LMHmedchem
5 Replies
LEARN ABOUT PHP
db2_procedure_columns
DB2_PROCEDURE_COLUMNS(3) 1 DB2_PROCEDURE_COLUMNS(3)db2_procedure_columns - Returns a result set listing stored procedure parametersSYNOPSIS
resource db2_procedure_columns (resource $connection, string $qualifier, string $schema, string $procedure, string $parameter)
DESCRIPTION
Returns a result set listing the parameters for one or more stored procedures.
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.
o $parameter
- The name of the parameter. This parameter accepts a search pattern containing _ and % as wildcards. If this parameter is NULL,
all parameters for the specified stored procedures are returned.
RETURN VALUES
Returns a statement resource with a result set containing rows describing the parameters for 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. |
| | |
| COLUMN_NAME | |
| | |
| | Name of the parameter. |
| | |
| COLUMN_TYPE | |
| | |
| | An integer value representing the type of the |
| | parameter: |
| | |
| | box, tab (|); c | c | . T{ Return value |
| | |
| | Parameter type |
| | |
+---------------------------+---------------------------------------------------+
| 1 (SQL_PARAM_INPUT) | |
| | |
| | Input (IN) parameter. |
| | |
|2 (SQL_PARAM_INPUT_OUTPUT) | |
| | |
| | Input/output (INOUT) parameter. |
| | |
| 3 (SQL_PARAM_OUTPUT) | |
| | |
| | Output (OUT) parameter. |
| | |
+---------------------------+---------------------------------------------------+
T} T{ DATA_TYPE
T} |T{ The SQL data type for the parameter represented as an integer value.
T} T{ TYPE_NAME
T} |T{ A string representing the data type for the parameter.
T} T{ COLUMN_SIZE
T} |T{ An integer value representing the size of the parameter.
T} T{ BUFFER_LENGTH
T} |T{
Maximum number of bytes necessary to store data for this parameter.
T} T{ DECIMAL_DIGITS
T} |T{
The scale of the parameter, or NULL where scale is not applicable.
T} T{ NUM_PREC_RADIX
T} |T{
An integer value of either 10 (representing an exact numeric data type), 2 (representing an approximate numeric data type), or NULL (rep-
resenting a data type for which radix is not applicable).
T} T{ NULLABLE
T} |T{ An integer value representing whether the parameter is nullable or not.
T} T{ REMARKS
T} |T{ Description of the parameter.
T} T{ COLUMN_DEF
T} |T{ Default value for the parameter.
T} T{ SQL_DATA_TYPE
T} |T{ An integer value representing the size of the parameter.
T} T{ SQL_DATETIME_SUB
T} |T{
Returns an integer value representing a datetime subtype code, or NULL for SQL data types to which this does not apply.
T} T{ CHAR_OCTET_LENGTH
T} |T{
Maximum length in octets for a character data type parameter, which matches COLUMN_SIZE for single-byte character set data, or NULL for
non-character data types.
T} T{ ORDINAL_POSITION
T} |T{ The 1-indexed position of the parameter in the CALL statement.
T} T{ IS_NULLABLE
T} |T{
A string value where 'YES' means that the parameter accepts or returns NULL values and 'NO' means that the parameter does not accept or
return NULL values.
T}
SEE ALSO db2_column_privileges(3), db2_columns(3), db2_foreign_keys(3), db2_primary_keys(3), db2_procedures(3), db2_special_columns(3), db2_statis-
tics(3), db2_table_privileges(3), db2_tables(3).
PHP Documentation Group DB2_PROCEDURE_COLUMNS(3)