Execute SQL query in unix script Post: 302371614

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

sql query results in unix shell script

Hi I want to get the a field from a SQL query into unix shell script variable. the whole situation is like this. 1. Opened a cursor to a table in DB2 databse. 2. Fetching individual rows with the help of cursor. 3. Each row has 4 fields. I want each of the field in individual shell...

2. Shell Programming and Scripting

Execute oracle query determined at runtime from a unix script

Hi I am trying to run a SQL statement from a unix script determined at runtime. It is throwing me an error. Please advise some solution to this. echo "Enter username for the database" read username echo "Enter password for the database" read password echo "Enter SQL stmt" read...

3. Shell Programming and Scripting

need help in reading a output of a sql query in unix script

i'm used a sql query in a unix script to get the information from table. but unable to extract the output which i need. Any help with logic will be greatly appreciated. my sql query provide output some thing like this - col1 col2 count ---- ---- ------ A B 10 c D 6 e...

4. Shell Programming and Scripting

TO execute .sql 2005 query file in shell script

Hi, I know in oracle a .sql file is called by @ <path> /<filename>. But how to call in sql 2005, I am opening the sql sessionwith sqsh, is there any command to execute there a .sql file (query in sql 2005) in K shell script.

5. UNIX for Dummies Questions & Answers

Execute PL/SQL function from Unix script (.sql file)

Hi guys, I am new on here, I have a function in oracle that returns a specific value: create or replace PACKAGE BODY "CTC_ASDGET_SCHED" AS FUNCTION FN_ASDSCHEDULE_GET RETURN VARCHAR2 AS BEGIN DECLARE ASDSchedule varchar2(6); ASDComplete...

6. UNIX for Dummies Questions & Answers

executing SQL query using unix shell script

I want to perform few post-session success tasks like update a status to 'true' in one of the sql database table, update date values to current system date in one of the configuration table in sql. How do i achieve this in a post session command?syntax with example will be helpful.

7. Shell Programming and Scripting

Different way to connect to database ans execute sql query

Hi Friends, I am using AIX version and sqlplus to connect to database while writing a shell script. I have implemented three ways to connect to database : 1) sqlplus -s <USERNAME>/<PASSWORD> <<! @<SQL FILE TO EXECUTE> exit ! 2) sqlplus -s <USERNAME>/<PASSWORD> <<! -----sql statemenets...

8. Programming

JDBC code to pass the SQL query as parameter and execute?

Below i have the sample code. i need to pass the entire query from file or as parameter and read the results and write into a output file. here the number of columns are unknown. some times it may be 2,3 or entire columns from the table. read all the column results and write into a comma...

9. Shell Programming and Scripting

SQL query in UNIX script - output in flat file

Hi, I never did this before... what I want to do is execute a SQL query from a unix script and redirect sql query's output to a flat file (comma separated one) without the header info (no column names). I would also want not to print the query's output to the screen. snapshot of my script:...

10. Shell Programming and Scripting

Shell script to execute sql query.

Hi Experts, Need your support. Not able to use sql query alias in shell script. Could you please help me in finding right way to use alias with sql query in shell script. Below is the code i am using. #!/bin/bash sqlplus -s abc/abc@abc << EOF> bcd.csv set trimspool on select zone_id...

LEARN ABOUT OPENDARWIN

exicyclog

EXICYCLOG(8)						      System Manager's Manual						      EXICYCLOG(8)

NAME

       exicyclog - Cycle exim's logfiles

SYNOPSIS

       eximcyclog

DESCRIPTION

       The  exicyclog script can be used to cycle (rotate) mainlog and rejectlog files.  This is not necessary if only syslog is being used.  Some
       operating systems have their own standard mechanisms for log cycling, and these can be used instead of exicyclog if preferred.

       Each time exicyclog is run the file names get 'shuffled down' by one.  If the main log file name is mainlog (the default) then when  exicy-
       clog is run mainlog becomes mainlog.01, the previous mainlog.01 becomes mainlog.02 and so on, up to a limit which is set in the script, and
       which defaults to 10.  Reject logs are handled similarly.

       If no mainlog file exists, the script does nothing.  Files that 'drop off' the end are deleted.	All files with numbers greater than 01 are
       compressed,  using a compression command which is configured by the COMPRESS_COMMAND setting in Local/Makefile.	It is usual to run "exicy-
       clog" daily from a root "crontab" entry of the form

	 1 0 * * * su exim -c /usr/exim/bin/exicyclog

       assuming you have used the name 'exim' for the Exim user.  You can run exicyclog as root if you wish, but there is no need.

BUGS

       This manual page needs a major re-work. If somebody knows better groff than us and has more experience in writing manual pages, any patches
       would be greatly appreciated.

SEE ALSO

       exim(8), /usr/share/doc/exim4-base/

AUTHOR

       This  manual  page was stitched together from spec.txt by Andreas Metzler <ametzler at downhill.at.eu.org>, for the Debian GNU/Linux system
       (but may be used by others).

								  March 26, 2003						      EXICYCLOG(8)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

sql query results in unix shell script

Discussion started by: skyineyes

2. Shell Programming and Scripting

Execute oracle query determined at runtime from a unix script

Discussion started by: infyanurag

3. Shell Programming and Scripting

need help in reading a output of a sql query in unix script

Discussion started by: pharos467

4. Shell Programming and Scripting

TO execute .sql 2005 query file in shell script

Discussion started by: n2ekhil