Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Function to add escape character before specified character
Top Forums Shell Programming and Scripting Function to add escape character before specified character Post 302881593 by Yoda on Monday 30th of December 2013 12:05:29 PM
Old 12-30-2013
Another approach:
Code:
SPECIAL_CHARS='& ;'
ESCAPE_CHAR='\'
echo 'abcd fkaj&dsdsd' | awk -v SC="$SPECIAL_CHARS" -v EC="$ESCAPE_CHAR" '
        BEGIN {
                n = split ( SC, A )
        }
        {
                for ( i = 1; i <= n; i++ )
                        gsub ( A[i], EC "\\&", $0 )
                print
        }
'

This User Gave Thanks to Yoda For This Post:
Anupam_Halder
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

possible to escape the \ character in sed?

is it possible to escape the \ character in sed? right now I'm trying to replace all occurances of \ with \\ sed \"s|test|test_replacement|g\" file1 > output; #this works fine sed \"s|\\|\\\|g\" file1 > output; #this generates the following error: sed: -e expression #1, char 17:... (1 Reply)
Discussion started by: gammaman
1 Replies

2. Shell Programming and Scripting

Escape character in vi?

I want to replace a string which contains "/" in vi but what is the escape character for forward slash? e.g. I have a text file with the contents below and I want to replace "/Top/Sub/Sub1" with "ABC". /Top/Sub/Sub1 The replace command I am using is ... (4 Replies)
Discussion started by: stevefox
4 Replies

3. Shell Programming and Scripting

awk / escape character

Hi I'm trying to split a dir listing eg /home/foo1/foo2 I'm using ksh I've tried dir=/home/foo1/foo2 splitit=`echo $dir | awk -F '\/' '{print $1}'` echo $splitit nothing is output! I have checked the escape character. The only one I have found is \ BTW `pwd` | awk -F \/... (8 Replies)
Discussion started by: OFFSIHR
8 Replies

4. Shell Programming and Scripting

Escape character

Hi , I want to change space to ' in my script. I tried doing this, sed 's/ /\'/g' filename but i could not get it. can some one help me please. Thanks, Deepak (4 Replies)
Discussion started by: deepakpv
4 Replies

5. Shell Programming and Scripting

escape character in tcsh

