Hi,
I am trying to capture the values of a column in a parameter..here is what I wanted to do...
1,2,3,4
2,3,4,1
3,4,1,2
4,1,2,3
is there any way that I could get the values of column values into one parameter??
Here is what I want...
COL1=1,2,3,4
COL2=2,3,4,1
... (5 Replies)
Hi,
I will pass 3 parameters for a script.I have to check the file name and create a new file name with time stamp.
the parameters which i'm passing are
/dir/stg/filename.txt
/dir/path/head.txt
/dir/path/tail.txt
Now i have to check filename like :
if it is a.txt i have to create... (2 Replies)
Hi All
Need to find kernel parameter values of our UNIX box.
/filesys1/tmp>uname -a
HP-UX hps1_dc B.11.11 U 9000/800 1681349356 unlimited-user license
/filesys1/CDBLprodrun/tmp>
Can anyone help me with the cmd to find kernel parameter values?
Thanks in advance. (1 Reply)
I am making a shell script that will display memory, disk space and CPU utilization at periodic intervals. I am planning to use free, df -h and mpstat commands and then parse them to extract the values. Can someone give me idea if I am using the correct command. I am interested to display overall... (2 Replies)
Hi,
I am writing a shell program that executes a lot of Oracle SQL Files on different databases based on the enviroment setting value. I am trying to design a parameter file where i can store the environment values for all the databases in the below format
Environment File
File Name... (6 Replies)
Hi,
I am just new to this shell scripting wizard..i have a text file which contains content as below:
Parameter=10;
What should be the script which only fetches the value 10 not the Parameter.
The idea is to get the logic behind getting the value alone not its parameter,.... (6 Replies)
Hi,
I have problem with parameter configuration.
My question is after the configuration, how to check if successfully change the value or not?
I saw someone has the same question, and followed his steps.
Original thread:... (3 Replies)
i am passing input parameter 'one_two' to the script , the script output should display the result as below
one_1two
one_2two
one_3two
if
then
echo " Usage : <$0> <DATABASE> "
exit 0
else
for DB in 1 2 3
do
DBname=`$DATABASE | awk -F "_" '{print $1_${DB}_$2}`
done
fi (5 Replies)
Hello Everyone!
I have updated the first post so that my intentions are easier to understand, and also attached sample files (post #18).
I have over 500 text files in a directory. Over 1 GB of data. The data in those files is organised in lines:
My intention is to return one line per... (23 Replies)
Hi.
How do I achieve this
sh /EDWH-DMT02/script/MISC/exec_sql.sh "@/EDWH-DMT02/script/others/CSM_CKC/Complete_List.sql ${file_name}" Complete_List.txt
The /EDWH-DMT02/script/MISC/exec_sql.sh has two parameters and it's working fine with this
sh /EDWH-DMT02/script/MISC/exec_sql.sh... (7 Replies)
Discussion started by: aimy
7 Replies
LEARN ABOUT PHP
maxdb_stmt_execute
MAXDB_STMT_EXECUTE(3) 1 MAXDB_STMT_EXECUTE(3)maxdb_stmt_execute - Executes a prepared Query
Procedural style
SYNOPSIS
bool maxdb_stmt_execute (resource $stmt)
DESCRIPTION
Object oriented style
bool maxdb_stmt::execute (void )
The maxdb_stmt_execute(3) function executes a query that has been previously prepared using the maxdb_prepare(3) function represented by
the $stmt resource. When executed any parameter markers which exist will automatically be replaced with the appropiate data.
If the statement is UPDATE, DELETE, or INSERT, the total number of affected rows can be determined by using the
maxdb_stmt_affected_rows(3) function. Likewise, if the query yields a result set the maxdb_fetch(3) function is used.
Note
When using maxdb_stmt_execute(3), the maxdb_fetch(3) function must be used to fetch the data prior to preforming any additional
queries.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Object oriented style
<?php
$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
$maxdb->query("CREATE TABLE temp.mycity LIKE hotel.city");
/* Prepare an insert statement */
$query = "INSERT INTO temp.mycity (zip, name, state) VALUES (?,?,?)";
$stmt = $maxdb->prepare($query);
$stmt->bind_param("sss", $val1, $val2, $val3);
$val1 = '11111';
$val2 = 'Georgetown';
$val3 = 'NY';
/* Execute the statement */
$stmt->execute();
$val1 = '22222';
$val2 = 'Hubbatown';
$val3 = 'CA';
/* Execute the statement */
$stmt->execute();
/* close statement */
$stmt->close();
/* retrieve all rows from myCity */
$query = "SELECT zip, name, state FROM temp.mycity";
if ($result = $maxdb->query($query)) {
while ($row = $result->fetch_row()) {
printf("%s (%s,%s)
", $row[0], $row[1], $row[2]);
}
/* free result set */
$result->close();
}
/* remove table */
$maxdb->query("DROP TABLE temp.mycity");
/* close connection */
$maxdb->close();
?>
Example #2
Procedural style
<?php
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
maxdb_query($link, "CREATE TABLE temp.mycity LIKE hotel.city");
/* Prepare an insert statement */
$query = "INSERT INTO temp.mycity (zip, name, state) VALUES (?,?,?)";
$stmt = maxdb_prepare($link, $query);
maxdb_stmt_bind_param($stmt, "sss", $val1, $val2, $val3);
$val1 = '11111';
$val2 = 'Georgetown';
$val3 = 'NY';
/* Execute the statement */
maxdb_stmt_execute($stmt);
$val1 = '22222';
$val2 = 'Hubbatown';
$val3 = 'CA';
/* Execute the statement */
maxdb_stmt_execute($stmt);
/* close statement */
maxdb_stmt_close($stmt);
/* retrieve all rows from myCity */
$query = "SELECT zip, name, state FROM temp.mycity";
if ($result = maxdb_query($link, $query)) {
while ($row = maxdb_fetch_row($result)) {
printf("%s (%s,%s)
", $row[0], $row[1], $row[2]);
}
/* free result set */
maxdb_free_result($result);
}
/* remove table */
maxdb_query($link, "DROP TABLE temp.mycity");
/* close connection */
maxdb_close($link);
?>
The above example will output something similar to:
11111 (Georgetown,NY)
22222 (Hubbatown,CA)
SEE ALSO maxdb_prepare(3), maxdb_stmt_bind_param(3).
PHP Documentation Group MAXDB_STMT_EXECUTE(3)