Grepping for one variable while using awk to parse an associated variable Post: 303042712

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

grepping a variable

I need to pass a parameter that will then be grepped. I need it to grep /paramater and then have a space so if 123 was passed my grep would be grep '/123 ' sample.log this works fine from the command line but when i try and set it searchThis="/$2 " and then run grep $searchThis...

2. Shell Programming and Scripting

assign awk's variable to shell script's variable?

Dear All, we have a command output which looks like : Total 200 queues in 30000 Kbytes and we're going to get "200" and "30000" for further process. currently, i'm using : numA=echo $OUTPUT | awk '{print $2}' numB=echo $OUTPUT | awk '{print $5}' my question is : can I use just one...

3. Shell Programming and Scripting

Grepping Date Variable

Hello, I would like for the user to input the date for a particular log file, then have the input sent to a variable, which is then used via grep to extra the logs for the specific date the user request. I did some searching, but I still don't understand why I'm not seeing any result. ...

4. Shell Programming and Scripting

using awk for setting variable but change the output of this variable within awk

Hi all, Hope someone can help me out here. I have this BASH script (see below) My problem lies with the variable path. The output of the command find will give me several fields. The 9th field is the path. I want to captured that and the I want to filter this to a specific level. The...

5. Shell Programming and Scripting

Help about parse the variable

I'm using bash the code is QEMU_CMD="qemu-system-x86_64 -smp 2 -m 512 $QEMU_PARAMETER -hda $GUEST_IMAGE -kernel $GUEST_KERNEL -append \"root=/dev/hda rw console=ttyS0,115200 ip=$IP_PARAMETER \" -nographic" echo "..............................." echo "qemu command is...

6. Shell Programming and Scripting

Grepping for variable in brackets

I have a script which reads a number out of a log file. The pertinent line is this: cat /tmp/listofnumbers When I run cat /tmp/listofnumbers what I am seeing is on each line. I am trying to make the script read from that file and grep for a variable like the following line should do: ...

7. Shell Programming and Scripting

awk print variable then fields in variable

i have this variable: varT="1--2--3--5" i want to use awk to print field 3 from this variable. i dont want to do the "echo $varT". but here's my awk code: awk -v valA="$varT" "BEGIN {print valA}" this prints the entire line. i feel like i'm so close to getting what i want. i...

8. Shell Programming and Scripting

Grepping the file into a variable after SSH into a server

