Hi Guys !
I am new to unix and want to find out how we can make sql statement data to shell script variable?
Any help/suggestion is greatly appreciated
-Chandra (1 Reply)
Dear Friends
I have text file as like below,
AAAAA|BHBHBH|VERYSMART
AAAAA| KKKKKK|GOOD
BBBBBB|JJJJJJJ|VERYGOOD
CCCCC|HJHJHJ|BETTER
CCCCC|UUUUU|GOOD
i need to split into seperate files based on column 1 like as below
AAAAA.TXT contains
--------------------
BHBHBH.VERYSMART... (4 Replies)
:confused: Hi UNIX gurus,
I am facing a typical problem while assigining while assigining output of awk to a variable.
I have a fixed length file say myinputfile.txt
When I allow the value/output of an awk to be redirected to a file, it works fine. i.e.
awk "/^.{232}$acctNum/ {... (8 Replies)
Hi Friends...
Please assist me to assign the result of a SQL query that results two column, to two variables.
Pls find the below code that I write for assigning one column to one variable. and please correct if anything wrong..
#! /bin/sh
no='
sqlplus -s uname/password@DBname... (4 Replies)
How can I assign a variable to an variable. IE $car=honda
One way I can do it is export $car=honda
or
let $car=2323
Is there any other ways to preform this task (3 Replies)
I have a log file that has certain fields that I want to evaluate, and depending on the value in those fields, I want to put the value of a different field in that line in a particular variable that I'll use later on down the log file. Sort of like setting a switch to change what I do with a bunch... (5 Replies)
I launch 'netstat -a', if string 'ESTABLISHED' found, then VAR=1
#!/bin/bash
VAR=0;
netstat -a | awk '$6 ~ /ESTABLISHED/ {VAR=1}'
I cannot find the right syntax.
thanx guys! (3 Replies)
I have the following script, and I want to assign the output ($10 and $5) from awk to N and L:
grdinfo data.grd | awk '{print $10,$5}'| read N L
output from gridinfo data.grd is: data.grd 50 100 41 82 -2796 6944 0.016 0.016 3001 2461. where N and L is suppose to be 3001 and 100. I use... (8 Replies)
Hi Gurus,
I have a script which assign awk output to shell variable. current it uses two awk command to assign value to two variables. I want to use one command to assign two values to two variables. I tried the code, but it does't work. kindly provide your suggestion.
current code... (2 Replies)
Discussion started by: green_k
2 Replies
LEARN ABOUT MINIX
hosts
HOSTS(5) File Formats Manual HOSTS(5)NAME
hosts - hostname to IP address database
SYNOPSIS
/etc/hosts
DESCRIPTION
The hosts database lists the IP addresses and the hostnames that translate to these IP addresses. It is used by nonamed(8) in a network
without name servers. A simple /etc/hosts may look like this:
127.0.0.1 localhost
192.9.200.1 darask
192.9.200.2 burask
The localhost entry lists a special address that refers to the local host itself (a kind of /dev/tty for hosts.) You should only list it
if nonamed needs it! The other entries are actual machines. The file may contain comments marked with '#'.
You can have aliases (more hostnames on the same line), but it is not recommended, because nonamed can't present them to the system as
CNAME records. An often seen form like
192.9.200.1 darask.home.cs.vu.nl darask
is harmless though, and has the small advantage that you can use the short name in /etc/ethers so rarpd can match it at boot time.
FILES
/etc/hosts Hosts database.
SEE ALSO ethers(5), nonamed(8), rarpd(8), boot(8).
AUTHOR
Kees J. Bot (kjb@cs.vu.nl)
HOSTS(5)