Hello, I wanted to display command with echo like this in tcsh. output should be "//'test.test1.test2'" (" at both ends also required in output) Please help me. (1 Reply)
Discussion started by: balareddy
1 Replies

6. Shell Programming and Scripting

Escape character in sed

Hello experts I am trying to write a shell script which will add ' ' to a unix variable and then pass it to oracle for inserting to a table. I am running the script as root and I have to do a su -c . The problem is the character ' is not recognised inside sed even after adding escape... (1 Reply)
Discussion started by: pvedaa
1 Replies

7. UNIX for Advanced & Expert Users

if 4th and 5th character of sting -ge 45 then add 1 to 3rd character

I want to know how to, given a string like W87151WR71C, if the 4th and 5th character (in this case 15) are greater than 45, then to add 1 to the 3rd character (in this case 7) and assign the revised string the variable name MODSTRING. Thanks in advance. This is ultimately to grab info from... (6 Replies)
Discussion started by: glev2005
6 Replies

8. Shell Programming and Scripting

Problem with using a sed to add escape character \ before $ and ' symbols

Hi all, I've got a problem with sed. Want to use it to add escape character \ before $ and ' symbols so condition='1'$some will become condition=\'1\'\$some echo "condition='1'$some" | sed 's/\($\)/\\\1/g' is not working properly. Can somebody help me with this please? Regards,... (7 Replies)
Discussion started by: johny_be_good
7 Replies

9. Shell Programming and Scripting

sed - with escape character

i have string as below str=".<date>" in which i need to replace < with /< , when i tried with sed , got the output. --> echo $str | sed 's/</\\</g' .\<date> when i tried to assign it to a variable , i am not getting the same --> a=`echo $str | sed 's/</\\</g'` ; echo $a... (4 Replies)
Discussion started by: expert
4 Replies

10. Shell Programming and Scripting

Escape special character

Hi, How to use * in call to pl/sql block from shell script? The line "select * from" is causing all files and directiores to show up in email notification but if I give all column names then it works, Please let me know how to use '*' instead of giving all column names, in other wirds how to... (2 Replies)
Discussion started by: sandy162
2 Replies

LEARN ABOUT PHP

db2_server_info

DB2_SERVER_INFO(3)							 1							DB2_SERVER_INFO(3)

db2_server_info - Returns an object with properties that describe the DB2 database server

SYNOPSIS

       object db2_server_info (resource  $connection)

DESCRIPTION

	This  function returns an object with read-only properties that return information about the IBM DB2, Cloudscape, or Apache Derby database
       server. The following table lists the database server properties:

       Database server properties

       +----------------------+--------------------------------------+---+
       |    Property name     | 				     |	 |
       |		      | 				     |	 |
       |		      | 	    Return type 	     |	 |
       |		      | 				     |	 |
       |		      | 	    Description 	     |	 |
       |		      | 				     |	 |
       +----------------------+--------------------------------------+---+
       |      DBMS_NAME       | 				     |	 |
       |		      | 				     |	 |
       |		      | 	       string		     |	 |
       |		      | 				     |	 |
       |		      | The name of the database  server  to |	 |
       |		      | which  you  are  connected.  For DB2 |	 |
       |		      | servers this is a combination of DB2 |	 |
       |		      | followed  by the operating system on |	 |
       |		      | which the database  server  is	run- |	 |
       |		      | ning.				     |	 |
       |		      | 				     |	 |
       |      DBMS_VER	      | 				     |	 |
       |		      | 				     |	 |
       |		      | 	       string		     |	 |
       |		      | 				     |	 |
       |		      | The  version of the database server, |	 |
       |		      | in the form of a string "MM.mm.uuuu" |	 |
       |		      | where  $MM is the major version, $mm |	 |
       |		      | is the minor version, and  $uuuu  is |	 |
       |		      | the	update.     For     example, |	 |
       |		      | "08.02.0001" represents  major	ver- |	 |
       |		      | sion 8, minor version 2, update 1.   |	 |
       |		      | 				     |	 |
       |     DB_CODEPAGE      | 				     |	 |
       |		      | 				     |	 |
       |		      | 		int		     |	 |
       |		      | 				     |	 |
       |		      | The  code  page  of  the database to |	 |
       |		      | which you are connected.	     |	 |
       |		      | 				     |	 |
       |       DB_NAME	      | 				     |	 |
       |		      | 				     |	 |
       |		      | 	       string		     |	 |
       |		      | 				     |	 |
       |		      | The name of the  database  to  which |	 |
       |		      | you are connected.		     |	 |
       |		      | 				     |	 |
       |    DFT_ISOLATION     | 				     |	 |
       |		      | 				     |	 |
       |		      | 	       string		     |	 |
       |		      | 				     |	 |
       |		      | The  default  transaction  isolation |	 |
       |		      | level supported by the server:	     |	 |
       |		      | 				     |	 |
       |		      | 	      o UR		     |	 |
       |		      | 		- Uncommitted  read: |	 |
       |		      | 		changes  are immedi- |	 |
       |		      | 		ately visible by all |	 |
       |		      | 		concurrent  transac- |	 |
       |		      | 		tions.		     |	 |
       |		      | 				     |	 |
       |		      | 	      o CS		     |	 |
       |		      | 		- Cursor  stability: |	 |
       |		      | 		a  row	read  by one |	 |
       |		      | 		transaction  can  be |	 |
       |		      | 		altered  and commit- |	 |
       |		      | 		ted by a second con- |	 |
       |		      | 		current transaction. |	 |
       |		      | 				     |	 |
       |		      | 	      o RS		     |	 |
       |		      | 		-  Read stability: a |	 |
       |		      | 		transaction can  add |	 |
       |		      | 		or    remove	rows |	 |
       |		      | 		matching  a   search |	 |
       |		      | 		condition or a pend- |	 |
       |		      | 		ing transaction.     |	 |
       |		      | 				     |	 |
       |		      | 	      o RR		     |	 |
       |		      | 		-  Repeatable  read: |	 |
       |		      | 		data   affected   by |	 |
       |		      | 		pending  transaction |	 |
       |		      | 		is  not available to |	 |
       |		      | 		other transactions.  |	 |
       |		      | 				     |	 |
       |		      | 	      o NC		     |	 |
       |		      | 		-  No  commit:	 any |	 |
       |		      | 		changes  are visible |	 |
       |		      | 		at the end of a suc- |	 |
       |		      | 		cessful   operation. |	 |
       |		      | 		Explicit commits and |	 |
       |		      | 		rollbacks   are  not |	 |
       |		      | 		allowed.	     |	 |
       |		      | 				     |	 |
       |IDENTIFIER_QUOTE_CHAR | 				     |	 |
       |		      | 				     |	 |
       |		      | 	       string		     |	 |
       |		      | 				     |	 |
       |		      | The character  used  to  delimit  an |	 |
       |		      | identifier.			     |	 |
       |		      | 				     |	 |
       |      INST_NAME       | 				     |	 |
       |		      | 				     |	 |
       |		      | 	       string		     |	 |
       |		      | 				     |	 |
       |		      | The  instance on the database server |	 |
       |		      | that contains the database.	     |	 |
       |		      | 				     |	 |
       |  ISOLATION_OPTION    | 				     |	 |
       |		      | 				     |	 |
       |		      | 	       array		     |	 |
       |		      | 				     |	 |
       |		      | An array of  the  isolation  options |	 |
       |		      | supported  by  the  database server. |	 |
       |		      | The isolation options are  described |	 |
       |		      | in the DFT_ISOLATION property.	     |	 |
       |		      | 				     |	 |
       |      KEYWORDS	      | 				     |	 |
       |		      | 				     |	 |
       |		      | 	       array		     |	 |
       |		      | 				     |	 |
       |		      | An array of the keywords reserved by |	 |
       |		      | the database server.		     |	 |
       |		      | 				     |	 |
       | LIKE_ESCAPE_CLAUSE   | 				     |	 |
       |		      | 				     |	 |
       |		      | 		bool		     |	 |
       |		      | 				     |	 |
       |		      | 				     |	 |
       |		      | TRUE if the database server supports |	 |
       |		      | the  use of % and _ wildcard charac- |	 |
       |		      | ters.  FALSE if the database  server |	 |
       |		      | does   not  support  these  wildcard |	 |
       |		      | characters.			     |	 |
       |		      | 				     |	 |
       |  MAX_COL_NAME_LEN    | 				     |	 |
       |		      | 				     |	 |
       |		      | 		int		     |	 |
       |		      | 				     |	 |
       |		      | Maximum length of a column name sup- |	 |
       |		      | ported	 by   the  database  server, |	 |
       |		      | expressed in bytes.		     |	 |
       |		      | 				     |	 |
       | MAX_IDENTIFIER_LEN   | 				     |	 |
       |		      | 				     |	 |
       |		      | 		int		     |	 |
       |		      | 				     |	 |
       |		      | Maximum length of an SQL  identifier |	 |
       |		      | supported  by  the  database server, |	 |
       |		      | expressed in characters.	     |	 |
       |		      | 				     |	 |
       |   MAX_INDEX_SIZE     | 				     |	 |
       |		      | 				     |	 |
       |		      | 		int		     |	 |
       |		      | 				     |	 |
       |		      | Maximum size of columns combined  in |	 |
       |		      | an  index  supported by the database |	 |
       |		      | server, expressed in bytes.	     |	 |
       |		      | 				     |	 |
       |  MAX_PROC_NAME_LEN   | 				     |	 |
       |		      | 				     |	 |
       |		      | 		int		     |	 |
       |		      | 				     |	 |
       |		      | Maximum length of a  procedure	name |	 |
       |		      | supported  by  the  database server, |	 |
       |		      | expressed in bytes.		     |	 |
       |		      | 				     |	 |
       |    MAX_ROW_SIZE      | 				     |	 |
       |		      | 				     |	 |
       |		      | 		int		     |	 |
       |		      | 				     |	 |
       |		      | Maximum length of a row  in  a	base |	 |
       |		      | table	supported  by  the  database |	 |
       |		      | server, expressed in bytes.	     |	 |
       |		      | 				     |	 |
       | MAX_SCHEMA_NAME_LEN  | 				     |	 |
       |		      | 				     |	 |
       |		      | 		int		     |	 |
       |		      | 				     |	 |
       |		      | Maximum length of a schema name sup- |	 |
       |		      | ported	 by   the  database  server, |	 |
       |		      | expressed in bytes.		     |	 |
       |		      | 				     |	 |
       |  MAX_STATEMENT_LEN   | 				     |	 |
       |		      | 				     |	 |
       |		      | 		int		     |	 |
       |		      | 				     |	 |
       |		      | Maximum length of an  SQL  statement |	 |
       |		      | supported  by  the  database server, |	 |
       |		      | expressed in bytes.		     |	 |
       |		      | 				     |	 |
       | MAX_TABLE_NAME_LEN   | 				     |	 |
       |		      | 				     |	 |
       |		      | 		int		     |	 |
       |		      | 				     |	 |
       |		      | Maximum length of a table name	sup- |	 |
       |		      | ported	 by   the  database  server, |	 |
       |		      | expressed in bytes.		     |	 |
       |		      | 				     |	 |
       |NON_NULLABLE_COLUMNS  | 				     |	 |
       |		      | 				     |	 |
       |		      | 		bool		     |	 |
       |		      | 				     |	 |
       |		      | 				     |	 |
       |		      | TRUE if the database server supports |	 |
       |		      | columns  that  can be defined as NOT |	 |
       |		      | NULL, FALSE if the  database  server |	 |
       |		      | does  not support columns defined as |	 |
       |		      | NOT NULL.			     |	 |
       |		      | 				     |	 |
       |     PROCEDURES       | 				     |	 |
       |		      | 				     |	 |
       |		      | 		bool		     |	 |
       |		      | 				     |	 |
       |		      | 				     |	 |
       |		      | TRUE if the database server supports |	 |
       |		      | the  use  of  the  CALL statement to |	 |
       |		      | call stored procedures, FALSE if the |	 |
       |		      | database server does not support the |	 |
       |		      | CALL statement. 		     |	 |
       |		      | 				     |	 |
       |    SPECIAL_CHARS     | 				     |	 |
       |		      | 				     |	 |
       |		      | 	       string		     |	 |
       |		      | 				     |	 |
       |		      | A string containing all of the char- |	 |
       |		      | acters	other  than  a-Z,  0-9,  and |	 |
       |		      | underscore that can be	used  in  an |	 |
       |		      | identifier name.		     |	 |
       |		      | 				     |	 |
       |   SQL_CONFORMANCE    | 				     |	 |
       |		      | 				     |	 |
       |		      | 	       string		     |	 |
       |		      | 				     |	 |
       |		      | The  level  of	conformance  to  the |	 |
       |		      | ANSI/ISO    SQL-92     specification |	 |
       |		      | offered by the database server:      |	 |
       |		      | 				     |	 |
       |		      | 	      o ENTRY		     |	 |
       |		      | 		- Entry-level SQL-92 |	 |
       |		      | 		compliance.	     |	 |
       |		      | 				     |	 |
       |		      | 	      o FIPS127 	     |	 |
       |		      | 		- FIPS-127-2 transi- |	 |
       |		      | 		tional compliance.   |	 |
       |		      | 				     |	 |
       |		      | 	      o FULL		     |	 |
       |		      | 		-  Full level SQL-92 |	 |
       |		      | 		compliance.	     |	 |
       |		      | 				     |	 |
       |		      | 	      o INTERMEDIATE	     |	 |
       |		      | 		- Intermediate level |	 |
       |		      | 		SQL-92 compliance.   |	 |
       |		      | 				     |	 |
       +----------------------+--------------------------------------+---+
PARAMETERS

	      o $connection
		- Specifies an active DB2 client connection.

RETURN VALUES

	Returns an object on a successful call. Returns FALSE on failure.

EXAMPLES

       Example #1

	      A db2_server_info(3) example

	       To retrieve information about the server, you must pass a valid database connection resource to db2_server_info(3).

	      <?php

	      $conn = db2_connect('sample', 'db2inst1', 'ibmdb2');

	      $server = db2_server_info( $conn );

	      if ($server) {
		  echo "DBMS_NAME: ";		      var_dump( $server->DBMS_NAME );
		  echo "DBMS_VER: ";		      var_dump( $server->DBMS_VER );
		  echo "DB_CODEPAGE: "; 	      var_dump( $server->DB_CODEPAGE );
		  echo "DB_NAME: ";		      var_dump( $server->DB_NAME );
		  echo "INST_NAME: ";		      var_dump( $server->INST_NAME );
		  echo "SPECIAL_CHARS: ";	      var_dump( $server->SPECIAL_CHARS );
		  echo "KEYWORDS: ";		      var_dump( sizeof($server->KEYWORDS) );
		  echo "DFT_ISOLATION: ";	      var_dump( $server->DFT_ISOLATION );
		  echo "ISOLATION_OPTION: ";
		  $il = '';
		  foreach( $server->ISOLATION_OPTION as $opt )
		  {
		     $il .= $opt." ";
		  }
		  var_dump( $il );
		  echo "SQL_CONFORMANCE: ";	      var_dump( $server->SQL_CONFORMANCE );
		  echo "PROCEDURES: ";		      var_dump( $server->PROCEDURES );
		  echo "IDENTIFIER_QUOTE_CHAR: ";     var_dump( $server->IDENTIFIER_QUOTE_CHAR );
		  echo "LIKE_ESCAPE_CLAUSE: ";	      var_dump( $server->LIKE_ESCAPE_CLAUSE );
		  echo "MAX_COL_NAME_LEN: ";	      var_dump( $server->MAX_COL_NAME_LEN );
		  echo "MAX_ROW_SIZE: ";	      var_dump( $server->MAX_ROW_SIZE );
		  echo "MAX_IDENTIFIER_LEN: ";	      var_dump( $server->MAX_IDENTIFIER_LEN );
		  echo "MAX_INDEX_SIZE: ";	      var_dump( $server->MAX_INDEX_SIZE );
		  echo "MAX_PROC_NAME_LEN: ";	      var_dump( $server->MAX_PROC_NAME_LEN );
		  echo "MAX_SCHEMA_NAME_LEN: ";       var_dump( $server->MAX_SCHEMA_NAME_LEN );
		  echo "MAX_STATEMENT_LEN: ";	      var_dump( $server->MAX_STATEMENT_LEN );
		  echo "MAX_TABLE_NAME_LEN: ";	      var_dump( $server->MAX_TABLE_NAME_LEN );
		  echo "NON_NULLABLE_COLUMNS: ";      var_dump( $server->NON_NULLABLE_COLUMNS );

		  db2_close($conn);
	      }
	      ?>

	      The above example will output:

	      DBMS_NAME: string(9) "DB2/LINUX"
	      DBMS_VER: string(10) "08.02.0000"
	      DB_CODEPAGE: int(1208)
	      DB_NAME: string(6) "SAMPLE"
	      INST_NAME: string(8) "db2inst1"
	      SPECIAL_CHARS: string(2) "@#"
	      KEYWORDS: int(179)
	      DFT_ISOLATION: string(2) "CS"
	      ISOLATION_OPTION: string(12) "UR CS RS RR "
	      SQL_CONFORMANCE: string(7) "FIPS127"
	      PROCEDURES: bool(true)
	      IDENTIFIER_QUOTE_CHAR: string(1) """
	      LIKE_ESCAPE_CLAUSE: bool(true)
	      MAX_COL_NAME_LEN: int(30)
	      MAX_ROW_SIZE: int(32677)
	      MAX_IDENTIFIER_LEN: int(18)
	      MAX_INDEX_SIZE: int(1024)
	      MAX_PROC_NAME_LEN: int(128)
	      MAX_SCHEMA_NAME_LEN: int(30)
	      MAX_STATEMENT_LEN: int(2097152)
	      MAX_TABLE_NAME_LEN: int(128)
	      NON_NULLABLE_COLUMNS: bool(true)

SEE ALSO

       db2_client_info(3).

PHP Documentation Group 													DB2_SERVER_INFO(3)
All times are GMT -4. The time now is 02:43 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy