10-15-2012
That's not the requirement you gave first , post a clear input file and the expected output.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello,
I'm trying to make a script which reads the PID of a process using awk. I've read the thread in this forum where it is explained.
However, the problem i'm having is when attributing that PID value to a variable.
I'm using AIX 5.3.
The command is the following:
:/home/user1>ps -ef |... (2 Replies)
Discussion started by: mambo
2 Replies
2. Shell Programming and Scripting
Hi All-
First time using iSql.
I have 4 query files - some have more than 1 line of sql statements
After a bit of research it appears I can just use the -i command and specify the input file.
Questions:
Does it matter that there are multiple queries in each file? Do I need to have... (3 Replies)
Discussion started by: Cailet
3 Replies
3. Shell Programming and Scripting
I heard this was possible but from my research I haven't been able to figure it out yet. Seems it should be simple enough. Basically from a high level view I'm trying to accomplish...
. $X='grep foo blah.log'
then 'mysql command SELECT foo FROM bar WHERE ' . $X
or something like that.
... (2 Replies)
Discussion started by: kero
2 Replies
4. Shell Programming and Scripting
Dear all,
¿How can i insert a variable in a AWK pattern?
I have almost succeeded in solving a puzzle with AWK but now i want to make a script. Let me explain.
cat file.txt | awk 'BEGIN {RS="\\n\\n"} /tux/ { print "\n"$0 }'
I know that this command makes right what i want to do, but mi... (8 Replies)
Discussion started by: antuan
8 Replies
5. Shell Programming and Scripting
My script contains as follows,
VALUE=`sqlplus un/pwd <<EOF > OB.txt
set pagesize 0 feedback off verify off heading off echo off
select max(1) from table1;
exit;
EOF`
insert into table2 values(1, 'The max value is $value',...);
i need the value of VALUE to be inserted after 'The max... (2 Replies)
Discussion started by: savithavijay
2 Replies
6. Shell Programming and Scripting
Hi,
I'm trying to form an insert sql query using shell programming. I have table named company with four columns 'company name', 'company id', 'company code' and 'last change id'
I have to read the company name, company code and last change id from a file delimited by | which has around 10... (4 Replies)
Discussion started by: rakesh_s
4 Replies
7. Shell Programming and Scripting
Hello. I am writing a simple script that reads a text file and removes records from a mysql database. The items in the text file are of the format:
firstname.middle.lastXXX, where XXX is a 3 digit number. The table has an email field that will match the firstname.middle.last. So, I thought I... (1 Reply)
Discussion started by: bricoleur
1 Replies
8. UNIX for Dummies Questions & Answers
I'm trying to insert a filename into awk.
filename="12345.wmv"
I have tried this:
awk '/$filename/{print $0}' infile
and this:
awk -v fn=$filename '/$fn/{print $0}' infile
How do I insert the variable into awk? (1 Reply)
Discussion started by: locoroco
1 Replies
9. Shell Programming and Scripting
I want to incorporate the variable in the for statement as a column of my processed file. In the INCORRECT example below, it is $i which corresponds to the i in my for loop:
for i in x86_64 i686; do
awk '{ print $1" "$4" "$5" "$i }'awk $file-$i > processed-$i.log
doneThanks! (3 Replies)
Discussion started by: graysky
3 Replies
10. Shell Programming and Scripting
I have a script in which i connect to database to run a query and get the result of the query to a temp file. This works fine , now what i want is there is flat file which contains the value to be used in the query. I want to read this file line by line and then run the query for each value in that... (7 Replies)
Discussion started by: gpk_newbie
7 Replies
LEARN ABOUT PHP
db2_last_insert_id
DB2_LAST_INSERT_ID(3) 1 DB2_LAST_INSERT_ID(3)
db2_last_insert_id - Returns the auto generated ID of the last insert query that successfully executed on this connection
SYNOPSIS
string db2_last_insert_id (resource $resource)
DESCRIPTION
Returns the auto generated ID of the last insert query that successfully executed on this connection.
The result of this function is not affected by any of the following:
o A single row INSERT statement with a VALUES clause for a table without an identity column.
o A multiple row INSERT statement with a VALUES clause.
o An INSERT statement with a fullselect.
o A ROLLBACK TO SAVEPOINT statement.
PARAMETERS
o $resource
- A valid connection resource as returned from db2_connect(3) or db2_pconnect(3). The value of this parameter cannot be a state-
ment resource or result set resource.
RETURN VALUES
Returns the auto generated ID of last insert query that successfully executed on this connection.
EXAMPLES
Example #1
A db2_last_insert_id(3) example
The following example shows how to return the auto generated ID of last insert query that successfully executed on this connection.
<?php
$database = "SAMPLE";
$user = "db2inst1";
$password = "ibmdb2";
$conn = db2_connect($database, $user, $password);
if($conn) {
$createTable = "CREATE TABLE lastInsertID
(id integer GENERATED BY DEFAULT AS IDENTITY, name varchar(20))";
$insertTable = "INSERT INTO lastInsertID (name) VALUES ('Temp Name')";
$stmt = @db2_exec($conn, $createTable);
/* Checking for single row inserted. */
$stmt = db2_exec($conn, $insertTable);
$ret = db2_last_insert_id($conn);
if($ret) {
echo "Last Insert ID is : " . $ret . "
";
} else {
echo "No Last insert ID.
";
}
db2_close($conn);
}
else {
echo "Connection failed.";
}
?>
The above example will output:
Last Insert ID is : 1
PHP Documentation Group DB2_LAST_INSERT_ID(3)