Hi All, When i am logged into a server , i am able to assign grep value to a variable as follows. VAR=`grep 'Listener stopped' /logs/perf.log` However, when i log out of the server, and try to execute the following command by first SSHing into server, it throws error. $ VAR=`ssh Server...

9. Shell Programming and Scripting

How to handle grepping variable data containing wildcards?

I have a lot of files with keywords and unique names. I'm using a shell script to refer to a simple pattern file with comma separated values in order to match on certain keywords. The problem is that I don't understand how to handle the wildcard values when I want to skip over the unique names. ...

10. UNIX for Beginners Questions & Answers

How can I assign awk's variable to shell script's variable?

I have the following script, and I want to assign the output ($10 and $5) from awk to N and L: grdinfo data.grd | awk '{print $10,$5}'| read N L output from gridinfo data.grd is: data.grd 50 100 41 82 -2796 6944 0.016 0.016 3001 2461. where N and L is suppose to be 3001 and 100. I use...

LEARN ABOUT PHP

db2_columns

DB2_COLUMNS(3)								 1							    DB2_COLUMNS(3)

db2_columns - Returns a result set listing the columns and associated metadata for a table

SYNOPSIS

       resource db2_columns (resource  $connection, [string  $qualifier], [string  $schema], [string  $table-name], [string  $column-name])

DESCRIPTION

	Returns a result set listing the columns and associated metadata for a table.

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 tables. To match all schemas, pass '%'.

	      o $table-name
		- The name of the table or view. To match all tables in the database, pass NULL or an empty string.

	      o $column-name
		- The name of the column. To match all columns in the table, pass NULL or an empty string.

RETURN VALUES

	Returns a statement resource with a result set containing rows describing the columns matching the specified parameters. The rows are com-
       posed of the following columns:

       +------------------+---------------------------------------------------+
       |   Column name	  |						      |
       |		  |						      |
       |		  |		       Description		      |
       |		  |						      |
       +------------------+---------------------------------------------------+
       |    TABLE_CAT	  |						      |
       |		  |						      |
       |		  | Name of the catalog. The value is  NULL  if  this |
       |		  | table does not have catalogs.		      |
       |		  |						      |
       |   TABLE_SCHEM	  |						      |
       |		  |						      |
       |		  |		   Name of the schema.		      |
       |		  |						      |
       |   TABLE_NAME	  |						      |
       |		  |						      |
       |		  |	       Name of the table or view.	      |
       |		  |						      |
       |   COLUMN_NAME	  |						      |
       |		  |						      |
       |		  |		   Name of the column.		      |
       |		  |						      |
       |    DATA_TYPE	  |						      |
       |		  |						      |
       |		  | The  SQL  data type for the column represented as |
       |		  | an integer value.				      |
       |		  |						      |
       |    TYPE_NAME	  |						      |
       |		  |						      |
       |		  | A string representing the data type for the  col- |
       |		  | umn.					      |
       |		  |						      |
       |   COLUMN_SIZE	  |						      |
       |		  |						      |
       |		  | An	integer  value	representing  the size of the |
       |		  | column.					      |
       |		  |						      |
       |  BUFFER_LENGTH   |						      |
       |		  |						      |
       |		  |  Maximum number of bytes necessary to store  data |
       |		  | from this column.				      |
       |		  |						      |
       | DECIMAL_DIGITS   |						      |
       |		  |						      |
       |		  |  The  scale of the column, or NULL where scale is |
       |		  | not applicable.				      |
       |		  |						      |
       | NUM_PREC_RADIX   |						      |
       |		  |						      |
       |		  |  An integer value of either 10  (representing  an |
       |		  | exact  numeric  data  type),  2  (representing an |
       |		  | approximate numeric data type), or	NULL  (repre- |
       |		  | senting a data type for which radix is not appli- |
       |		  | cable).					      |
       |		  |						      |
       |    NULLABLE	  |						      |
       |		  |						      |
       |		  | An integer value representing whether the  column |
       |		  | is nullable or not. 			      |
       |		  |						      |
       |     REMARKS	  |						      |
       |		  |						      |
       |		  |	       Description of the column.	      |
       |		  |						      |
       |   COLUMN_DEF	  |						      |
       |		  |						      |
       |		  |	      Default value for the column.	      |
       |		  |						      |
       |  SQL_DATA_TYPE   |						      |
       |		  |						      |
       |		  | An	integer  value	representing  the size of the |
       |		  | column.					      |
       |		  |						      |
       |SQL_DATETIME_SUB  |						      |
       |		  |						      |
       |		  |  Returns an integer value representing a datetime |
       |		  | subtype code, or NULL for SQL data types to which |
       |		  | this does not apply.			      |
       |		  |						      |
       |CHAR_OCTET_LENGTH |						      |
       |		  |						      |
       |		  |  Maximum length in octets for  a  character  data |
       |		  | type  column,  which matches COLUMN_SIZE for sin- |
       |		  | gle-byte character set data,  or  NULL  for  non- |
       |		  | character data types.			      |
       |		  |						      |
       |ORDINAL_POSITION  |						      |
       |		  |						      |
       |		  | The  1-indexed  position of the column in the ta- |
       |		  | ble.					      |
       |		  |						      |
       |   IS_NULLABLE	  |						      |
       |		  |						      |
       |		  |  A string value where 'YES' means that the column |
       |		  | is nullable and 'NO' means that the column is not |
       |		  | nullable.					      |
       |		  |						      |
       +------------------+---------------------------------------------------+
SEE ALSO

       db2_column_privileges(3), db2_foreign_keys(3), db2_primary_keys(3),  db2_procedure_columns(3),  db2_procedures(3),  db2_special_columns(3),
       db2_statistics(3), db2_table_privileges(3), db2_tables(3).

PHP Documentation Group 													    DB2_COLUMNS(3)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

grepping a variable

Discussion started by: magnia

2. Shell Programming and Scripting

assign awk's variable to shell script's variable?

Discussion started by: tiger2000

3. Shell Programming and Scripting

Grepping Date Variable

Discussion started by: ravzter

4. Shell Programming and Scripting

using awk for setting variable but change the output of this variable within awk

Discussion started by: Cowardly