05-06-2009
Thanks its working 5n for me
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Guys !
I am new to unix and want to find out how we can make sql statement data to shell script variable?
Any help/suggestion is greatly appreciated
-Chandra (1 Reply)
Discussion started by: kattics
1 Replies
2. Shell Programming and Scripting
Hi,
I'm quite new to scripting and I want to modify following line of an existing script:
MYVAR=`subst |grep 'L:\\\:' | sed -e 's/.*\\\//'`;
What I have to do is to use the content of a variable instead of the constant expression 'L:\\\:' as the grep string to be matched.
Assuming I already... (5 Replies)
Discussion started by: snowbiker99
5 Replies
3. Shell Programming and Scripting
#!/bin/sh
#
##
MYSTRING = `awk '/myApp.app/' /Users/$USER/Library/Preferences/loginwindow.plist`
if
then
echo String not found
defaults write /Users/$USER/Library/Preferences/loginwindow AutoLaunchedApplicationDictionary -dict-add -string Hide -bool YES -string Path -string... (9 Replies)
Discussion started by: dedmakar
9 Replies
4. Shell Programming and Scripting
Hi friends,
firstly, i can run following expression and i took 100 value.
sqlplus -s username/password@TTTEST @umt.sql
umt.sql exists "select t.deger from parametre t where t.id=30".
result of this query =100
i need to assign this value(100) to variable(for example x... (2 Replies)
Discussion started by: temhem
2 Replies
5. Shell Programming and Scripting
Dear All,
we have a command output which looks like :
Total 200 queues in 30000 Kbytes
and we're going to get "200" and "30000" for further process. currently, i'm using :
numA=echo $OUTPUT | awk '{print $2}'
numB=echo $OUTPUT | awk '{print $5}'
my question is : can I use just one... (4 Replies)
Discussion started by: tiger2000
4 Replies
6. UNIX for Dummies Questions & Answers
Hi
im trying to assign the result of the db2 command to a variable inside a shell script...
: tab_cnt=`db2 "select count(*) from syscat.tables where tabname = 'ABC' and tabschema = 'MATT01'" |head -4|tail +4|cut -c 11`
: echo $tab_cnt
when i echo im getting a blank value.. im expecting... (1 Reply)
Discussion started by: matt01
1 Replies
7. Shell Programming and Scripting
I have the below script running for generating file from PL/SQL stored procedure. I need to declare a shell variable and then pass this to sqlplus command to pass the same as a INPUT parameter for the stored procedure. Please help to do this.
#!/bin/sh
minlimit=0
maxlimit=10
size=100
while... (0 Replies)
Discussion started by: vel4ever
0 Replies
8. Shell Programming and Scripting
Hello,
Here is the code i have written to get the count of a plsql query back to the unix.
function checkforCOIDs
{
countcheck=`sqlplus -s $1/$2@$3
whenever oserror exit sql.oscode rollback
whenever sqlerror exit sql.sqlcode rollback
set serverout on size 2000;
set head off feedback off... (2 Replies)
Discussion started by: santosh2eee
2 Replies
9. Shell Programming and Scripting
Hi,
I have the following command that lists all the .o files from all the directories except of vwin (which I don't want it)
for i in `ls -d */*.o|awk '$0 !~ "vwin"'`; do echo $i; done
The result is something like that
dir1/file1.o
dir1/file2.o
dir2/file3.o
etc.
So, I want to create a... (9 Replies)
Discussion started by: scor6800
9 Replies
10. UNIX for Beginners Questions & Answers
I have the following script, and I want to assign the output ($10 and $5) from awk to N and L:
grdinfo data.grd | awk '{print $10,$5}'| read N L
output from gridinfo data.grd is: data.grd 50 100 41 82 -2796 6944 0.016 0.016 3001 2461. where N and L is suppose to be 3001 and 100. I use... (8 Replies)
Discussion started by: geomarine
8 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)