08-15-2007
Print-outs in END
Hi!
Thank You for answering.
I need to do the print-out in the END-statement, when NR is already at the last row.
This is because my lineNr-array is quite large and every number is the begining of a group of rows that I need to print out.
So if the array is: "120,140,166,178, ..." , I would need to decide in END how many stanzas that will be printed to a file. After that, I will take the next group of stanzas and print them to a new file.
So is it possibe to do something like:
"set NR=list[i]; print"
//Bugenhagen
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a text file made of different blocks separated by blank lines. I need to print the blocks with odd indexes. How can I get it with awk?
For example i need to print the first and the third block of a file like this:
asgdg sadsd ssgsdgd
ass uff fedd sddddso
ieeduydd dddee deeo
ssancnc... (4 Replies)
Discussion started by: littleboyblu
4 Replies
2. Shell Programming and Scripting
I need to print specific lines from a file, say 2-5, 8, 12-15, 17, 19, 21-27. How do I achieve this? (2 Replies)
Discussion started by: Ilja
2 Replies
3. Shell Programming and Scripting
abc.dat
tty cpu
tin tout us sy wt id
0 0 7 3 19 71
extended device statistics
r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device
0.0 133.2 0.0 682.9 0.0 1.0 0.0 7.2 0 79 c1t0d0
0.2 180.4 0.1 5471.2 3.0 2.8 16.4 15.6 15 52 aaaaaa1-xx
I want to skip first 5 line... (4 Replies)
Discussion started by: kchinnam
4 Replies
4. Shell Programming and Scripting
Could someone please point me in the right direction with the following?
I have a program that generates logs that contains sections like this:
IMAGE INPUT
81 0 0.995 2449470 0 1726 368 1 0.0635 0.3291
82 0 1.001 2448013 0 1666 365 1 0.0649 ... (4 Replies)
Discussion started by: euval
4 Replies
5. Shell Programming and Scripting
Hi all
I have data like this:
model: 1, misfit value: 0.74987
1 1.182 1.735 2.056 1.867
2 0.503 1.843 2.018 1.888
3 2.706 2.952 2.979 1.882
4 8.015 3.414 3.675 1.874
... (1 Reply)
Discussion started by: fedora2011
1 Replies
6. Shell Programming and Scripting
Hello all,
I have thousand file input like this:
file1:
$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$
$$ | | | |$$
$$ UERT | TTYH | TAFE | FRFG |$$
$$______|______|________|______|$$
$$ | | | |$$
$$ 1 | DISK | TR1311 | 1 |$$
$$ 1 |... (4 Replies)
Discussion started by: attila
4 Replies
7. Shell Programming and Scripting
Hi,
Please have a look on below records.
STG_HCM_STATE_DIS_TAX_TBL.1207.Xfm: The value of the row is: EMPLID = 220677 COMPANY = 919 BALANCE_ID = 0 BALANCE_YEAR = 2012
STG_HCM_STATE_DIS_TAX_TBL.1207.Xfm: ORA-00001: unique constraint (SYSADM.PS_TAX_BALANCE) violated
... (4 Replies)
Discussion started by: Sachin Lakka
4 Replies
8. Shell Programming and Scripting
Hello,
i need help with awk.
I have this file:
cat number
DirB port 67 er_enc_out 0 er_bad_os 0
DirB port 71 er_enc_out 56 er_bad_os 0
DirB port 74 er_enc_out 0 er_bad_os 0
DirB port 75 ... (4 Replies)
Discussion started by: elilmal
4 Replies
9. Shell Programming and Scripting
I need to print specific lines 5,100,67,123 in a file.
file name: today.csv (3 Replies)
Discussion started by: ramkumar15
3 Replies
10. UNIX for Beginners Questions & Answers
Hi, I need to print lines which are matching with start pattern "SELECT" and END PATTERN ";" and only select the last "select" statement including the ";" .
I have attached sample input file and the desired input should be as:
INPUT FORMAT:
SELECT
ABCD,
DEFGH,
DFGHJ,
JKLMN,
AXCVB,... (5 Replies)
Discussion started by: nani2019
5 Replies
LEARN ABOUT PHP
db2_next_result
DB2_NEXT_RESULT(3) 1 DB2_NEXT_RESULT(3)
db2_next_result - Requests the next result set from a stored procedure
SYNOPSIS
resource db2_next_result (resource $stmt)
DESCRIPTION
A stored procedure can return zero or more result sets. While you handle the first result set in exactly the same way you would handle the
results returned by a simple SELECT statement, to fetch the second and subsequent result sets from a stored procedure you must call the
db2_next_result(3) function and return the result to a uniquely named PHP variable.
PARAMETERS
o $stmt
- A prepared statement returned from db2_exec(3) or db2_execute(3).
RETURN VALUES
Returns a new statement resource containing the next result set if the stored procedure returned another result set. Returns FALSE if the
stored procedure did not return another result set.
EXAMPLES
Example #1
Calling a stored procedure that returns multiple result sets
In the following example, we call a stored procedure that returns three result sets. The first result set is fetched directly from
the same statement resource on which we invoked the CALL statement, while the second and third result sets are fetched from state-
ment resources returned from our calls to the db2_next_result(3) function.
<?php
$conn = db2_connect($database, $user, $password);
if ($conn) {
$stmt = db2_exec($conn, 'CALL multiResults()');
print "Fetching first result set
";
while ($row = db2_fetch_array($stmt)) {
var_dump($row);
}
print "
Fetching second result set
";
$res = db2_next_result($stmt);
if ($res) {
while ($row = db2_fetch_array($res)) {
var_dump($row);
}
}
print "
Fetching third result set
";
$res2 = db2_next_result($stmt);
if ($res2) {
while ($row = db2_fetch_array($res2)) {
var_dump($row);
}
}
db2_close($conn);
}
?>
The above example will output:
Fetching first result set
array(2) {
[0]=>
string(16) "Bubbles "
[1]=>
int(3)
}
array(2) {
[0]=>
string(16) "Gizmo "
[1]=>
int(4)
}
Fetching second result set
array(4) {
[0]=>
string(16) "Sweater "
[1]=>
int(6)
[2]=>
string(5) "llama"
[3]=>
string(6) "150.00"
}
array(4) {
[0]=>
string(16) "Smarty "
[1]=>
int(2)
[2]=>
string(5) "horse"
[3]=>
string(6) "350.00"
}
Fetching third result set
array(1) {
[0]=>
string(16) "Bubbles "
}
array(1) {
[0]=>
string(16) "Gizmo "
}
PHP Documentation Group DB2_NEXT_RESULT(3)