08-21-2008
help with sed
hi all,
i have a file this way
SET CURRENT SCHEMA = "udb ";
create view udb.empid_STANDBY as select * from udb.empid_200612
where transaction_date = '2006-12-01' UNION ALL select * from udb.empid_200701
where transaction_date = '2007-01-01' UNION ALL select * from udb.empid_200702
where transaction_date = '2007-02-01' UNION ALL select * from udb.empid_200704
where transaction_date = '2007-04-01' UNION ALL select * from udb.empid_200709
where transaction_date = '2007-09-01' UNION ALL select * from udb.empid_200710
where transaction_date = '2007-10-01' UNION ALL select * from udb.empid_200712
where transaction_date = '2007-12-01';
SET CURRENT SCHEMA = "udb ";
create view udb.emp_name_STANDBY as select * from udb.emp_name_200612
where transaction_date = '2006-12-01' UNION ALL select * from udb.emp_name_200701
where transaction_date = '2007-01-01' UNION ALL select * from udb.emp_name_200702
where transaction_date = '2007-02-01' UNION ALL select * from udb.emp_name_200704
where transaction_date = '2007-04-01' UNION ALL select * from udb.emp_name_200709
where transaction_date = '2007-09-01' UNION ALL select * from udb.emp_name_200710
where transaction_date = '2007-10-01' UNION ALL select * from udb.emp_name_200712
where transaction_date = '2007-12-01';
here i need the output in the following way in which the added lines should be added
in new lines(in next line so that there is uniformity in the script) similar to the structure above. i dont mind even if i have a space instead of empid,emp_name
i am trying with sed like this sed "s/01';/01' UNION ALL select * from udb.200801 \n where transaction_date = '2008-01-01' UNION ALL select * from udb.200804 \n where transaction_date = '2008-04-01';/g"
but this is not working
SET CURRENT SCHEMA = "udb ";
create view udb.empid_STANDBY as select * from udb.empid_200612
where transaction_date = '2006-12-01' UNION ALL select * from udb.empid_200701
where transaction_date = '2007-01-01' UNION ALL select * from udb.empid_200702
where transaction_date = '2007-02-01' UNION ALL select * from udb.empid_200704
where transaction_date = '2007-04-01' UNION ALL select * from udb.empid_200709
where transaction_date = '2007-09-01' UNION ALL select * from udb.empid_200710
where transaction_date = '2007-10-01' UNION ALL select * from udb.empid_200712
where transaction_date = '2007-12-01' UNION ALL select * from udb.empid_200801
where transaction_date = '2008-01-01' UNION ALL select * from udb.empid_200804
where transaction_date = '2008-04-01';
SET CURRENT SCHEMA = "udb ";
create view udb.emp_name_STANDBY as select * from udb.emp_name_200612
where transaction_date = '2006-12-01' UNION ALL select * from udb.emp_name_200701
where transaction_date = '2007-01-01' UNION ALL select * from udb.emp_name_200702
where transaction_date = '2007-02-01' UNION ALL select * from udb.emp_name_200704
where transaction_date = '2007-04-01' UNION ALL select * from udb.emp_name_200709
where transaction_date = '2007-09-01' UNION ALL select * from udb.emp_name_200710
where transaction_date = '2007-10-01' UNION ALL select * from udb.emp_name_200712
where transaction_date = '2007-12-01' UNION ALL select * from udb.emp_name_200801
where transaction_date = '2008-01-01' UNION ALL select * from udb.emp_name_200804
where transaction_date = '2008-04-01';
this is in UNIX KORN SHELL
any help is appreciated.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Write a sed script to extract the year, rank, and stock for the most recent 10 years available in the file top10_mktval.csv, and output in the following format:
------------------------------
YEAR |RANK| STOCK
------------------------------
2007 | 1 | Exxon... (1 Reply)
Discussion started by: beibeiatNY
1 Replies
2. Shell Programming and Scripting
Execution of the following segment is giving the error -
Script extract:-
OUT=$DATADIR/sol_rsult_orphn.bcp
TMP1=${OUT}_tmp1
TMP=${OUT}_tmp
( isql -w 400 $dbConnect_OPR <<EOF
select convert(char(10), s.lead_id)
+'|'
+ s.pho_loc_type,
";",
s.sol_rsult_cmnt,
";",
+'|'+ s.del_ind... (3 Replies)
Discussion started by: kzmatam
3 Replies
3. Shell Programming and Scripting
Hello and thx for reading this
I'm using sed to remove only the leading spaces in a file
bash-280R# cat foofile
some text
some text
some text
some text
some text
bash-280R#
bash-280R# sed 's/^ *//' foofile > foofile.use
bash-280R# cat foofile.use
some text
some text
some text... (6 Replies)
Discussion started by: laser
6 Replies
4. Shell Programming and Scripting
i made a script to update a lot of xml files. to save me some time. Ran it and it replaced all the the files with a 0kb file. The problem i was having is that I am using sed to change xml node <doc_root>. The problem with this is it has a / in the closing xml tag and the stuff inside will also have... (4 Replies)
Discussion started by: timgolding
4 Replies
5. Shell Programming and Scripting
Hi all,
First off, Thank you all for the knowledge I have gleaned from this site!
Deleting Records from a text file... sed paragraphs
The following code works nearly perfect, however each time it is run on the log file it adds a newline at the head of the file, run it 5 times, it'll have 5... (1 Reply)
Discussion started by: Festus Hagen
1 Replies
6. UNIX for Dummies Questions & Answers
I'm not sure if the problem I'm seeing is an artifact of sed or simply a beginner's mistake. Here's the problem: I want to add a zero-width space following each underscore between XML tags. For example, if I had the following xml:
<MY_BIG_TAG>This_is_a_test</MY_BIG_TAG>
It should look like... (8 Replies)
Discussion started by: rhetoric101
8 Replies
7. Shell Programming and Scripting
How do i replace a string using sed into the same file without creating a intermediate file? (7 Replies)
Discussion started by: gomes1333
7 Replies
8. Shell Programming and Scripting
My need is :
Want to change
docBase="/something/something/something"
to
docBase="/only/this/path/for/all/files"
I have some (about 250 files)xml files.
In FileOne it contains
<Context path="/PPP" displayName="PPP" docBase="/home/me/documents" reloadable="true" crossContext="true">... (1 Reply)
Discussion started by: linuxadmin
1 Replies
9. Shell Programming and Scripting
Hi,
I am running a script sample.sh in bash environment .In the script i am using sed and awk commands which when executed individually from terminal they are getting executed normally but when i give these sed and awk commands in the script it is giving the below errors :-
./sample.sh: line... (12 Replies)
Discussion started by: satishmallidi
12 Replies
10. Shell Programming and Scripting
I am learning SED and just following the shell scripting book, i have trouble understanding the grep and sed statement,
Question : 1
__________
/opt/oracle/work/antony>cat teledir.txt
jai sharma 25853670
chanchal singhvi 9831545629
anil aggarwal 9830263298
shyam saksena 23217847
lalit... (7 Replies)
Discussion started by: Antony Ankrose
7 Replies
LEARN ABOUT SUSE
drop_schema
DROP
SCHEMA(7) SQL Commands DROP SCHEMA(7)
NAME
DROP SCHEMA - remove a schema
SYNOPSIS
DROP SCHEMA [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
DESCRIPTION
DROP SCHEMA removes schemas from the database.
A schema can only be dropped by its owner or a superuser. Note that the owner can drop the schema (and thereby all contained objects) even
if he does not own some of the objects within the schema.
PARAMETERS
IF EXISTS
Do not throw an error if the schema does not exist. A notice is issued in this case.
name The name of a schema.
CASCADE
Automatically drop objects (tables, functions, etc.) that are contained in the schema.
RESTRICT
Refuse to drop the schema if it contains any objects. This is the default.
EXAMPLES
To remove schema mystuff from the database, along with everything it contains:
DROP SCHEMA mystuff CASCADE;
COMPATIBILITY
DROP SCHEMA is fully conforming with the SQL standard, except that the standard only allows one schema to be dropped per command, and apart
from the IF EXISTS option, which is a PostgreSQL extension.
SEE ALSO
ALTER SCHEMA [alter_schema(7)], CREATE SCHEMA [create_schema(7)]
SQL - Language Statements 2010-05-14 DROP SCHEMA(7)