08-26-2013
Why are you not using the case statement?
8 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi ,
I have file named docs.txt
The content of the file look like this:
DOC disk location Size
======= ===== ============= =========
TXT A /dev/dm-1 10
TXT B /dev/dm-2 10
BIN C ... (3 Replies)
Discussion started by: yoavbe
3 Replies
2. UNIX for Dummies Questions & Answers
I need to ideas for some complex commands for a script file. Any ideas would be greatly appricated (2 Replies)
Discussion started by: trob
2 Replies
3. Shell Programming and Scripting
hey... i had a big problem with my professor
i have 3 simple archives
in.txt -> had all timestamps of users logon (100lines)
ex. 111111
222222
333333
out.txt -> had all timestamps of users logof (100lines)
ex. 111113
222225
333332
commands.txt... (9 Replies)
Discussion started by: beandj
9 Replies
4. Shell Programming and Scripting
A file whose location i am not aware of contains the below text
<url>jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(FAILOVER=on)(ADDRESS=(PROTOCOL=TCP)
(HOST=ngm2sn1p2-vip.mybank.net)(PORT=4001))(ADDRESS=(PROTOCOL=TCP)(HOST=ngm2sn2p2-vip.mybank.net)... (1 Reply)
Discussion started by: mohtashims
1 Replies
5. Shell Programming and Scripting
Hi All,
File1.txt
File2.txt
Above are the two input file's:
Always I use to get three rows for File1.txt
File1.txt (fixed width) 2nd line i will get date and 3rd record i will get a number.
File2.txt (Pile delimeter) will contains 'n' number of records were header & footer is... (4 Replies)
Discussion started by: kmsekhar
4 Replies
6. Shell Programming and Scripting
i have a requirement to search a pattern1 and once the pattern1 is found i have to go up and search pattern2 and if pattern2 is found i have to search down for pattern3 and pattern4. once this cycle is compelted, again i have to search pattern1 and pattern2,3,4
i am able to do this by opening... (9 Replies)
Discussion started by: tnvanathy23
9 Replies
7. Shell Programming and Scripting
Hi,
I have a file. In this file when ever the word "ABC" occurs at position from 25 and 34 I would like to replace
the value at postion 100 to 5 for the first 1000 rows only.
I have written the following Awk command.
nawk 'substr($0,25,9)=="ABC" {print $0}' filename
The above command... (4 Replies)
Discussion started by: pinnacle
4 Replies
8. Shell Programming and Scripting
If I need the output as below, what syntax I should use. I use only korn shell.
=========In file ===========================
#!/usr/bin/ksn
P1=cat
P2=dog
P3=bat
for i 1 2 3
do
echo $P$i # <---------- This line is the problem I face. What I should use.
done
========= End of file... (5 Replies)
Discussion started by: kkakarot
5 Replies
LEARN ABOUT CENTOS
execute
EXECUTE(7) PostgreSQL 9.2.7 Documentation EXECUTE(7)
NAME
EXECUTE - execute a prepared statement
SYNOPSIS
EXECUTE name [ ( parameter [, ...] ) ]
DESCRIPTION
EXECUTE is used to execute a previously prepared statement. Since prepared statements only exist for the duration of a session, the
prepared statement must have been created by a PREPARE statement executed earlier in the current session.
If the PREPARE statement that created the statement specified some parameters, a compatible set of parameters must be passed to the EXECUTE
statement, or else an error is raised. Note that (unlike functions) prepared statements are not overloaded based on the type or number of
their parameters; the name of a prepared statement must be unique within a database session.
For more information on the creation and usage of prepared statements, see PREPARE(7).
PARAMETERS
name
The name of the prepared statement to execute.
parameter
The actual value of a parameter to the prepared statement. This must be an expression yielding a value that is compatible with the data
type of this parameter, as was determined when the prepared statement was created.
OUTPUTS
The command tag returned by EXECUTE is that of the prepared statement, and not EXECUTE.
EXAMPLES
Examples are given in the EXAMPLES section of the PREPARE(7) documentation.
COMPATIBILITY
The SQL standard includes an EXECUTE statement, but it is only for use in embedded SQL. This version of the EXECUTE statement also uses a
somewhat different syntax.
SEE ALSO
DEALLOCATE(7), PREPARE(7)
PostgreSQL 9.2.7 2014-02-17 EXECUTE(7)