I have req in which i need to run the query stored in some file and then store the resultset of the query in some other file.
PFB the code i have written:
Now i am able to genrate the file with required resultset...the only prob is.i am getting data in below format:
My actual data is (in oracle)
Note:i used symbol "|" jus to differentiate my data.
and my expected data should be:
Please give ur inputs frndz..need it urgently>
TIA
Last edited by Scott; 08-30-2013 at 10:28 AM..
Reason: Code tags
Forgive the daft requests - I'm still a learner :D
I need a script so that I can test another script (I'm confused already) The script I am looking for should generate a new file in the same directory (called newfile1 or what ever) and also generate text within the new file (Hello world? What... (1 Reply)
I am trying to find for the pattern in first 5 bytes of every line in a text file and then generate a new file with the pattern found.
Example: expected pattern is '-' to be serached in first 5 bytes of file only.
Input File
ab-cd jan-09
ddddd jan09
cc-ww jan09
dsgdq jan-09
... (2 Replies)
Hi,
Our requirement is we have to create file from one file where all the rows from source file is converted into columns of the target file.
For example
Source file is :
Status Report ABC
Generated: 2009-05-05 08:49:47
Job start time=2009-05-05 08:43:43
Job end time=2009-05-05... (1 Reply)
Hello Gurus,
We are facing some performance issue in UNIX. If someone had faced such kind of issue in past please provide your suggestions on this .
Problem Definition:
/Few of load processes of our Finance Application are facing issue in UNIX when they uses a shell script having below... (19 Replies)
Hi Gurus,
I have a requirement as below
I have text file a.txt which contains
hi hello
process update
status
Output for file Ok to Proceed no issues good
data arrangement
My requirement here is i need to read the file and check for the words
"OK to Proceed" and if it is available... (14 Replies)
HI,
I want to append some configuration statements to the existing file in unix to it's 3 line , 7th line and 28 line.
There is a file generated by our system job, to this I need to add some lines as mentioned below.
DIR=/usr/CDR - line 3
Source=/usr/src - line 7
Target=/usr/tgt - line... (2 Replies)
i am using bash shell
Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127.
IFS=","
declare -a Arr=($Variable1);
SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE}
echo "set head off ; " > ${SQLCMD}
echo "set PAGESIZE 0 ;" >> ${SQLCMD}... (6 Replies)
Hi Guys,
I have a simple request. I have a file in w3c format. Each file has 2 header lines. Rest of the lines are 16 columns each. They are separated by Tab. I need to discard the first 2 lines and then write each column of the txt file into a seperate column of CSV. I tried the command below... (1 Reply)
Hi guys,
I am pulling my hair out here. I have a file that comes in, once it finishes i want to move it to a new location. This sounds all very easy but my solution is failing and moves the file before it has finished generating.
isrun=`ps -ef | grep -i filename | grep -v grep | wc -l`
... (8 Replies)
i have a unix script which generates the csv file. the data in csv file is dynamic. how can i convert/move the data from csv file to xml. please suggest (1 Reply)
Discussion started by: archana25
1 Replies
LEARN ABOUT DEBIAN
dbix::class::resultsetcolumn
DBIx::Class::ResultSetColumn(3pm) User Contributed Perl Documentation DBIx::Class::ResultSetColumn(3pm)NAME
DBIx::Class::ResultSetColumn - helpful methods for messing
with a single column of the resultset
SYNOPSIS
$rs = $schema->resultset('CD')->search({ artist => 'Tool' });
$rs_column = $rs->get_column('year');
$max_year = $rs_column->max; #returns latest year
DESCRIPTION
A convenience class used to perform operations on a specific column of a resultset.
METHODS
new
my $obj = DBIx::Class::ResultSetColumn->new($rs, $column);
Creates a new resultset column object from the resultset and column passed as params. Used internally by "get_column" in
DBIx::Class::ResultSet.
as_query
Arguments: none
Return Value: [ $sql, @bind ]
Returns the SQL query and bind vars associated with the invocant.
This is generally used as the RHS for a subquery.
next
Arguments: none
Return Value: $value
Returns the next value of the column in the resultset (or "undef" if there is none).
Much like "next" in DBIx::Class::ResultSet but just returning the one value.
all
Arguments: none
Return Value: @values
Returns all values of the column in the resultset (or "undef" if there are none).
Much like "all" in DBIx::Class::ResultSet but returns values rather than row objects.
reset
Arguments: none
Return Value: $self
Resets the underlying resultset's cursor, so you can iterate through the elements of the column again.
Much like "reset" in DBIx::Class::ResultSet.
first
Arguments: none
Return Value: $value
Resets the underlying resultset and returns the next value of the column in the resultset (or "undef" if there is none).
Much like "first" in DBIx::Class::ResultSet but just returning the one value.
single
Arguments: none
Return Value: $value
Much like "single" in DBIx::Class::ResultSet fetches one and only one column value using the cursor directly. If additional rows are
present a warning is issued before discarding the cursor.
min
Arguments: none
Return Value: $lowest_value
my $first_year = $year_col->min();
Wrapper for ->func. Returns the lowest value of the column in the resultset (or "undef" if there are none).
min_rs
Arguments: none
Return Value: $resultset
my $rs = $year_col->min_rs();
Wrapper for ->func_rs for function MIN().
max
Arguments: none
Return Value: $highest_value
my $last_year = $year_col->max();
Wrapper for ->func. Returns the highest value of the column in the resultset (or "undef" if there are none).
max_rs
Arguments: none
Return Value: $resultset
my $rs = $year_col->max_rs();
Wrapper for ->func_rs for function MAX().
sum
Arguments: none
Return Value: $sum_of_values
my $total = $prices_col->sum();
Wrapper for ->func. Returns the sum of all the values in the column of the resultset. Use on varchar-like columns at your own risk.
sum_rs
Arguments: none
Return Value: $resultset
my $rs = $year_col->sum_rs();
Wrapper for ->func_rs for function SUM().
func
Arguments: $function
Return Value: $function_return_value
$rs = $schema->resultset("CD")->search({});
$length = $rs->get_column('title')->func('LENGTH');
Runs a query using the function on the column and returns the value. Produces the following SQL:
SELECT LENGTH( title ) FROM cd me
func_rs
Arguments: $function
Return Value: $resultset
Creates the resultset that "func()" uses to run its query.
throw_exception
See "throw_exception" in DBIx::Class::Schema for details.
AUTHORS
Luke Saunders <luke.saunders@gmail.com>
Jess Robinson
LICENSE
You may distribute this code under the same terms as Perl itself.
perl v5.14.2 2011-05-10 DBIx::Class::ResultSetColumn(3pm)