10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Have a file which has the create statement like below
create table emp
( empno integer,
empname char(50))
primary index(empno);
i need to find a string starting with create and ends with semi-colon ;. if so insert the below statement before create statement
rename table emp to emp_rename;... (2 Replies)
Discussion started by: Mohan0509
2 Replies
2. Shell Programming and Scripting
I have a following file:
# User defined in group
admin = boss, sysadmin
phpteam = php1, php2, php3
rubyteam = ruby1, ruby2
# SVN root should only be access by boss and system admin
@admin = rw
* =
# Main web repository should only be access by boss and system admin, others... (3 Replies)
Discussion started by: ankur328
3 Replies
3. Shell Programming and Scripting
Hi,
I want to do a sed (linux) or the alternative in PHP to insert a backslash in front of every occurrence of every forward slash
ex.
/archive/data/stanley
-->
\/archive\/data\/stanley
I appreciate it! (4 Replies)
Discussion started by: deadyetagain
4 Replies
4. Shell Programming and Scripting
Hi All
I got one problem and want your help,what i want to do is
Input
123 key0=A;B;C;:key1=X;Y;Z;:
here 123 is a username
I should search the username (in this case it is 123) in file and if found it should insert the additional string D as below
Here 123 and key are tab seperated
... (6 Replies)
Discussion started by: parthmittal2007
6 Replies
5. Shell Programming and Scripting
Hi,, Please excuse my lack of knowledge here. I think I am tring to do something fairly advanced yet am a bit of a beginner.....
I want to use a korn shell (as is the norm with others in my company) to write a script to search a file for a string and insert some text above that line.
Sudo... (5 Replies)
Discussion started by: HugoDarley
5 Replies
6. Shell Programming and Scripting
Hi, guys. I have one question:
How can I search for a line with certain string in it and then insert a string into this line?
For example:
There is a file called shadow, the contents of it are below:
**************************
...
yuanz:VIRADxMsadfDF/Q:0:0:50:7:::... (9 Replies)
Discussion started by: daikeyang
9 Replies
7. Shell Programming and Scripting
Hi have a lots of files with this type of code
Example--1
PROCEDURE DIVISION USING
AAA
BBB
CCC.
Example--2
PROCEDURE DIVISION
Some Commented Lines....
USING
AAA
BBB
CCC.
Example--3 (12 Replies)
Discussion started by: pbsrinivas
12 Replies
8. Shell Programming and Scripting
i wanted to search between pattrens
so i used
awk /"EXEC CICS DELETEQ TS"/,/END-IF/
but the some change is
AAAAAAAA
EXEC CICS DELETEQ TS
IF .....
END-IF....
XXXXXx
XXX
IF (3 Replies)
Discussion started by: pbsrinivas
3 Replies
9. Shell Programming and Scripting
Hi All
I have a Small Requiement
I wanted to replace all the Follwing lines as follows
Input:: file1
EVALUATE WS-TEMP-ATTR(15:1)
WHEN 'D'
MOVE DFHDARK TO WS-ATTR-COLOR
WHEN OTHER
MOVE DFHDFT ... (9 Replies)
Discussion started by: pbsrinivas
9 Replies
10. Shell Programming and Scripting
how can i modify a file using sed when searching
for a pattern and insert newline after the pattern?
pattern example: $ ...(any characters)...$
$ may082001.../tmp/msg.001,,$ REPT CLEAR ALARMS ON UNIT 1
$ may082001.../tmp/msg.002,,$ UNIT 1 IN SERVICE
into:
$... (1 Reply)
Discussion started by: apalex
1 Replies
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)
