11-20-2012
Multiple Query Results to Variables
Hello,
I am very new to shell scripting and I am not sure of how best to handle the following scenario. I need to query a list of values from a table. I need to store those results and use them to selectively delete values in yet another table in a separate database. I do know how to store the result of one value in a variable; however I am not sure if it is best to store multiple results in an array or to a variable and then parse the variable? Any guidance would be appreciative.
thanks
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi All,
I needed to get the result of two sqlplus queris into shell variables.
After days of looking for the ultimate solution to this problem.. i found this...
sqlplus -s USER/PASS@DB <<EOF | awk '{if(NR==1) printf("%s ", $1); if(NR==2) printf("%s ",
$1);}' | read VAR1 VAR2
set head off... (2 Replies)
Discussion started by: pranavagarwal
2 Replies
2. Shell Programming and Scripting
Hi
I would like to know if there is a way to just have one ORACLE connection established, using which we can execute different queries and store the results under different variables.
For e.g the following uses to two silent ORACLE connection to store the result under two different... (4 Replies)
Discussion started by: ashokjaysiv
4 Replies
3. Shell Programming and Scripting
I want to store the sql query output into a variable
#!/bin/ksh
ORACLE_SID=DB01;
export ORACLE_SID;
export FILE_PATH=/home/asg/Tmp
# Order Checking
echo " removing old files "
rm $FILE_PATH/Malformed_Order.txt
echo " Enter the Malformed Order ....!"
read orders
echo "Regrade... (5 Replies)
Discussion started by: Nareshp
5 Replies
4. UNIX for Dummies Questions & Answers
How can I send the results of a query to a unix variable. I basically want to run a query then do some logic on the results. Trying to redirect the result into a variable I define in the script.
select count(*) as counter from table - nut to redirect the "count" returned from the query... (2 Replies)
Discussion started by: rstone
2 Replies
5. Shell Programming and Scripting
While assisting a forum member, I recommended running SQL/Plus in a coprocess (to make database connections and run a test script) for the duration of his script rather than starting/stopping it once for every row in a file he was processing.
I recalled I made a coprocess example for folks at... (2 Replies)
Discussion started by: gary_w
2 Replies
6. Shell Programming and Scripting
Hi,
I have a script where I make a sqlplus connection. In the script I have multiple sql queries within that sqlplus connection. I want the result of the queries to be stored in shell variables declared earlier. I dont want to use procedures. Is there anyway else.
Thanks in advance..
Cheers (6 Replies)
Discussion started by: gonchusirsa
6 Replies
7. Shell Programming and Scripting
Hi,
I am new to linux...
How to Assign SQL Query Results to Variables in Linux,i want ti generate it in param files, Can anyone please explain me.
Ex: SQL> Select * from EMP;
O/P: Emp_No Emp_Name
1 AAA
2 BBB
3 CCC
and I want expected... (5 Replies)
Discussion started by: Sravana Kumar
5 Replies
8. Shell Programming and Scripting
Hi ,
I am purging two tables based on date.
In my script I am taking the count of the tables purging them and then taking the after counts. I need to mail the before and after counts of the two tables in a mail in table format as mentioned in the result section.
For Eg:
## Count of the... (14 Replies)
Discussion started by: CFA
14 Replies
9. Shell Programming and Scripting
Hi All,
I need to read values of 10 columns from oracle query and assign the same to 10 unix variables. The query will return only one record(row).
I tried to append all these columns using a delimiter(;) in the select query and assign the same to a single variable(V) in unix. I thought I... (3 Replies)
Discussion started by: hkrishnan91
3 Replies
10. Shell Programming and Scripting
Hello,
I'm trying to send email from Greenplum query results as HTML table with status Red/Green
Select Server, Last_Date from Table;
Results
Server, Last_Date
Prod, 2018-04-09
Final email Output in HTML format
Server Status LastDate
Prod GREEN(BOX) 2018-04-09 (if... (2 Replies)
Discussion started by: krux_rap
2 Replies
LEARN ABOUT DEBIAN
globus_rls_client_queryresult
Query Results(3) globus rls client Query Results(3)
NAME
Query Results -
Data Structures
struct globus_rls_attribute_object_t
globus_rls_client_lrc_attr_search() returns a list of these structures which include the object name (LFN or PFN) and attribute value
found by the query.
struct globus_rls_string2_t
String pair result.
struct globus_rls_string2_bulk_t
String pair result with return code, returned by bulk query operations.
Functions
globus_result_t globus_rls_client_free_list (globus_list_t *list)
Detailed Description
List results are returned as globus_list_t's, list datums depend on the type of query (eg globus_rls_string2_t, globus_rls_attribute_t,
etc).
A list result should be freed with globus_rls_client_free_list() when it's no longer needed. RLS supports limiting the number of results
returned by a single query using an offset and reslimit. The offset specifies which result to begin with, reslimit specifies how many
results to return. Offset should begin at 0 to retrieve all records. If reslimit is 0 then all results are returned at once, unless the
server has a limit on results configured. If NULL is passed as the offset argument then the API will repeatedly call the query function
until are results are retrieved. The following are equivalent examples of how to print the lfn,pfn pairs returned by
globus_rls_client_lrc_get_lfn():
globus_list_t *str2_list;
globus_list_t *p;
globus_rls_string2_t *str2;
// Retrieve all results, API will handle looping through partial results
// if the server has a limit configured. Error handling has been omitted.
globus_rls_client_lrc_get_lfn(h, "somepfn", NULL, 0, &str2_list);
for (p = str2_list; p; p = globus_list_rest(p)) {
str2 = (globus_rls_string2_t *) globus_list_first(p);
printf("lfn: %s pfn:%s0, str2->s1, str2->s2);
}
globus_rls_client_free_list(str2_list);
// This code fragment retrieves results 5 at a time. Note offset is set
// to -1 when the server has no more results to return.
int offset = 0;
while (globus_rls_client_lrc_get_lfn(h, "somepfn", &offset, 5, &str2_list) == GLOBUS_SUCCESS) {
for (p = str2_list; p; p = globus_list_rest(p)) {
str2 = (globus_rls_string2_t *) globus_list_first(p);
printf("lfn: %s pfn:%s0, str2->s1, str2->s2);
}
globus_rls_client_free_list(str2_list);
if (offset == -1)
break;
}
.fi
Function Documentation
globus_result_t globus_rls_client_free_list (globus_list_t *list)
Free result list returned by one of the query functions. Parameters:
list List returned by one of the query functions.
Return values:
GLOBUS_SUCCESS List and contents successfully freed.
Author
Generated automatically by Doxygen for globus rls client from the source code.
Version 5.2 Wed Jan 25 2012 Query Results(3)