06-27-2011
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
Could you please guide me to write the shell script, to send a multi file as a attachement .
Thanks
Murugesh (1 Reply)
Discussion started by: Murugesh
1 Replies
2. UNIX for Advanced & Expert Users
Hello - In unix, can you tell me IF there is a way to send attachments via email without using uuencode command?
Thank you (3 Replies)
Discussion started by: panchpan
3 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I have already read a lot of posts on sending attachments in unix...but none of them were of help for my problem...so here goes..
i wanna attach a text file and send to a mail id..used the following code :
uuencode "$File1" "$File1" ;|mail -s "$Mail_sub" abc@abc.com
it works... (2 Replies)
Discussion started by: ash22
2 Replies
4. UNIX for Dummies Questions & Answers
Hi All,
I'm using uuencode to send out mail from unix to lotus notes,but i dont have any attachment to send out, I'm getting this message in the body of the mail
"Usage: uuencode remotedest"
however if i dont use uuencode I'm not able to send out mail
Please help
Thanks (1 Reply)
Discussion started by: gwrm
1 Replies
5. AIX
Hi,
Could anyone please help me to send multiple files of .csv format in one mail.
Thanks
Aj (2 Replies)
Discussion started by: atinjain05
2 Replies
6. Shell Programming and Scripting
H All
I want to send attachment in mail but I dont have uuencode installed in AIX server,
there is any alternative way to send attachment in mail. (2 Replies)
Discussion started by: ns64110
2 Replies
7. Shell Programming and Scripting
Hi Guys,
I dont have uuencode, mutt, base64 command available on my aix machine there is any alternative way to send file as attachement in mail. (3 Replies)
Discussion started by: ns64110
3 Replies
8. AIX
Hi Guys,
I dont have uuencode, mutt, base64 command available on my aix machine there is any alternative way to send file as attachement in mail. (1 Reply)
Discussion started by: ns64110
1 Replies
9. AIX
Dear All,
Would some one help me with this to send a file as attachment in a mail using a script without uuencode...
I am working on AIX 6.1, the thing is I dont have uuencode available... Is there any other alternate possible way to send file attachment with the mail without using uuencode... (11 Replies)
Discussion started by: msmadhan11
11 Replies
10. Shell Programming and Scripting
Hi,
In my Linux am unable to send attachment to mail . Since pkgs for mutt and uuencode is not possible to install any other options for sending attachment will be useful.
Tried the below options but its not working.
mail -s "testmail" -a <filename> abc@mail.com
cat <filename>|mail -s... (4 Replies)
Discussion started by: rogerben
4 Replies
LEARN ABOUT SUSE
select_into
SELECT
INTO(7) SQL Commands SELECT INTO(7)
NAME
SELECT INTO - define a new table from the results of a query
SYNOPSIS
[ WITH [ RECURSIVE ] with_query [, ...] ]
SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
* | expression [ [ AS ] output_name ] [, ...]
INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table
[ FROM from_item [, ...] ]
[ WHERE condition ]
[ GROUP BY expression [, ...] ]
[ HAVING condition [, ...] ]
[ WINDOW window_name AS ( window_definition ) [, ...] ]
[ { UNION | INTERSECT | EXCEPT } [ ALL ] select ]
[ ORDER BY expression [ ASC | DESC | USING operator ] [ NULLS { FIRST | LAST } ] [, ...] ]
[ LIMIT { count | ALL } ]
[ OFFSET start [ ROW | ROWS ] ]
[ FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ONLY ]
[ FOR { UPDATE | SHARE } [ OF table_name [, ...] ] [ NOWAIT ] [...] ]
DESCRIPTION
SELECT INTO creates a new table and fills it with data computed by a query. The data is not returned to the client, as it is with a normal
SELECT. The new table's columns have the names and data types associated with the output columns of the SELECT.
PARAMETERS
TEMPORARY or TEMP
If specified, the table is created as a temporary table. Refer to CREATE TABLE [create_table(7)] for details.
new_table
The name (optionally schema-qualified) of the table to be created.
All other parameters are described in detail under SELECT [select(7)].
NOTES
CREATE TABLE AS [create_table_as(7)] is functionally similar to SELECT INTO. CREATE TABLE AS is the recommended syntax, since this form of
SELECT INTO is not available in ECPG or PL/pgSQL, because they interpret the INTO clause differently. Furthermore, CREATE TABLE AS offers a
superset of the functionality provided by SELECT INTO.
Prior to PostgreSQL 8.1, the table created by SELECT INTO included OIDs by default. In PostgreSQL 8.1, this is not the case -- to include
OIDs in the new table, the default_with_oids configuration variable must be enabled. Alternatively, CREATE TABLE AS can be used with the
WITH OIDS clause.
EXAMPLES
Create a new table films_recent consisting of only recent entries from the table films:
SELECT * INTO films_recent FROM films WHERE date_prod >= '2002-01-01';
COMPATIBILITY
The SQL standard uses SELECT INTO to represent selecting values into scalar variables of a host program, rather than creating a new table.
This indeed is the usage found in ECPG (see in the documentation) and PL/pgSQL (see in the documentation). The PostgreSQL usage of SELECT
INTO to represent table creation is historical. It is best to use CREATE TABLE AS for this purpose in new code.
SEE ALSO
CREATE TABLE AS [create_table_as(7)]
SQL - Language Statements 2010-05-14 SELECT INTO(7)