05-18-2007
thanks but this gives the same result: A file with this format:
xactname
-------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
----------------
000007D6_dj0TcjcQnPgOc30PdPAPe5YTdjgRdjdvd34Ve38VdPsTnQ5ll4ZvnRZv00000000000000
0000000000000000_dPkQdjkPnPgNejwOejsTe5ZvnRY000000000000000000000000000
00000000000000000000000000000000
000007D6_dj0TcjcQnPgOc30PdPAPe5YVdj8NcPhvd34Ve38VdPwOnQ5ll4ZvnRZv00000000000000
0000000000000000_ejkOcjcQnPgNejwOejsUcRZvnRY000000000000000000000000000
00000000000000000000000000000000
these are 2 rows and I want to use them in this command:
dbcc complete_xact("$TRAN_NAME","rollback")
the TRAN_NAME is each of the values grepped in the file. To put these grepped values, I need an array or a list.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi :)
i need help to explain arrays 2D in c shell
like this in c++
int a (6 Replies)
Discussion started by: hgphsf
6 Replies
2. Shell Programming and Scripting
I have a bash shell script that sources a data file, the data file has array values such as:
#--data file ---#
sg_name="db1"
sg_size="12892"
sg_allow="50000"
sg_name="db2"
sg_size="12892"
sg_allow="50000"
export sg_name sg_size sg_allow
#--end data file --#
In my shell script... (8 Replies)
Discussion started by: lochraven
8 Replies
3. Shell Programming and Scripting
how do you declare an array in the C shell and loop through each element? (2 Replies)
Discussion started by: npatwardhan
2 Replies
4. Shell Programming and Scripting
Hi guys
could you please post links that explain how to use and manipulate arrays in c shell (.csh files) ? examples are useful too :rolleyes: (5 Replies)
Discussion started by: domain
5 Replies
5. Shell Programming and Scripting
hi guys,
i have the following code in C shell..
set i=0
while ($i < 11)
master_array=${ARRAY}
i++
done
it gives me error at line 3: Variable syntax.
what is wrong here? any help is appreciated. (4 Replies)
Discussion started by: npatwardhan
4 Replies
6. Shell Programming and Scripting
I have three arrays. One is Master array and that has list of other array in config file.
for e.g (for simplicity I have only defined array with 2 elements each)
set +A MASTERARRAY SQLUPDATE_ONETIME SQLUPDATE_DAILY END_OF_ARRAY
set +A SQLUPDATE_ONETIME update12 update22 END_OF_ARRAY... (4 Replies)
Discussion started by: anish
4 Replies
7. Shell Programming and Scripting
I have 2 arrays abc and xyz
abc = ( a b c d e f g h i j k l m n o p q r s t u v w x y z )
and
xyz = ( b c d e f )
lets assume a .... z are the file name.
I have to perform a pattern replacement on each file present in abc array accept the files i have in xyz array. and i am doing... (4 Replies)
Discussion started by: kukretiabhi13
4 Replies
8. Shell Programming and Scripting
Ok so spaces separate elements. What if you wanted an element to have a space in it?
For instance:
nums="one two three and a half"
where "three and a half" is THE SAME element? (3 Replies)
Discussion started by: stevenswj
3 Replies
9. Shell Programming and Scripting
Hi,
I need help in creating a array in shell scirpt.
I have a file which has following details.
hostname devices
device1
device 2
de
abcdmhs10 1234
2343
2353
3343
3435
2343
bcdfmhs11 2343
2443
3434
8874
0343
3434 (5 Replies)
Discussion started by: jpkumar10
5 Replies
10. UNIX for Beginners Questions & Answers
I have
FILE 1 (This file has all master columns/headers)
A|B|C|D|E|F|G|H|STATUS
FILE 2
A|C|F|I|OFF_STATUS
3|4|5|4|Y
6|7|8|5|Y
Below command give me all headers of FILE 2 into array2.txt file
paste <(head -1 FILE2.txt | tr '|' '\n')>array2.txt
So I would like to compare... (2 Replies)
Discussion started by: jmadhams
2 Replies
LEARN ABOUT DEBIAN
dbix::simple::comparison
DBIx::Simple::Comparison(3pm) User Contributed Perl Documentation DBIx::Simple::Comparison(3pm)
NAME
DBIx::Simple::Comparison - DBIx::Simple in DBI jargon
DESCRIPTION
This is just a simple and inaccurate overview of what DBI things the DBIx::Simple things represent, or the other way around.
This document can be useful to find the foo equivalent of bar.
"?" means that DBI doesn't have an equivalent or that I couldn't find one.
"=" means that DBIx::Simple provides a direct wrapper to the DBI function.
"~" means that DBIx::Simple's method does more or less the same, but usually in a more high level way: context sensitive, combining things,
automatically taking care of something.
Note that DBIx::Simple is a wrapper around DBI. It is not "better" than DBI. In fact, DBIx::Simple cannot work without DBI.
Using DBI directly is always faster than using DBIx::Simple's equivalents. (For the computer, that is. For you, DBIx::Simple is supposed to
be faster.)
Classes, common names
use DBI ~ use DBIx::Simple
$DBI::errstr = DBIx::Simple->error
DBI::db ~ DBIx::Simple
$dbh ~ $db
$dbh->errstr = $db->error
connect ~ connect
connect ~ new
DBI::st ~ DBIx::Simple::Result
<undef> ~ DBIx::Simple::Dummy
$sth ~ $result
Queries
DBI
my $sth = $dbh->prepare_cached($query);
$sth->execute(@values);
~ DBIx::Simple
my $result = $db->query($query, $values);
Results
DBI DBIx::Simple
bind_columns ~ bind
fetchrow_arrayref/fetch = fetch
fetchrow_array ~ list
*1 ~ flat
[@{fetchrow_arrayref}] = array
fetchall_arrayref ~ arrays
fetchrow_hashref() *2*3 = hash
fetchall_arrayref({}) *4 ~ hashes
fetchall_hashref *2 = map_hashes
? ? map_arrays
fetchall_hashref(1) *2 = map
$sth->{NAME_lc/NAME} = $result->columns
*1 There's no fetch variant, but you can do "{ @{ $dbh->selectcol_arrayref('SELECT ...', { Slice => [] }) } }".
*2 To receive the keys (column names) lowercased, use "$db->{FetchHashKeyName} = 'NAME_lc'". DBIx::Simple lower cases them by default.
*3 Or supply an argument, 'NAME_lc'.
*4 No, arrayref isn't a typo. When supplied an empty hash reference, DBI's fetchall_arrayref actually returns hashrefs. This DBI method
does not support lower casing of keys, DBIx::Simple does.
Direct access
DBI DBIx::Simple
$dbh = $db->dbh
$sth->{$foo} = $result->attr($foo)
func = func
begin_work = begin_work
commit = commit
rollback = rollback
last_insert_id = last_insert_id
rows = rows
disconnect ~ disconnect
finish ~ finish
DBIx::Simple specific (?)
keep_statements
lc_columns
iquery (via SQL::Interp)
select, insert, update, delete (via SQL::Abstract)
abstract (via SQL::Abstract)
flat
hashes
map_arrays
map
LICENSE
There is no license. This software was released into the public domain. Do with it what you want, but on your own risk. The author
disclaims any responsibility.
AUTHOR
Juerd Waalboer <juerd@cpan.org> <http://juerd.nl/>
SEE ALSO
DBI, DBIx::Simple
perl v5.10.0 2007-07-14 DBIx::Simple::Comparison(3pm)