wildcards with if statement?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Convert Update statement into Insert statement in UNIX using awk, sed....

Hi folks, I have a scenario to convert the update statements into insert statements using shell script (awk, sed...) or in database using regex. I have a bunch of update statements with all columns in a file which I need to convert into insert statements. UPDATE TABLE_A SET COL1=1 WHERE...

2. UNIX for Advanced & Expert Users

Wildcards

These 2 websites do a GREAT job of explaining different types of wildcards. I learned about the categories of characters which I never knew about at all. GNU/Linux Command-Line Tools Guide - Wildcards GREP

3. Shell Programming and Scripting

Using wildcards in "if" statement

hey guys, what i am doing is that i would like the program to check if there was anything inputted. If nothing is imputed, it is suppose to display a message. echo -n "Enter Author:" read Author #echo -n "Enter Title:" #read Title if ] ; then echo "you enter something" else echo...

4. Shell Programming and Scripting

wildcards in "if then" statement

Hello, I would like to use a simple "if then" test to check if an argument to a command begins with "http://" as follows: if http://* ]]; then command fi but the wildcard just seems to be ignored, ie., it will only execute the command if the expression is strictly "http://" with...

5. Shell Programming and Scripting

wildcards in "if then" statement

Hello, I would like to use a simple "if then" test to check if an argument to a command begins with "http://" as follows: if http://* ]; then command fi but the wildcard just seems to be ignored, ie., it will only execute the command if the expression is strictly "http://" with nothing...

6. UNIX for Dummies Questions & Answers

wildcards NOT

Hi All Please excuse another straightforward question. When creating a tar archive from a directory I am attempting to use wildcards to eliminate certain filetypes (otherwise the archive gets too large). So I am looking for something along these lines. tar -cf archive.tar * <minus all *.rst...

7. UNIX for Dummies Questions & Answers

ls with wildcards

ok, I'm trying to write a script file that lists files with specific elements in the name into a txt file, it looks like this ls s*.dat > file_names.txt can't figure out whats wrong with that line, any ideas? thanks in advance

8. UNIX for Dummies Questions & Answers

wildcards

when writing a shell script (bourne) and using a unix command like 'ls' is there anything special you need to do to use a wildcard (like *)?

9. Shell Programming and Scripting

How can I make an if [ -f ] statement with wildcards?

Normally you would have something like.. if then foo bar fi but what if you wanted to do something like if then foo bar fi How do I get Unix to accept anything that matches a pattern of FILENAME with anything after it during an in if statement?

10. UNIX for Dummies Questions & Answers

How can I put wildcards in an if statement that uses variables?

With the if statement: if How can I make it so it accepts a wildcard after the ${CURR_DAY_MONTH} variable? Putting a -f /webtrends/SUN/mrw2/access.${CURR_DAY_DAY}${CURR_DAY_MONTH}* won't work, right? I think I need some kind of special character so it knows the wildcard is...

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 parameters

SYNOPSIS

       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)

Shell Programming and Scripting