I haven't have a real time scenario so didn't test this code, you could give it a try and let us know how it goes then.
Code:
cat script.ksh
### Here I am taking an example of sql db.
cat << EOF > sql_file.sql
select filenames from t_filenames;
EOF
sqlplus user_name/password@schema_name < sql_file.sql > output_file
#### Here we need to remove junk lines from file output_file which we will get once we connect to client. eg--> connected to: SQL*PLUS version etc.
which I can't predict until/unless you post output for above query with code tags here. So assuming we have removed those lines and have them into a file named output_file_names.
awk '{if($0 !~ /SQL*plus/ && $0 !~ /connected to/){print}}' output_file > output_file_names
while read line
do
if [[ -f "/tmp/$line" ]]
then
echo "File named " $line " is present."
else
touch "/tmp/$line"
fi
done < "output_file_names"
Though there could be more ways to perform this task, one could take this as a startup point.
Hi all,
I have a file entries.txt that contains a number of entries all on seperate lines e.g.
test1
test2
test3
test4
Then in a directory called /TestFiles I have a number of files that could contain the above text in the file name
e.g. qwertytest1.csv qwertytest2.csv... (2 Replies)
I am writting a script where I have to Campare two text files.
I have 3 text files named by s_list, s_list_new and dmg_file. where I have to compare s_list and s_list_new and whatever the unique values are in s_list I have to add that in the dmg_file. And the values they are only in s_list_new... (2 Replies)
Hi I am new to shell scripting. There is a requirement to write a shell script to meet follwing needs.Prompt reply shall be highly appreciated.
script that will compare two config files and produce 2 outputs - actual config file and a report indicating changes made.
OS :Susi linux ver 10.3.
... (4 Replies)
I have this code to compare columns 1 and 10 between file1 and file 2 and give me all records that match column 1 but dont match column 10
However column 10 is date format mm/dd/yy and awk cant read it and compare ...i tried
awk < file1 -F~ '{print $10}'
and it gave blank screen
Is... (1 Reply)
I have two csv files having 90K records each & each row has around 50 columns.Lets say the file names are FILE1 and FILE2. I have to compare both the files and generate a new file that has rows from FILE2 if it differs.
FILE1
-----
2001,"John",25,19901130,21211.41,Unix Forum... (3 Replies)
15:09:50.350038 Reading A Data
15:09:50.371645 Reading B Data
15:10:55.655724 Initializing models
15:11:31.320920 Preparing Simulation
15:11:32.763217 Running Calculation
15:15:29.668882 Aggregating Results
15:15:29.950897 Persisting Results
How could I make a matrix in H.M.S.MS... (7 Replies)
Does anyone know how to generate CGI charts which are not images , the one I am using generates image files
e.g
$mygraph3->set( 'x_labels_vertical' => 1 );
$mygraph3->set_legend_font(GD::gdMediumBoldFont);
$mygraph3->set_legend('Test Plot');
my $myimage3 = $mygraph3->plot(\@data3)->png;... (4 Replies)
Hello,
I am not able to find how to compare two dates in '%Y-%m-%d %H:%M:%S,%3N' format
i have to two dates as below
date1="2016-08-24 09:47:40,444"
date2="2016-08-24 10:45:40,567"
how to compare these two dates ?
I have tried below without success
if ; then echo 'yes'; fi
... (6 Replies)
I need top load memory and cpu uses in mail. I am getting mail, but output is coming in sentence format.
can help me, how can I get in actual format. below is the command.
echo `ps -eo pid,ppid,cmd,%mem,%cpu --sort=-%mem | head`|mailx -r `hostname -s`@abc.com abc@abc.com (5 Replies)
Discussion started by: yash_message
5 Replies
LEARN ABOUT DEBIAN
cvm-sql
cvm-sql(7) Miscellaneous Information Manual cvm-sql(7)NAME
cvm-sql - CVM SQL Framework
QUERY SUBSTITUTION
$VAR and ${VAR} are replaced with the quoted value of the environment variable named VAR. Use the second form when VAR contains anything
other than alpha-numeric or underscore (_) characters. Do not include quotes in the query. The variables account and domain contain the
account and domain names given by the CVM client. $$ is replaced with a single dollar sign.
QUERY RESULTS
The query must produce the following fields exactly in order. All required fields must not be null or empty.
1. Password, encrypted with crypt(3) (required)
2. Actual account name (required)
3. User ID (integer) (required)
4. Group ID (integer) (required)
5. Directory (required)
6. Real name (optional)
7. Login shell (optional)
8. Group name (optional)
9. Domain name (optional)
10. System account name (optional)
11. System account directory (optional)
12. Mailbox path (optional)
DEFAULT QUERY
SELECT password, username, userid, groupid, directory, realname, shell, groupname, domain, sys_username, sys_directory FROM accounts WHERE
username=$account AND domain=$domain
SEE ALSO cvm-mysql(8), cvm-pgsql(8), cvm-pwfile(8), cvm-qmail(8), cvm-unix(8), cvm-vmailmgr(8), cvm-benchclient(8), cvm-checkpassword(8), cvm-test-
client(8)
http://untroubled.org/cvm/cvm.html
cvm-sql(7)