connecting sql from shell Post: 302080622

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Connecting DB in the Shell Script to do SQL Query

Any link or example to write shell script for the Connecting Oracle for Quering through SQL thanks in advance ... Cheers !! Mehul Doshi

2. Shell Programming and Scripting

connecting ....sql

if; sqlplus /nolog <<EOF conn / as sysdba spool /tmp/start.out @/oracle/home/start.sql spool off exit EOF fi For this code i am getting error: Test.sh: syntax error at line 7 : `<<' unmatched

3. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

Hi- I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment... I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert...

4. Shell Programming and Scripting

error connecting sql through a shell script

Hi I am getting this error while connecting to sql through a shell script, whereas i am able to connect to sql directly. It was working properly earlier, no clue why i am getting this. Please find the log below: FTP to <IP> completed Wed Apr 30 11:42:01 BST 2008 Program ended. Wed Apr 30...

5. Shell Programming and Scripting

Connecting to MS SQL database from bash (using unixODBC)

I've installed unixODBC and I would like to connect to a MS SQL (2005) database from a bash script. Can you post a code example? Thank you! :D J.

6. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Hi , I used the below script to get the sql data into csv file using unix scripting. I m getting the output into an output file but the output file is not displayed in a separe columns . #!/bin/ksh export FILE_PATH=/maav/home/xyz/abc/ rm $FILE_PATH/sample.csv sqlplus -s...

7. UNIX for Advanced & Expert Users

Call parallel sql scripts from shell and return status when both sql are done

Hi Experts: I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing...

8. Shell Programming and Scripting

how to replace a string with new string after connecting to sql

Hi, I have a file which contains the following data File.dat <filenum> W10 </filenum> <hello>Heading </hello> I need to replace the contents of file.dat with database value inplace of W10 Can some one please tell me how to search this <filenum> W10</filenum> and replace...

9. UNIX for Dummies Questions & Answers

SQL block in a Shell Script connecting to a local and remote DB

Hi All, In a Shell scriipt with a SQL block I want to issue a query against a local DB and a remote DB on a remote server. The shell script is running locally. This is how I connect to the local server. But I want the query to reference remote table in the join. Question can I specify a...

10. Shell Programming and Scripting

How to get rid off Password expiry error message when connecting to sql in script?

I am connecting to sql databases through shell script. Databases that i am connecting will need password change every 60 days. This is according to our security policy and cannot be changed. But this is creating problem when connecting to Databases through shell script . To connect to oracle DB we...

LEARN ABOUT CENTOS

ldns_dnssec_rrs_print

ldns(3) 						     Library Functions Manual							   ldns(3)

NAME

       ldns_dnssec_rrs_new, ldns_dnssec_rrs_free, ldns_dnssec_rrs_add_rr, ldns_dnssec_rrs_print

SYNOPSIS

       #include <stdint.h>
       #include <stdbool.h>

       #include <ldns/ldns.h>

	ldns_dnssec_rrs_new();

       void ldns_dnssec_rrs_free(ldns_dnssec_rrs *rrs);

       ldns_status ldns_dnssec_rrs_add_rr(ldns_dnssec_rrs *rrs, ldns_rr *rr);

       void ldns_dnssec_rrs_print(FILE *out, ldns_dnssec_rrs *rrs);

DESCRIPTION

       ldns_dnssec_rrs_new()

       ldns_dnssec_rrs_free() Frees the list of rrs, but *not* the individual ldns_rr records contained in the list

	      rrs: the data structure to free

       ldns_dnssec_rrs_add_rr() Adds an RR to the list of RRs. The list will remain ordered

	      rrs: the list to add to
	      rr: the RR to add
	      Returns LDNS_STATUS_OK on success

       ldns_dnssec_rrs_print() Prints the given rrs to the file descriptor

	      out: the file descriptor to print to
	      rrs: the list of RRs to print

AUTHOR

       The ldns team at NLnet Labs. Which consists out of Jelte Jansen and Miek Gieben.

REPORTING BUGS

       Please report bugs to ldns-team@nlnetlabs.nl or in our bugzilla at http://www.nlnetlabs.nl/bugs/index.html

COPYRIGHT

       Copyright (c) 2004 - 2006 NLnet Labs.

       Licensed under the BSD License. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

SEE ALSO

       ldns_dnssec_zone.  And perldoc Net::DNS, RFC1034, RFC1035, RFC4033, RFC4034  and RFC4035.

REMARKS

       This manpage was automaticly generated from the ldns source code by use of Doxygen and some perl.

								    30 May 2006 							   ldns(3)

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Connecting DB in the Shell Script to do SQL Query

Discussion started by: mehuldoshi

2. Shell Programming and Scripting

connecting ....sql

Discussion started by: dreams5617

3. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

Discussion started by: rajagavini

4. Shell Programming and Scripting

error connecting sql through a shell script

Discussion started by: nehak