12-25-2007
just to understand the problem:
what if
file1
-------
a
b
c
f
g
h
file2
---------
a
b
d
e
f
h
what should the output be ?
d
e
f
??
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi there,
I am trying to do the following in Unix (Solaris 2.7):
1...Find the actual date 7 days ago in format (dd-mmm-yyyy) and with the weekday prefably,
2...Find the date 5 days after the above in the same format.
How can I do this in Unix instead of accessing our Oracle database and... (5 Replies)
Discussion started by: csong2
5 Replies
2. UNIX for Dummies Questions & Answers
hello folks
i was executing few shell scripts using another login id , those were working fine ,these shell scripts basically call oracle stored procs
now when i copied those shell scripts files to another user location n logged into that user's unix id ,
it is showing errors ...:(
the oracle... (3 Replies)
Discussion started by: Dana Evans
3 Replies
3. Shell Programming and Scripting
Hi all,
I am having putty in my system.But I dont have access to any UNIX Servers.Is there any default or common UNIX Server so that anyone can access and be familiar with UNIX and Shell scripting.
I want to work and practice in UNIX..Thats why I am asking this question.
Kindly give me... (2 Replies)
Discussion started by: dave_nithis
2 Replies
4. Shell Programming and Scripting
I am running a query with contains blank spaces in between in the output. But when I open and read the file in UNIX i am not able to cursor the balnk spaces instead it is moving like tabs. Please help
suppose my query -
Select ' '||text from tab1;
the cursor should move to 1st and... (1 Reply)
Discussion started by: sbmk_design
1 Replies
5. Shell Programming and Scripting
Hi
i want write a script for list of sysbase are having access or open.
then i wrote like:
USER="abc"
PASS="xyz"
SERVER="SCCS"
DB="blue"
WORK_DIR="/usr/home/ramakrishna"
set -x
isql -U${USER} -P${PASS} -S${SERVER}<<EOF>$WORK_DIR/output.log
go
use blue (database name)
go
use... (0 Replies)
Discussion started by: koti_rama
0 Replies
6. Shell Programming and Scripting
Hi,
I am using sqlplus query to get results in a csv format in unix. I am using ksh, and below is the query.
echo "select r.num|| ',' || p.path ||',"' || r.issue_description ||'",' ||p.timestamp from events r, messagepath p;">> $QUERY_FILE
sqlplus -s $LOGIN @ $QUERY_FILE>>$OUTFILE
... (2 Replies)
Discussion started by: Nutan
2 Replies
7. UNIX for Dummies Questions & Answers
Hi,
I will execute a query in sqlplus and redirect to a file.
The file will contains the date value such as 2011-04-12 02:00:00.
i want to make the content of the file such as,
select * from table where col1>to_date('2011-04-12 02:00:00','yyyy-mm-dd HH24:MI:SS').
Apar from the bold... (1 Reply)
Discussion started by: pandeesh
1 Replies
8. Shell Programming and Scripting
Hi all ,
am using unix aix and
Am getting the syntax error on 'UNION'..
can anybody tell me the solutions..
INSERT INTO table1
(
Type
, num_items
, num_letters
, total_value
)
(select
type='1',
num_items,
num_letters=count(*),
total_value=sum(letter_value)
from
table2... (1 Reply)
Discussion started by: Venkatesh1
1 Replies
9. UNIX for Dummies Questions & Answers
I was performing the wc -l operation in one data file the result is less when i was giving -nu on the view of the file.
while giving wc -l the count is 5023
after setting line numbers in view of file is giving 5024.
Can anyone help on this.... (5 Replies)
Discussion started by: abhii
5 Replies
10. UNIX for Dummies Questions & Answers
Hi,
Could you please help me on this.
I have bulk of queries written in text file. I want to use those queries and want to execute from UNIX.
I don't want to run this file as a sql file as this file will change every week.
I want to run it in my environment as bulk sql statement from text... (1 Reply)
Discussion started by: abhii
1 Replies
UUX(1C) UUX(1C)
NAME
uux - unix to unix command execution
SYNOPSIS
uux [ - ] command-string
DESCRIPTION
Uux will gather 0 or more files from various systems, execute a command on a specified system and send standard output to a file on a spec-
ified system.
The command-string is made up of one or more arguments that look like a shell command line, except that the command and file names may be
prefixed by system-name!. A null system-name is interpreted as the local system.
File names may be one of(1) a full pathname;
(2) a pathname preceded by ~xxx; where xxx is a userid on the specified system and is replaced by that user's login directory;
(3) anything else is prefixed by the current directory.
The `-' option will cause the standard input to the uux command to be the standard input to the command-string.
For example, the command
uux "!diff usg!/usr/dan/f1 pwba!/a4/dan/f1 > !fi.diff"
will get the f1 files from the usg and pwba machines, execute a diff command and put the results in f1.diff in the local directory.
Any special shell characters such as <>;| should be quoted either by quoting the entire command-string, or quoting the special characters
as individual arguments.
FILES
/usr/uucp/spool - spool directory
/usr/uucp/* - other data and programs
SEE ALSO
uucp(1)
D. A. Nowitz, Uucp implementation description
WARNING
An installation may, and for security reasons generally will, limit the list of commands executable on behalf of an incoming request from
uux. Typically, a restricted site will permit little other than the receipt of mail via uux.
BUGS
Only the first command of a shell pipeline may have a system-name!. All other commands are executed on the system of the first command.
The use of the shell metacharacter * will probably not do what you want it to do.
The shell tokens << and >> are not implemented.
There is no notification of denial of execution on the remote machine.
UUX(1C)