Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: SQL query within an awk script !!
Top Forums Shell Programming and Scripting SQL query within an awk script !! Post 302813933 by Yoda on Tuesday 28th of May 2013 11:24:46 AM
Old 05-28-2013
The reason why I didn't recommend your approach is because for each record in your input file you have to establish a connection to DB and fire the query.

Hence this method is going to be really inefficient and time consuming.

So it is really OK and much better approach to create a table and perform the join operation.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Executing Sql Query Using Shell Script

HI ALL i have a requirement like this. i have to write a shell script to run a sql query. DB is oracle. once the query is run, the results of the query has to be published in a data file. can you please advice me how to go about it. i am absolutely new to shell scripts and this is a part of my job. (14 Replies)
Discussion started by: ragha81
14 Replies

2. Shell Programming and Scripting

executing a SQL query in shell script

Hi ALL, I need an help in connecting to oracle database, executing a select query and printing it on the screen. Can any one please write a simple code or psuedo code and let me know. select query returns multiple values( say select name from emp) Thanks in advance LM (1 Reply)
Discussion started by: lijju.mathew
1 Replies

3. Shell Programming and Scripting

script variable within a sql query

I created a script to read a csv file with four columns. The script also saved values of each col in a arry. In the script, i connected to db try to run a query to pull out data baisc on the values from the csv file. select Num from tableName where Sec_Num in ('${isin}') /*isin is an arry... (1 Reply)
Discussion started by: Sherry_Run
1 Replies

4. Shell Programming and Scripting

Script executing sql query

Hello, I have a sh script excuting a sql query through sqlplus. I am having trouble making my date equal to the date of the server time in the sql script. How can i call the server date from my query? Thanks (2 Replies)
Discussion started by: kingluke
2 Replies

5. Shell Programming and Scripting

query sql using shell script

query sql using shell script, is it possible? my friend told me to do a file.sql and link to my shell script, but can i query sql using shell script? thanks in advance! (2 Replies)
Discussion started by: kingpeejay
2 Replies

6. Shell Programming and Scripting

Run SQL thru shell script: how to get a new line when run sql query?

Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database. I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :( What should I do? I'm not sure that... (2 Replies)
Discussion started by: Kapom
2 Replies

7. Red Hat

Sql query through shell script

hey , i am using this code to store value of a sql query and and then use it in other query but after some time , but it is not working. please help #!/bin/bash val_1=$( sqlplus -s rte/rted2@rel76d2 << EOF setting heading off select max(stat_id) from cvt_stats; exit EOF ) nohup... (5 Replies)
Discussion started by: ramsavi
5 Replies

8. UNIX for Dummies Questions & Answers

Script to run sql query.

Please read How To Ask Questions The Smart Way (1 Reply)
Discussion started by: balu_279013
1 Replies

9. Shell Programming and Scripting

Convert the SQL Query in Shell Script

Hi All, I have a query with output below select 'create synonym "'||TABLE_NAME||'" for '||Table_owner||'."'||table_name||'"'||chr(59) from user_synonyms; ================== create synonym "RV_SBC_SIG" for WFCONTROLLER_TE."RV_SBC_SIG"; create synonym "AQM_TASK" for AWQM_TE."AQM_TASK";... (2 Replies)
Discussion started by: pvmanikandan
2 Replies

10. Shell Programming and Scripting

How do I read sql query into shell script?

Hello All, I'm trying to put together a shell script that will: 1. connect to an oracle database 2. execute a query 3. save the output to a csv file I know that I can execute the sqlplus -s user/pass @dbsid and get logged in. What I would like to do is have my query in a separate text... (9 Replies)
Discussion started by: bbbngowc
9 Replies

LEARN ABOUT CENTOS

rdma_resolve_route

RDMA_RESOLVE_ROUTE(3)					   Librdmacm Programmer's Manual				     RDMA_RESOLVE_ROUTE(3)

NAME

       rdma_resolve_route - Resolve the route information needed to establish a connection.

SYNOPSIS

       #include <rdma/rdma_cma.h>

       int rdma_resolve_route (struct rdma_cm_id *id, int timeout_ms);

ARGUMENTS

       id	   RDMA identifier.

       timeout_ms  Time to wait for resolution to complete.

DESCRIPTION

       Resolves  an  RDMA  route  to  the  destination address in order to establish a connection.  The destination address must have already been
       resolved by calling rdma_resolve_addr.

RETURN VALUE

       Returns 0 on success, or -1 on error.  If an error occurs, errno will be set to indicate the failure reason.

NOTES

       This is called on the client side of a connection after calling rdma_resolve_addr, but before calling rdma_connect.

INFINIBAND SPECIFIC

       This call obtains a path record that is used by the connection.

SEE ALSO

       rdma_resolve_addr(3), rdma_connect(3), rdma_get_cm_event(3)

librdmacm							    2007-10-31						     RDMA_RESOLVE_ROUTE(3)
All times are GMT -4. The time now is 10:12 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy