02-02-2009
radoulov,
The paste command simply joins the two columns together. I dont see how it can help with the query I have. Secondly, no this is not a homework assignment. I am post doctoral researcher in genetics who is new to programming and in early learning stages.
Cheers.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I want to write bash script that will keep on looking for files in a directory and if any file exists, it processes them. I want it to be a background process, which keeps looking for files in a directory.
Is there any way to do that in bash script?
I can loop through all the files like... (4 Replies)
Discussion started by: rladda
4 Replies
2. UNIX for Dummies Questions & Answers
Hi,
I'm trying loop through all files in a directory that have a filename starting with 'CC', and process them one by one. Can any provide an example of how I could do this. I've started with:
if test -f CC*
then
#add files to an array
#loop through array and process the file based on... (1 Reply)
Discussion started by: kshelluser
1 Replies
3. Shell Programming and Scripting
hi
i have two files
cat input.txt
123456| 43256
456482|5893242
cat data.txt
xv 123456 abcd dsk
sd 123456 afsfn dd
df 43256 asdf ff
ss 456482 aa
sf 5893242 ff ff
aa 5893242 aa aa
i need to read inputs from input.txt and find data for data.txt.
then i need to print them as a... (2 Replies)
Discussion started by: windows
2 Replies
4. Shell Programming and Scripting
I have a script to GREP for a text expression within certain files, the files being named file.11012008 thru file.11302008. 30 files in all, one for each day of the month.
Instead of entering the following 3 lines of code 30 different times, I'm trying to find a way to loop the process:
... (6 Replies)
Discussion started by: foleyml
6 Replies
5. Shell Programming and Scripting
hi all
i have some files present in a directory
i want to loop through all the files in the directory
each time i loop
i should change the in_file parameter in the control file and load it into a table using sql loader
there is only one table where i have to load alll the files ... (3 Replies)
Discussion started by: rajesh_tns
3 Replies
6. Shell Programming and Scripting
Hi,
I need to write a script that copies all .zip files in the subdirectories of ~100 folders. No clue how to write a loop that goes into each folder, searches for a .zip file, and copies it and extracts it to a unique location.
I imagine something like
cp -f /home/folder1/*.zip... (6 Replies)
Discussion started by: nez
6 Replies
7. Linux
Hi,
i need to write a shell script where i have to loop through all the file in a directory and rename them based on below condition.
file1.dat
file2.dat
file3.dat
the above files has to be moved to another directory like below
file1_201001.dat
file2_201002.dat
file3_201003.dat... (3 Replies)
Discussion started by: feroz
3 Replies
8. Shell Programming and Scripting
Hi,
I have a small query when comparing two files with awk. I have a small piece of code running in a shell. See below:
gawk -F"," 'NR == FNR { A=1; next } \!A' OFS="," 2011.csv 2012.csv > diff_2012.csv
The code works fine (Note I had to escape the ! with \! to run in shell). What I want... (6 Replies)
Discussion started by: theflamingmoe
6 Replies
9. UNIX for Dummies Questions & Answers
Hi, I have a large number of files which are numbered numerically, i.e. of the type
1.usr, 2.usr, 3.usr ... This is what I'd like to do:
1. In ascending order, use awk to read a value from each file.
2. Write this value to another file (say data.txt). This file, 'data.txt' should be... (4 Replies)
Discussion started by: lost.identity
4 Replies
LEARN ABOUT DEBIAN
dbix::class::sqlmaker::oraclejoins
DBIx::Class::SQLMaker::OracleJoins(3pm) User Contributed Perl Documentation DBIx::Class::SQLMaker::OracleJoins(3pm)
NAME
DBIx::Class::SQLMaker::OracleJoins - Pre-ANSI Joins-via-Where-Clause Syntax
PURPOSE
This module is used with Oracle < 9.0 due to lack of support for standard ANSI join syntax.
SYNOPSIS
Not intended for use directly; used as the sql_maker_class for schemas and components.
DESCRIPTION
Implements pre-ANSI joins specified in the where clause. Instead of:
SELECT x FROM y JOIN z ON y.id = z.id
It will write:
SELECT x FROM y, z WHERE y.id = z.id
It should properly support left joins, and right joins. Full outer joins are not possible due to the fact that Oracle requires the entire
query be written to union the results of a left and right join, and by the time this module is called to create the where query and table
definition part of the sql query, it's already too late.
METHODS
select
Overrides DBIx::Class::SQLMaker's select() method, which calls _oracle_joins() to modify the column and table list before calling
next::method().
BUGS
Does not support full outer joins (however neither really does DBIC itself)
SEE ALSO
DBIx::Class::Storage::DBI::Oracle::WhereJoins - Storage class using this
DBIx::Class::SQLMaker - Parent module
DBIx::Class - Duh
AUTHOR
Justin Wheeler "<jwheeler@datademons.com>"
CONTRIBUTORS
David Jack Olrik "<djo@cpan.org>"
LICENSE
This module is licensed under the same terms as Perl itself.
perl v5.14.2 2011-11-29 DBIx::Class::SQLMaker::OracleJoins(3pm)