10-06-2010
There are SQL tools that will use a flat file as a db table, like JDBC HXTT under jisql, so you can just query it.
9 More Discussions You Might Find Interesting
1. AIX
USERS="me you jim joe sue"
for user in ${USERS}; do
rmuser -p $user
usrdir=`cat /etc/passwd|grep $user|awk -F":" '{ print $6 }'`
rm -fr `cat /etc/passwd|grep $user|awk -F":" '{ print $6 }'`
echo Deleting: $user '\t' REMOVING: $usrdir
done
This is for AIX ONLY!!! but easily ported to... (0 Replies)
Discussion started by: Optimus_P
0 Replies
2. Shell Programming and Scripting
Hi ,
I have the below source data, I need to clean the data in 2nd,4th,5th columns.
Source Data
RECORD,CASH_TRANS,BEJING,AUG2011/CASH_TRANS,Y/N150/CASH_TRANS,N/201108
RECORD,CASH_TRANS,INDIA,AUG2011/CASH_TRANS,Y/NC110/CASH_TRANS,N/201108... (7 Replies)
Discussion started by: mora
7 Replies
3. Shell Programming and Scripting
HI ,
I am getting the source data as below.
Source Data
CDR_Data,,,,,
F1,F2,F3,F4,F5,F6
5,5,6,7,8,7
6,6,g,,,
7,7,76,,,
8,8,gt,,,
9,9,df ,d,d,d
,,,,, (4 Replies)
Discussion started by: wangkc
4 Replies
4. Shell Programming and Scripting
Hi,
I have a file with multiple rows. each row has 8 columns.
Column 8 has entries separated by commas. I want to exclude all the rows in which column 8 has more than 3 commas.
1234#0/1 - ABC_1234 3 ATGCATGCATGC HHHIIIGIHVF 1 49:T>C,60:T>C,78:C>A,76:G>T,65:T>G
Thanks,
Diya (3 Replies)
Discussion started by: Diya123
3 Replies
5. Shell Programming and Scripting
Hi
I need some help to clean my code used to get city location.
wget -q -O - http://www.ip2location.com/ | grep chkRegionCity | awk 'END { print }' | awk -F"" '{print $4}'
It gives me the city but have a leading space.
I am sure this could all be done by one single AWK
Also if possible... (8 Replies)
Discussion started by: Jotne
8 Replies
6. Shell Programming and Scripting
Experts ,
Below is the data:
--- Physical volumes ---
PV Name /dev/dsk/c1t2d0
VG Name /dev/vg00
PV Status available
Allocatable yes
VGDA 2
Cur LV 8
PE Size (Mbytes) 8
Total PE 4350
Free PE 2036
Allocated PE 2314
Stale PE 0
IO Timeout (Seconds) default
--- Physical volumes ---... (5 Replies)
Discussion started by: rveri
5 Replies
7. Shell Programming and Scripting
I have some small problem with my code.
data.html
<TD class="statuscol2">c</TD>
<TD class="statuscol3">18</TD>
<TD class="statuscol4"><SPAN TITLE="#04">test4</SPAN></TD>
<TD... (4 Replies)
Discussion started by: Jotne
4 Replies
8. Shell Programming and Scripting
Hello,
I work under Windows Vista and I am compiling an open-source stemmer dictionary for English and eventually for other Indian languages. The Engine which I have written has spewed out all lemmatised/expanded forms of the words: Nouns, Adjectives, Adverbs etc. Each set of expanded forms is... (4 Replies)
Discussion started by: gimley
4 Replies
9. Shell Programming and Scripting
Hi!
I have a pretty complex job - at least for me!
i have two csv-files with meassurement-data:
fileA
...... (2 Replies)
Discussion started by: IMPe
2 Replies
LEARN ABOUT DEBIAN
rdf::query::compiler::sql
RDF::Query::Compiler::SQL(3pm) User Contributed Perl Documentation RDF::Query::Compiler::SQL(3pm)
NAME
RDF::Query::Compiler::SQL - Compile a SPARQL query directly to SQL.
VERSION
This document describes RDF::Query::Compiler::SQL version 2.908.
METHODS
"new ( $parse_tree )"
Returns a new compiler object.
"compile ()"
Returns a SQL query string for the specified parse tree.
"emit_select"
Returns a SQL query string representing the query.
"limit_clause"
Returns a SQL LIMIT clause, or an empty string if the query does not need limiting.
"order_by_clause"
Returns a SQL ORDER BY clause, or an empty string if the query does not use ordering.
"variable_columns ( $var )"
Given a variable name, returns the set of column aliases that store the values for the column (values for Literals, URIs, and Blank
Nodes).
"add_variable_values_joins"
Modifies the query by adding LEFT JOINs to the tables in the database that contain the node values (for literals, resources, and blank
nodes).
"patterns2sql ( @triples, $level, %args )"
Builds the SQL query in instance data from the supplied @triples. $level is used as a unique identifier for recursive calls.
%args may contain callback closures for the following keys:
'where_hook'
'from_hook'
When present, these closures are used to add SQL FROM and WHERE clauses to the query instead of adding them directly to the object's
instance data.
"expr2sql ( $expression, $level, %args )"
Returns a SQL expression for the supplied query $expression. $level is used as a unique identifier for recursive calls.
%args may contain callback closures for the following keys:
'where_hook'
'from_hook'
When present, these closures are used to add necessary SQL FROM and WHERE clauses to the query.
"_mysql_hash ( $data )"
Returns a hash value for the supplied $data string. This value is computed using the same algorithm that Redland's mysql storage
backend uses.
"_mysql_node_hash ( $node )"
Returns a hash value (computed by "_mysql_hash" for the supplied $node. The hash value is based on the string value of the node and
the node type.
"qualify_uri ( $uri )"
Returns a fully qualified URI from the supplied $uri. $uri may already be a qualified URI, or a parse tree for a qualified URI or
QName. If $uri is a QName, the namespaces defined in the query parse tree are used to fully qualify.
"add_function ( $uri, $function )"
Associates the custom function $function (a CODE reference) with the specified URI, allowing the function to be called by query
FILTERs.
"get_function ( $uri )"
If $uri is associated with a query function, returns a CODE reference to the function. Otherwise returns "undef".
AUTHOR
Gregory Williams <gwilliams@cpan.org>
perl v5.14.2 2012-01-31 RDF::Query::Compiler::SQL(3pm)