06-05-2009
Quote:
Originally Posted by
depakjan
i have to read some data from a teradata table and use them in my shell script.. how do i do that.. we can use BTEQ .. but i don know how to pass the field values as variables to the shell.. please help me....
Are you selecting single row or multiple row from table??
If you are selecting multiple row and want to do some change in them depending on some condition its better to take data in a flat file
If its only one row you can directly pass the values to variable.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi!
I've just started learning shell scripting, and have been somewhat 'thrown in at the deep-end and told to swim' so excuse my complete lack of knowledge and ignorance, but here goes...
I've been given a unix script to 'tidy up'. Basically the script consists of the few lines of code being... (2 Replies)
Discussion started by: Sn33R
2 Replies
2. Solaris
Hi All,
I need some sort of library or module which read the db table at one go and keep in process memory.My problem is that I have a call processing module which handles the network call and goes for db lookup for subscriber profile in oracle db for every call.I am using Oracle Standard Edition... (0 Replies)
Discussion started by: unisuraj
0 Replies
3. Shell Programming and Scripting
I have korn shell scripts.
I want to pass a variable to a script which will execute a a sql script to read a table that contains env. variables. I want to read and then somehow export at unix level variables
example
for every row selected from the table build export command line
field1... (5 Replies)
Discussion started by: TimHortons
5 Replies
4. Shell Programming and Scripting
Hi
I am new to Unix shell scripting. But i need help to slove the below issue.
Issue description:
I want to read table, view names and package names in a file
my plan to find the table name is : search "From" key word find the table or view
To find the packge name : Search "Package... (5 Replies)
Discussion started by: sboss
5 Replies
5. HP-UX
Hi all,
Could someone please explain to me how I should read this routing table,
# netstat -rn
Routing tables
Destination Gateway Flags Refs Interface Pmtu
127.0.0.1 127.0.0.1 UH 0 lo0 32808
10.222.47.82 10.222.47.82 UH... (3 Replies)
Discussion started by: rachael
3 Replies
6. Shell Programming and Scripting
Dear forum users,
i'm trying to read a table with 40x122 data in a array. Following this, i'd plot each rows again the header of the file in gnuplot.
i was thinking for something like that
#!/bin/bash
# reads from the $ips file and assigns to $MYARRAY
#IFS =";" split the line after the... (6 Replies)
Discussion started by: servuskelb
6 Replies
7. Shell Programming and Scripting
Hey guyz,
I have a table like this:
1 A=#;B=#;C=#
2 A=#;C=#;D=#;E=#;E=#
3 B=#;B=#;B=#;D=#
# are just some numbers. I want to have the output like this:
* 1 2 3
A # # NA
B # NA #
C # # NA
D NA # #
E NA # NA
So basically, I wanna know in each of the rows in my input (which... (9 Replies)
Discussion started by: @man
9 Replies
8. UNIX for Beginners Questions & Answers
Hi there,
I currently use the following find command to recursively search all the subdirectories in our file system for a table ( in this case BB_TENURE_DAYS)
find -type f -exec grep -l "BB_TENURE_DAYS" {} \+
So I have this so far - the problem is how do I read the line to get the... (2 Replies)
Discussion started by: rjsha1
2 Replies
9. UNIX for Beginners Questions & Answers
HELLO
I need your help please , i need to read a file that contain a table like :
Name | Status
------------------
DB 1 | UP
DB 2 | UP
DB 3 | DOWN
DB 4 | UP
DB 5 | UP
the objective to read each line and check if DB is UP or Down and give me the name of Down database.... (10 Replies)
Discussion started by: Abdellah
10 Replies
10. UNIX for Beginners Questions & Answers
HI Team,
I am working on reading hive table and send email in email body using shell script, can you please help on fixing the errors: I have 6 columns in my hive table and trying to send the email in the mail body.
below script:
#!/bin/bash
hive -e 'SELECT count(*) from db.table' >... (4 Replies)
Discussion started by: Mi4304
4 Replies
LEARN ABOUT DEBIAN
anydata::format::csv
AnyData::Format::CSV(3pm) User Contributed Perl Documentation AnyData::Format::CSV(3pm)
NAME
AnyData::Format::CSV - tiedhash & DBI/SQL access to CSV data
SYNOPSIS
use AnyData;
my $table = adTable( 'CSV', $filename,'r',$flags );
while (my $row = each %$table) {
print $row->{name},"
" if $row->{country} =~ /us|mx|ca/;
}
# ... other tied hash operations
OR
use DBI
my $dbh = DBI->connect('dbi:AnyData:');
$dbh->func('table1','CSV', $filename,$flags,'ad_catalog');
my $hits = $dbh->selectall_arrayref( qq{
SELECT name FROM table1 WHERE country = 'us'
});
# ... other DBI/SQL operations
DESCRIPTION
This is a plug-in format parser for the AnyData and DBD::AnyData modules. It will read column names from the first row of the file, or
accept names passed by the user. In addition to column names, the user may set other options as follows:
col_names : a comma separated list of column names
eol : the end of record mark,
by default
quote_char : the character used to quote fields " by default
escape_char : the character used to escape the quote char, " by default
If you are using this with DBD::AnyData, put ad_ in front of the flags, e.g. ad_eol.
Please refer to the documentation for AnyData.pm and DBD::AnyData.pm for further details.
AUTHOR & COPYRIGHT
copyright 2000, Jeff Zucker <jeff@vpservices.com> all rights reserved
perl v5.10.1 2004-08-17 AnyData::Format::CSV(3pm)