09-06-2011
Is there a way to do it inside SQL
I know that AWK can modify the data. However, do you know if there is a way to get it from the original SQL query?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello all.
Sorry, I know this question is similar to many others, but I just can seem to put together exactly what I need.
My file is tab delimitted and contains approximately 1 million rows. I would like to send lines 1,4,& 7 to a file. Lines 2, 5, & 8 to a second file. Lines 3, 6, & 9 to... (11 Replies)
Discussion started by: shankster
11 Replies
2. Shell Programming and Scripting
Hi,
i have a file say file1 having following data
/abc/def:ghi/jkl/ some other text
Now i want to extract only ghi/jkl/using sed, can some one please help me.
Thanks
Sarbjit (2 Replies)
Discussion started by: sarbjit
2 Replies
3. Shell Programming and Scripting
HI,
Need awk command to get date and time alone from
Input : "15:29:15 28.08.2010|SCHEDULE: Started program POSG1"
Output expected : "15:29:15 28.08.2010"
Please help. (9 Replies)
Discussion started by: shanneykar
9 Replies
4. Shell Programming and Scripting
Hi,
I have 2 files.
a.txt & b.txt
# a.txt contains the following text.
apple
grapes
# b.txt contains the following text.
banana
pine
My question is. (1 Reply)
Discussion started by: vanitham
1 Replies
5. Shell Programming and Scripting
Hi All
I have one query,say i have a requirement like the below code should be
move to diffent files whose maximum lines can be of 10 lines.Say in the below example,it consist of 14 lines.
This should be moved logically using the data in the fisrt coloumn to file1 and file 2.The data of first... (2 Replies)
Discussion started by: sarav.shan
2 Replies
6. Shell Programming and Scripting
Hello,
Working on a ksh script and a little stumped... how can I return all characters to the left of the last delimeter per line in a file, skipping any lines without that delimeter?
ie, sample.txt:
Once_upon-a-Midnight_dreary_while
I pondered, weak_and weary
over many a quaint
and... (4 Replies)
Discussion started by: MoreCowbell
4 Replies
7. Shell Programming and Scripting
Hi Friends,
I have a file as below
source.txt
12345JackYKing32N
1235 JulyYoig 31N
i am using cut command for cutting the fields
cut -c 1-5 source.txt
12345
1235
like above i have to use each time to cut all the fieds manually. I have a file(pre.txt) which tells... (3 Replies)
Discussion started by: i150371485
3 Replies
8. Shell Programming and Scripting
I have a below file.
INPUT FILE
select * from customer
MERGE INTO Archive; delete from Employee; using select * from customer;
delete from employee; select * from Employee;
insert into employee(1,1);
OUTPUT FILE
select * from customer
MERGE INTO Archive
delete from Employee
using... (5 Replies)
Discussion started by: Mohin Jain
5 Replies
9. Shell Programming and Scripting
Hi
i have requirement like below
M <form_name> sdasadasdMklkM
D ......
D .....
M form_name> sdasadasdMklkM
D ......
D .....
D ......
D .....
M form_name> sdasadasdMklkM
D ......
M form_name> sdasadasdMklkM
i want split file based on line number by finding... (10 Replies)
Discussion started by: bhaskar v
10 Replies
10. Shell Programming and Scripting
Hi,
I need help to split any lines that contain ; or ,
input.txtAc020 Not a good chemical process
AC030 many has failed, 3 still maintained
AC040 Putative; epithelial cells
AC050 Predicted binding activity
AC060 rodC Putative; upregulated in 48;h biofilm vs planktonic
The output... (8 Replies)
Discussion started by: redse171
8 Replies
LEARN ABOUT DEBIAN
class::dbi::query
Class::DBI::Query(3pm) User Contributed Perl Documentation Class::DBI::Query(3pm)
NAME
Class::DBI::Query - Deprecated SQL manager for Class::DBI
SYNOPSIS
my $sth = Class::DBI::Query
->new({
owner => $class,
sqlname => $type,
essential => @columns,
where_columns => @where_cols,
})
->run($val);
DESCRIPTION
This abstracts away many of the details of the Class::DBI underlying SQL mechanism. For the most part you probably don't want to be
interfacing directly with this.
The underlying mechanisms are not yet stable, and are subject to change at any time.
OPTIONS
A Query can have many options set before executing. Most can either be passed as an option to new(), or set later if you are building the
query up dynamically:
owner
The Class::DBI subclass that 'owns' this query. In the vast majority of cases a query will return objects - the owner is the class of which
instances will be returned.
sqlname
This should be the name of a query set up using set_sql.
where_clause
This is the raw SQL that will substituted into the 'WHERE %s' in your query. If you have multiple %s's in your query then you should supply
a listref of where_clauses. This SQL can include placeholders, which will be used when you call run().
essential
When retrieving rows from the database that match the WHERE clause of the query, these are the columns that we fetch back and pre-load the
resulting objects with. By default this is the Essential column group of the owner class.
METHODS
where()
$query->where($match, @columns);
This will extend your 'WHERE' clause by adding a 'AND $column = ?' (or whatever $match is, isntead of "=") for each column passed. If you
have multiple WHERE clauses this will extend the last one.
perl v5.12.4 2004-04-25 Class::DBI::Query(3pm)