11-11-2009
Grep multiple line pattern and output the lines
Hi I have the following Input
--
-- TABLE: BUSINESS_UNIT
--
ALTER TABLE RATINGS.BUSINESS_UNIT ADD CONSTRAINT FK1_BUSINESS_UNIT
FOREIGN KEY (PEOPLESOFT_CHART_FIELD_VALUE_ID)
REFERENCES RATINGS.PEOPLESOFT_CHART_FIELD_VALUE(PEOPLESOFT_CHART_FIELD_VALUE_ID)
;
ALTER TABLE RATINGS.CASE ADD CONSTRAINT FK7_CASE
FOREIGN KEY (ENTITY_ID, VERSION_NBR)
REFERENCES RATINGS.ENTITY_VERSION(ENTITY_ID, VERSION_NBR)
;
ALTER TABLE RATINGS.CANADIAN_PROVINCE ADD CONSTRAINT FK1_CANADIAN_PROVINCE
FOREIGN KEY (ENTITY_ID, VERSION_NBR)
REFERENCES RATINGS.ENTITY_VERSION(ENTITY_ID, VERSION_NBR)
;
--
-- TABLE: CANADIAN_TERRITORY
--
ALTER TABLE RATINGS.CANADIAN_TERRITORY ADD CONSTRAINT FK1_CANADIAN_TERRITORY
FOREIGN KEY (ENTITY_ID, VERSION_NBR)
REFERENCES RATINGS.ENTITY_VERSION(ENTITY_ID, VERSION_NBR)
;
I need to get ouput of alter staments where in it
REFERENCES RATINGS.ENTITY_VERSION
Output looks like
ALTER TABLE RATINGS.CANADIAN_TERRITORY ADD CONSTRAINT FK1_CANADIAN_TERRITORY
FOREIGN KEY (ENTITY_ID, VERSION_NBR)
REFERENCES RATINGS.ENTITY_VERSION(ENTITY_ID, VERSION_NBR)
;
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
I've been working on a script which I have hit a road block now. I have written a script using sed to extract the below data and pumped into another file:
Severity............: MAJORWARNING
Summary:
System temperature is out of normal range.
Severity............: MAJORWARNING... (13 Replies)
Discussion started by: phixsius
13 Replies
2. Shell Programming and Scripting
Hi all,
For a intro UNIX course I'm taking, I need to use the command "tr" to display a file on standard output without any newlines (all on one line).
I assume I would start with "cat filename | tr" but don't know what to put after tr.
Any ideas would be lovely!
Thanks. (3 Replies)
Discussion started by: otes4
3 Replies
3. Solaris
Hi,
I would like to search multiple patterns on same line, i.e. all patterns must
present on same line.
Please suggest.
Thanx (2 Replies)
Discussion started by: sanjay1979
2 Replies
4. Shell Programming and Scripting
I have sql file containing lot of queries on different database table. I have to filter specific table queries.
Let say i need all queries of test1,test2,test3 along with four lines above it and sql queries can be multi lines or in single line.
Input file contains.
set INSERT_ID=1;
set... (1 Reply)
Discussion started by: mirfan
1 Replies
5. Shell Programming and Scripting
Hi,
I have got the below requirement. please suggest.
I have a file like,
Processing Item is:
/data/ing/cfg2/abc.txt
/data/ing/cfg3/bgc.txt
Processing Item is:
/data/cmd/for2/ght.txt
/data/kernal/config.klgt.txt
I want to process the above file to get the output file like,
... (5 Replies)
Discussion started by: rbalaj16
5 Replies
6. Shell Programming and Scripting
here is what i want to achieve.. i have a file with below contents
cat fileName
blah blah blah
.
.DROP this
REJECT that
.
--sport 7800 -j REJECT --reject-with icmp-port-unreachable
--dport 7800 -j REJECT --reject-with icmp-port-unreachable
.
.
.
more blah blah blah
--dport 3306... (14 Replies)
Discussion started by: vivek d r
14 Replies
7. Shell Programming and Scripting
I need to match two patterns in a log file and need to get the next line of the one of the pattern (out of two patterns) that is matched,
finally need to print these three values in a single line.
Sample Log:
2013/06/11 14:29:04 <0999> (725102) Processing batch 02_1231324
2013/06/11... (4 Replies)
Discussion started by: rpm120
4 Replies
8. Shell Programming and Scripting
Hello Experts , require help . See below output:
File inputs
------------------------------------------
Server Host = mike
id rl images allocated last updated density
vimages expiration last read <------- STATUS ------->... (4 Replies)
Discussion started by: tigerhills
4 Replies
9. Shell Programming and Scripting
Hi Guys,
I am trying to format my csv file. When I spool the file using sqlplus the single row output is wrapped on three lines.
Somehow I managed to format that file and finally i am trying to make the multiple line on single line.
The below command is working fine but I need to pass the... (3 Replies)
Discussion started by: RJSKR28
3 Replies
10. UNIX for Beginners Questions & Answers
Input file:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18 (6 Replies)
Discussion started by: Sagar Singh
6 Replies
LEARN ABOUT CENTOS
alter_foreign_data_wrapper
ALTER FOREIGN DATA
WRAPPER(7) PostgreSQL 9.2.7 Documentation ALTER FOREIGN DATA WRAPPER(7)
NAME
ALTER_FOREIGN_DATA_WRAPPER - change the definition of a foreign-data wrapper
SYNOPSIS
ALTER FOREIGN DATA WRAPPER name
[ HANDLER handler_function | NO HANDLER ]
[ VALIDATOR validator_function | NO VALIDATOR ]
[ OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ]) ]
ALTER FOREIGN DATA WRAPPER name OWNER TO new_owner
ALTER FOREIGN DATA WRAPPER name RENAME TO new_name
DESCRIPTION
ALTER FOREIGN DATA WRAPPER changes the definition of a foreign-data wrapper. The first form of the command changes the support functions or
the generic options of the foreign-data wrapper (at least one clause is required). The second form changes the owner of the foreign-data
wrapper.
Only superusers can alter foreign-data wrappers. Additionally, only superusers can own foreign-data wrappers.
PARAMETERS
name
The name of an existing foreign-data wrapper.
HANDLER handler_function
Specifies a new handler function for the foreign-data wrapper.
NO HANDLER
This is used to specify that the foreign-data wrapper should no longer have a handler function.
Note that foreign tables that use a foreign-data wrapper with no handler cannot be accessed.
VALIDATOR validator_function
Specifies a new validator function for the foreign-data wrapper.
Note that it is possible that after changing the validator the options to the foreign-data wrapper, servers, and user mappings have
become invalid. It is up to the user to make sure that these options are correct before using the foreign-data wrapper.
NO VALIDATOR
This is used to specify that the foreign-data wrapper should no longer have a validator function.
OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ] )
Change options for the foreign-data wrapper. ADD, SET, and DROP specify the action to be performed. ADD is assumed if no operation is
explicitly specified. Option names must be unique; names and values are also validated using the foreign data wrapper's validator
function, if any.
new_owner
The user name of the new owner of the foreign-data wrapper.
new_name
The new name for the foreign-data wrapper.
EXAMPLES
Change a foreign-data wrapper dbi, add option foo, drop bar:
ALTER FOREIGN DATA WRAPPER dbi OPTIONS (ADD foo '1', DROP 'bar');
Change the foreign-data wrapper dbi validator to bob.myvalidator:
ALTER FOREIGN DATA WRAPPER dbi VALIDATOR bob.myvalidator;
COMPATIBILITY
ALTER FOREIGN DATA WRAPPER conforms to ISO/IEC 9075-9 (SQL/MED), except that the HANDLER, VALIDATOR, OWNER TO, and RENAME clauses are
extensions.
SEE ALSO
CREATE FOREIGN DATA WRAPPER (CREATE_FOREIGN_DATA_WRAPPER(7)), DROP FOREIGN DATA WRAPPER (DROP_FOREIGN_DATA_WRAPPER(7))
PostgreSQL 9.2.7 2014-02-17 ALTER FOREIGN DATA WRAPPER(7)