|
|
Sponsored Content
Operating Systems
Solaris
Mysql query reading a text file.
Post 302382433 by jyothi_wipro on Wednesday 23rd of December 2009 08:01:08 AM
12-23-2009
Thanks!! that was really exact what i wanted,without any struggle i could get the output which i required.
That was really helpful.
That was really helpful.
|
|
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a text file with 50 munbers.
I wanna read these numbers and append "@yahoo.com" and send emails to them using shell scripting..........
How do i read the inetegres from the text file. (1 Reply)
Discussion started by: jaan
1 Replies
2. Shell Programming and Scripting
Guys,
I am trying to read text from a file, into arrays.
The format of the file is:
@DATABASE
femotest
@PACKAGE_SPECS
/usr/home/oracle92/sosa/scripts/test.pks
/usr/home/oracle92/sosa/scripts/rep.pks
@PACKAGE_BODIES
... (12 Replies)
Discussion started by: LiquidChild
12 Replies
3. UNIX for Dummies Questions & Answers
How can i have a while loop as follows
while read inputline
do
<task>
done < name_list
and also store the values (delimited) on each line to temp variables so as to print them on screen as follows
while read inputline
do
set name | cut -d "," -f1 name_list # #i know this is not... (1 Reply)
Discussion started by: bilal05
1 Replies
4. UNIX for Dummies Questions & Answers
Hi all,
Here is my problem. I want to read data from a file and pass the variable to a select query.
I tried but it doesn't seem to work. Please advise. Example below.
FileName='filekey.txt'
while read LINE
do
var=$LINE
print "For File key $var"
${ORACLE_HOME}/bin/sqlplus -s... (1 Reply)
Discussion started by: er_ashu
1 Replies
5. Programming
hello all ,
im trying to read a text file and display its contents. While i got the code running and the output was displayed perfectly for sometime , i started getting Abort(core dump) error . Am i missing something here ? im using HP-UX.
#include <iostream.h>
#include <fstream.h>
#include... (1 Reply)
Discussion started by: vishy_85
1 Replies
6. Shell Programming and Scripting
Hi,
I've a txt file with the following contents:
variable = "select name, emp_id, org_name "
variable = variable + " from table_name where "
variable = variable + " condition_1 = ABC and "
variable = variable + " condition_2 = DEF "
varaible = variable + " order by other condition "
... (7 Replies)
Discussion started by: arjun_arippa
7 Replies
7. Shell Programming and Scripting
Hi Guys,
I am having below file which holds data like this
file.txt
name,id,flag
apple,1,Y
apple,2,N
mango,1,Y
mango,2,Y
I need to read the above file and frame a query like this
hive -s -e "create apple_view as select 1 from main_table;"
hive -s -e "create mango_view as select... (11 Replies)
Discussion started by: rohit_shinez
11 Replies
8. Programming
Hello Team,
I have 2 files.one contains english text and another contains Japanese. so i have to read english text and replace the text with Japanesh text in third file.
Basically, I need a help to write japanese language in text/xml file.I heard wstring does this.Not sure how do i write... (2 Replies)
Discussion started by: SA_Palani
2 Replies
9. UNIX for Beginners Questions & Answers
I would like to call a .sql file from a .sh file in linux. The .sql file will contain queries to MySQL database.
I am able to call the .sql file by running .sh file in linux, but the sql query is not working. Below is my syntax. The select statement is throwing below error.
./sample.sql: line... (1 Reply)
Discussion started by: qytan
1 Replies
LEARN ABOUT CENTOS
ausyscall
AUSYSCALL:(8) System Administration Utilities AUSYSCALL:(8) NAME
ausyscall - a program that allows mapping syscall names and numbers SYNOPSIS
ausyscall [arch] name | number | --dump | --exact DESCRIPTION
ausyscall is a program that prints out the mapping from syscall name to number and reverse for the given arch. The arch can be anything returned by `uname -m`. If arch is not given, the program will take a guess based on the running image. You may give the syscall name or number and it will find the opposite. You can also dump the whole table with the --dump option. By default a syscall name lookup will be a substring match meaning that it will try to match all occurrences of the given name with syscalls. So giving a name of chown will match both fchown and chown as any other syscall with chown in its name. If this behavior is not desired, pass the --exact flag and it will do an exact string match. This program can be used to verify syscall numbers on a biarch platform for rule optimization. For example, suppose you had an auditctl rule: -a always, exit -S open -F exit=-EPERM -k fail-open If you wanted to verify that both 32 and 64 bit programs would be audited, run "ausyscall i386 open" and then "ausyscall x86_64 open". Look at the returned numbers. If they are different, you will have to write two auditctl rules to get complete coverage. -a always,exit -F arch=b32 -S open -F exit=-EPERM -k fail-open -a always,exit -F arch=b64 -S open -F exit=-EPERM -k fail-open For more information about a specific syscall, use the man program and pass the number 2 as an argument to make sure that you get the syscall information rather than a shell script program or glibc function call of the same name. For example, if you wanted to learn about the open syscall, type: man 2 open. OPTIONS
--dump Print all syscalls for the given arch --exact Instead of doing a partial word match, match the given syscall name exactly. SEE ALSO
ausearch(8), auditctl(8). AUTHOR
Steve Grubb Red Hat Nov 2008 AUSYSCALL:(8)