************************************************************************
Shell Script:
#!/bin/ksh
ODATE=`secure_sqlplus @$./get_daily_odate.sql | tail -2 | head -1 | tr -s ' ' ''`
CHKENDTM=`secure_sqlplus @$./check_batch_endtime.sql \"A\" \"$ODATE\" | tail -2 | head -1 | tr -s ' ' '' | tail -2c`
************************************************************************
Contents of get_daily_odate.sql:
select to_char((sysdate-1),'mm/dd/yyyy') from dual
/
************************************************************************
Contents of check_batch_endtime.sql:
-- This SQL is used to get the end time of the batch for a odate
-- &1 -> batch zone, &2 -> odate
select count(*) from adf_batch_hist
where trunc(odate) = to_date('&2','mm/dd/yyyy') and batch_zone = '&1'
and (start_time is not null or to_char(start_time) <> '')
and (end_time is not null or to_char(end_time) <> '')
/
************************************************************************
What I am trying to do is instead of two separate .sql files, I will have both of these queries in a single .sql file.
Accordingly the shell script would call this single .sql file in both the statements. However, the first line of the shell script should execute only first query and the second line of the shell script should execute only second query.
Does that mean you want to connect to the database via sqlplus twice - one for the date and then for the count ?
Why would you want to do that ?
If you are connecting to the same schema (which appears to be the case), then connect just once, spool the results of both queries into a file and use the gazillion utilities of your shell to process that file.
Code:
$
$ # SQL script with all your queries.
$ cat myqueries.sql
set feed off pages 0 verify off trimspool on
select to_char((sysdate-1),'mm/dd/yyyy') from dual;
select count(*) from emp
where deptno = &1;
$
$ # Korn shell script that connects just once, runs all queries, and spools to a file
$ cat getdatecount.ksh
#!/bin/ksh
sqlplus -s /nolog <<EOF >getdatecount.log
connect test/test
@myqueries.sql 30
exit
EOF
ODATE=`head -1 getdatecount.log`
echo "ODATE = $ODATE"
CHKENDTM=`awk '{if (NR==2){print $1}}' getdatecount.log`
echo "CHKENDTM = $CHKENDTM"
$
$ ./getdatecount.ksh
ODATE = 11/19/2009
CHKENDTM = 6
$
$
tyler_durden
Last edited by durden_tyler; 11-20-2009 at 11:50 PM..
Hi all,
I am developing an application in Tcl, inwhich i have to load many modules written in C. I am converting those C modules into shared object(.so) files, and wrap it with my application using SWIG, for which i had the interface file.
Now my question is, i have two different... (2 Replies)
Looking to join three files and then transpose some columns from multiple rows into a single row.
File Info:
FIELD TERMINATED BY '^'
ENCLOSED BY '~'
LINE TERMINATED BY '\r\n'
FIRST FILE (FOOD_DES.txt)
~01001~^~0100~^~Butter, salted~^~BUTTER,WITH... (2 Replies)
Hi
I have multiple files each with two columns and I need to combine all those file into a tab delimited file. (multiple entry with same name separated by a comma)
The content of the files are as follows:
---
file1.txt:
name var1
aaa xx
aaa gg
bbb yy
ddd zz
---
file2.txt
... (8 Replies)
Hi All,
How can I merge 3rd column of multiple files into 1 file, the column header in the merged file being the name of the file from which the 3rd column was taken. The first 2 columns of all the files are exactly same.
Thanks for your help ! (3 Replies)
Hi all, I've searched the web for a long time trying to figure out how to merge columns from multiple files.
I know paste will append columns like so:
paste file1 file2 file3 file4 file5 ...
But this becomes inconvenient when you want to append a large number of files into a single file.
... (2 Replies)
Hi All,
I am trying to merge all the text files into one file using below snippet
cat /home/Temp/Test/Log/*.txt >> all.txt
But it seems it is not working.
I have multiple files like Output_ServerName1.txt, Output_ServreName2.txt
I want to merge each file into one single file and... (6 Replies)
Dear All,
I am trying to write a Unix Script which fires a sql query. The output of the sql query gives multiple rows. Each row should be saved in a separate Unix File.
The number of rows of sql output can be variable. I am able save all the rows in one file but in separate files.
Any... (14 Replies)
Hello and Good day
I have a lot of files with same number of rows and columns.$2 and $3 are the same in all files .
I need to merge $2,$3,$6 from first file and $6 from another files.
File1:
$1 $2 $3 $4 $5 $6... (8 Replies)
Hi all,
Say i have multiple files x1 x2 x3 x4, all with common header (date, time, year, age),,
How can I merge them to one singe file "X" in shell scripting
Thanks for your suggestions. (2 Replies)
Hi all
I have written some code to write my output in html.
As i have multiple servers, need to generate single html file. but my code is generating html file for each server.
I have merged the files using below code.
cat /home/*_FinalData.html > /home/MergedFinalData.html
But how to... (1 Reply)
Discussion started by: Snehasish
1 Replies
LEARN ABOUT CENTOS
rlm_sql
rlm_sql(5) FreeRADIUS Module rlm_sql(5)NAME
rlm_sql - FreeRADIUS Module
DESCRIPTION
The rlm_sql module provides an SQL interface to retrieve authorization information and store accounting information. It can be used in
conjunction with, or in lieu of the files and detail modules. The SQL module has drivers to support the following SQL databases:
db2
iodbc
mysql
oracle
postgresql
sybase
unixodbc
Due to the size of the configuration variables, the sql module is usually configured in a separate file, which is included in the main
radiusd.conf via an include directive.
The main configuration items to be aware of are:
driver This variable specifies the driver to be loaded.
server
login
password
These specify the servername, username, and password the module will use to connect to the database.
radius_db
The name of the database where the radius tables are stored.
acct_table1
acct_table2
These specify the tables names for accounting records. acct_table1 specifies the table where Start records are stored. acct_table2
specifies the table where Stop records are stored. In most cases, this should be the same table.
postauth_table
The name of the table to store post-authentication data.
authcheck_table
authreply_table
The tables where individual Check-Items and Reply-Items are stored.
groupcheck_table
groupreply_table
The tables where group Check-Items and Reply-Items are stored.
usergroup_table
The table where username to group relationships are stored.
deletestatlesessions
This option is set to 'yes' or 'no'. If you are doing Simultaneous-Use checking, and this is set to yes, stale sessions ( defined
as sessions for which a Stop record was not received ) will be cleared.
logfile
This option is useful for debugging sql problems. If logfile is set then all sql queries for the containing section are written to
the file specified. This is useful for debugging and bulk inserts.
num_sql_socks
The number of sql connections to make to the database.
connect_failure_retry_delay
The number of seconds to wait before attempting to reconnect to a failed database connection.
sql_user_name
This is the definition of the SQL-User-Name attribute. This is set once, so that you can use %{SQL-User-Name} in the SQL queries,
rather than the nested username substitution. This ensures that Username is parsed consistently for all SQL queries executed.
default_user_profile
This is the default profile name that will be applied to all users if set. This is not set by default.
query_on_not_found
This option is set to 'yes' or 'no'. If set to yes, then the default user profile is returned if no specific match was found for
the user.
authorize_check_query
authorize_reply_query
These queries are run during the authorization stage to extract the user authorization information from the ${authcheck_table} and
${authreply_table}.
authorize_group_check_query
authorize_group_reply_query
These queries are run during the authorization stage to extract the group authorization information from the ${groupcheck_table} and
${groupreply_table}.
accounting_onoff_query
The query to be run when receiving an Accounting On or Accounting Off packet.
accounting_update_query
accounting_update_query_alt
The query to be run when receiving an Accounting Update packet. If the primary query fails, the alt query is run.
accounting_start_query
accounting_start_query_alt
The query to be run when receiving an Accounting Start packet. If the primary query fails, the alt query is run.
accounting_stop_query
accounting_stop_query_alt
The query to be run when receiving an Accounting Stop packet. If the primary query fails, the alt query is run.
simul_count_query
The query to be run to return the number simultaneous sessions for the purposes of limiting Simultaneous Use.
simul_verify_query
The query to return the detail information needed to confirm that all suspected connected sessions are valid, and are not stale ses-
sions.
group_membership_query
The query to run to check user group membership.
postauth_query
The query to run during the post-authentication stage.
CONFIGURATION
Due to the size of the configuration for this module, it is not included in this manual page. Please review the supplied configuration
files for example queries and configuration details.
SECTIONS
authorization, accounting, checksimul, post-authentication
FILES
/etc/raddb/radiusd.conf, /etc/raddb/sql.conf, /etc/raddb/sql/<DB>/dialup.conf, /etc/raddb/sql/<DB>/schema.sql,
SEE ALSO radiusd(8), radiusd.conf(5),
AUTHORS
Chris Parker, cparker@segv.org
5 February 2004 rlm_sql(5)