sql easily supports that, but you need to tell it what things to join on.
You may need to tell it local.columname instead of just columnname for columns in local.
Hello Group,
What I have is a database with about a dozen fields and one being "City".
What I would like to do is to have a custom query on a single field for multiple items (cities) but I don't know how to do this. I know this is probably kids play for most of you but I am lost. What I have... (4 Replies)
Hello,
I would like to ask for help with csh script.
An example of an input in .txt file is below, the number of lines varies from file to file and I have 2 or 3 columns with values. I would like to read all the values (probably one by one) and set them to independent unique variables that... (7 Replies)
my queryis :
select distinct m.name, item_count, item from master m join client p on m.name=p.name where item_count = 1 and item > 1;
But how should I update them?
i used update statetment :
Update from client Set item =1 where m.name=p.name and item_count=1 AND item>1
Is this wrong? (1 Reply)
Hi All,
I need to read values of 10 columns from oracle query and assign the same to 10 unix variables. The query will return only one record(row).
I tried to append all these columns using a delimiter(;) in the select query and assign the same to a single variable(V) in unix. I thought I... (3 Replies)
Hello Gurus,
I have a multiple pipe separated files which have records going over multiple Lines. End of line separator is \n and records going over multiple lines have <CR> as separator. below is example from one file.
1|ABC DEF|100|10
2|PQ
RS
T|200|20
3| UVWXYZ|300|30
4| GHIJKL|400|40... (7 Replies)
What I have:
I have a input.sh (script which basically connect to mysql-db and query's multiple tables to write back the output to output1.out file in a directory)
note: I need to pass an integer (unique_id = anything b/w 1- 1000) next to the script everytime I run the script which generates... (3 Replies)
HI
I have a dsv file that looks like:
<<BOF>>
record_number|id_number|first name|last name|msisdn|network|points|card number|gender
312|9101011234011|Test Junior|Smith|071 123 4321|MTN|73|1241551413214444|M
313|9012023213011|Bob|Smith|27743334321|Vodacom|3|1231233232323244|M... (4 Replies)
Hello All,
just wanted to export multiple tables from oracle sql using unix shell script to csv file and the below code is exporting only the first table.
Can you please suggest why? or any better idea?
export FILE="/abc/autom/file/geo_JOB.csv"
Export= `sqlplus -s dev01/password@dEV3... (16 Replies)
Discussion started by: Hope
16 Replies
LEARN ABOUT LINUX
qmail-local
qmail-local(8) System Manager's Manual qmail-local(8)NAME
qmail-local - deliver or forward a mail message
SYNOPSIS
qmail-local [ -nN ] user homedir local dash ext domain sender defaultdelivery
DESCRIPTION
qmail-local reads a mail message and delivers it to user by the procedure described in dot-qmail(5).
The message's envelope recipient is local@domain. qmail-local records local@domain in a new Delivered-To header field. If exactly the
same Delivered-To: local@domain already appears in the header, qmail-local bounces the message, to prevent mail forwarding loops.
The message's envelope sender is sender. qmail-local records sender in a new Return-Path header field.
homedir is the user's home directory. It must be an absolute directory name.
dash and ext identify the .qmaildashext file used by qmail-local; see dot-qmail(5). Normally dash is either empty or a lone hyphen. If it
is empty, qmail-local treats a nonexistent .qmailext the same way as an empty .qmailext: namely, following the delivery instructions in
defaultdelivery.
The standard input for qmail-local must be a seekable file, so that qmail-local can read it more than once.
OPTIONS -n Instead of reading and delivering the message, print a description of the delivery instructions.
-N (Default.) Read and deliver the message.
EXIT CODES
0 if the delivery is completely successful; nonzero if any delivery instruction failed. Exit code 111 indicates temporary failure.
SEE ALSO dot-qmail(5), envelopes(5), qmail-command(8), qmail-queue(8), qmail-send(8), qmail-lspawn(8)qmail-local(8)