11-27-2017
Hi Scott,
Thank you for pointing me to the right direction. It worked for me.
Though I searched a lot from morning I could not able to find that you have mentioned now I got it 2 O clock midnight
.
Though I would like to know how an expertise like you will prefer for that sort of logic .
Thank you again..
PD
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
well I found lot of topics about awk..about if command in awk..
but I had to implement this:
nawk -F"|" '
$47 ~ /0R0011/ { print > ("/home/user/M/MC.tmp" )}
$47 ~ /0R0012/ { print > ("/home/user/M/DuSI.tmp" )}
$47 ~ /0R0014/ { print > ("/home/user/M/FF.tmp" )}
$47 ~ /0R0018/ { print >... (9 Replies)
Discussion started by: abdulaziz
9 Replies
2. Shell Programming and Scripting
Im new to unix and shell scripting. I am required to write a program and im in the process of creating a menu system. I have my main menu but i want to be able to select an option that takes me onto another menu. I have tried doing this with the case statement with no luck so far. Wondering if it... (3 Replies)
Discussion started by: RAFC_99
3 Replies
3. UNIX for Advanced & Expert Users
Hi all,
I would like to ask whether in Unix shell/perl have any functions or command to allow grep/cat/read a file inside compressed .tgz without extract it?
I know we can tar tvf a compressed tgz but this only allow we read the path/filename contained inside the tarball. If we want to read... (3 Replies)
Discussion started by: mayshy
3 Replies
4. Shell Programming and Scripting
echo "please enter ur choice..
1. Make a file.
2. Display contents
3. Copy the file
4. Rename the file
5. Delete the file
6. Exit"
read choice
case $choice in
1 ) echo enter the file name
read fname
if
then
echo... (2 Replies)
Discussion started by: gotam
2 Replies
5. UNIX for Advanced & Expert Users
how to read the text file inside the jar without extracting jar. (3 Replies)
Discussion started by: karthikn
3 Replies
6. Shell Programming and Scripting
i have a case statement which branches to different sections based on an input. Each branch needs to call a function. below is the code. FOr some reason, the code inside the function is not getting executed. the code is below for reference.
in the below code echo "Function 1" which is there... (2 Replies)
Discussion started by: cvsanthosh
2 Replies
7. Shell Programming and Scripting
please let me know if the below code could be written efficiently inside single awk
case "$INP" in
ksh)
cat catalog | awk 'BEGIN {FS=",";} { print $2 } END {}'
;;
pset)
cat catalog | awk 'BEGIN {FS=",";} { print $3 } END {}'
;;
dml)
cat catalog | awk 'BEGIN {FS=",";} {... (2 Replies)
Discussion started by: cvsanthosh
2 Replies
8. Homework & Coursework Questions
I need to Write a shell script that allows some system-administration tasks to be preformed automatically from a menu-driven interface. with automated following tasks:
Copy directory tree
Delete files or directories
Output Information (this part is done )
*Copy directory tree
The “Copy... (2 Replies)
Discussion started by: femchi
2 Replies
9. Shell Programming and Scripting
Hi,
I am reading file records inside a while loop,
and want to update the record when certain condition is met.
How can I update a file while being read?
I want to avoid using temporary files, copy, rename, ...
while IFS=',' read -r f1 f2
do
function(f1,f2)
if
then
<add... (1 Reply)
Discussion started by: ysrini
1 Replies
10. Shell Programming and Scripting
Hello,
I have a problem. I want to launch a different sql queries for different shell parameter values, something like this.
#/bin/bash
case $1 in
"A")
sqlplus -s user/pass << SQL
query A;
SQL
"B") sqlplus -s user/pass << SQL2
... (3 Replies)
Discussion started by: Vares
3 Replies
LEARN ABOUT PHP
pg_prepare
PG_PREPARE(3) PG_PREPARE(3)
pg_prepare - Submits a request to create a prepared statement with the given parameters, and waits for completion.
SYNOPSIS
resource pg_prepare ([resource $connection], string $stmtname, string $query)
DESCRIPTION
pg_prepare(3) creates a prepared statement for later execution with pg_execute(3) or pg_send_execute(3). This feature allows commands that
will be used repeatedly to be parsed and planned just once, rather than each time they are executed. pg_prepare(3) is supported only
against PostgreSQL 7.4 or higher connections; it will fail when using earlier versions.
The function creates a prepared statement named $stmtname from the $query string, which must contain a single SQL command. $stmtname may
be "" to create an unnamed statement, in which case any pre-existing unnamed statement is automatically replaced; otherwise it is an error
if the statement name is already defined in the current session. If any parameters are used, they are referred to in the $query as $1, $2,
etc.
Prepared statements for use with pg_prepare(3) can also be created by executing SQL PREPARE statements. (But pg_prepare(3) is more flexi-
ble since it does not require parameter types to be pre-specified.) Also, although there is no PHP function for deleting a prepared state-
ment, the SQL DEALLOCATE statement can be used for that purpose.
PARAMETERS
o $connection
- PostgreSQL database connection resource. When $connection is not present, the default connection is used. The default connection
is the last connection made by pg_connect(3) or pg_pconnect(3).
o $stmtname
- The name to give the prepared statement. Must be unique per-connection. If "" is specified, then an unnamed statement is cre-
ated, overwriting any previously defined unnamed statement.
o $query
- The parameterized SQL statement. Must contain only a single statement. (multiple statements separated by semi-colons are not
allowed.) If any parameters are used, they are referred to as $1, $2, etc.
RETURN VALUES
A query result resource on success or FALSE on failure.
EXAMPLES
Example #1
Using pg_prepare(3)
<?php
// Connect to a database named "mary"
$dbconn = pg_connect("dbname=mary");
// Prepare a query for execution
$result = pg_prepare($dbconn, "my_query", 'SELECT * FROM shops WHERE name = $1');
// Execute the prepared query. Note that it is not necessary to escape
// the string "Joe's Widgets" in any way
$result = pg_execute($dbconn, "my_query", array("Joe's Widgets"));
// Execute the same prepared query, this time with a different parameter
$result = pg_execute($dbconn, "my_query", array("Clothes Clothes Clothes"));
?>
SEE ALSO
pg_execute(3), pg_send_execute(3).
PHP Documentation Group PG_PREPARE(3)