Hi everyone,
I know this sounds stupid but on my Sun solaris machine I have csh script that finds all files 7 days older and then moves it to another area. The find works but the move I get "Arguments too long". I know that in c shell can not handel more 1706 arguments.
Can anyone give... (2 Replies)
Hi All,
Please help me to perform sum of values in a loop, I am getting following error:
"total=0++432907765772: ++ requires lvalue"
where actual statement is as : total=$total+$amt
where amt can have +ve or -ve values
Thanks
Sandeepb (3 Replies)
Hi,
I am trying to compile our linux code base in solaris and came across the following issues. Am I suppose to do something special ?
Can anyone help me to fix this issue.
System :
uname -a
SunOS aspen 5.10 Generic_125100-08 sun4u sparc SUNW,Sun-Fire-280R
The complier that I am using is... (0 Replies)
Hi,
Always when I login to Unix, I need to give the following command to view the data properly;
export MAESTRO_OUTPUT_STYLE=LONG
The reason is that by default the settings export MAESTRO_OUTPUT_STYLE=SHORT
Please let me know how I could make LONG as the default and avoid giving the... (1 Reply)
Hi,
I have line in input file as below:
3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL
My expected output for line in the file must be :
"1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL"
Can someone... (7 Replies)
I am trying to find lines in a text file larger than 3 Gb that start with a given string. My command looks like this:
$ look "string" "/home/patrick/filename.txt"
However, this gives me the following message:
"look: /home/patrick/filename.txt: File too large"
So, I have two... (14 Replies)
logs:
"/home/abc/public_html/index.php"
"/home/abc/public_html/index.php"
"/home/xyz/public_html/index.php"
"/home/xyz/public_html/index.php"
"/home/xyz/public_html/index.php"
how to use "cut" or "awk" or "sed" to get the following result:
abc
abc
xyz
xyz
xyz (8 Replies)
I have to replace the pattern found in one file in another file with null/empty "" if found on the fields 3 or 4 ONLY
File 1
====
10604747|Mxdef|9999|9999|9999|2012-03-04 00:00:59
10604747|Mcdef|8888|9999|8888|2012-03-04 00:00:59
.
.
.
File 2
====
9999
8888
.
.
.
Expected... (7 Replies)
How to use "mailx" command to do e-mail reading the input file containing email address, where column 1 has name and column 2 containing “To” e-mail address
and column 3 contains “cc” e-mail address to include with same email.
Sample input file, email.txt
Below is an sample code where... (2 Replies)
Discussion started by: asjaiswal
2 Replies
LEARN ABOUT CENTOS
do
DO(7) PostgreSQL 9.2.7 Documentation DO(7)NAME
DO - execute an anonymous code block
SYNOPSIS
DO [ LANGUAGE lang_name ] code
DESCRIPTION
DO executes an anonymous code block, or in other words a transient anonymous function in a procedural language.
The code block is treated as though it were the body of a function with no parameters, returning void. It is parsed and executed a single
time.
The optional LANGUAGE clause can be written either before or after the code block.
PARAMETERS
code
The procedural language code to be executed. This must be specified as a string literal, just as in CREATE FUNCTION. Use of a
dollar-quoted literal is recommended.
lang_name
The name of the procedural language the code is written in. If omitted, the default is plpgsql.
NOTES
The procedural language to be used must already have been installed into the current database by means of CREATE LANGUAGE. plpgsql is
installed by default, but other languages are not.
The user must have USAGE privilege for the procedural language, or must be a superuser if the language is untrusted. This is the same
privilege requirement as for creating a function in the language.
EXAMPLES
Grant all privileges on all views in schema public to role webuser:
DO $$DECLARE r record;
BEGIN
FOR r IN SELECT table_schema, table_name FROM information_schema.tables
WHERE table_type = 'VIEW' AND table_schema = 'public'
LOOP
EXECUTE 'GRANT ALL ON ' || quote_ident(r.table_schema) || '.' || quote_ident(r.table_name) || ' TO webuser';
END LOOP;
END$$;
COMPATIBILITY
There is no DO statement in the SQL standard.
SEE ALSO
CREATE LANGUAGE (CREATE_LANGUAGE(7))
PostgreSQL 9.2.7 2014-02-17 DO(7)