i have a nested if statement. i need to check for a condition (highlighted in red below). if condition is true, i need the if statement to break out of the statement and then return to the if statement section i have highlighted in blue.
Can some one point this UNIX newbie to a web site or directions on the steps needed to break a mirror in HP-UNIX to change a bad hard drive. (4 Replies)
Hi ,
I am running this script ( pasting only error code ) to generate some ddl definition for tables . But what I want is to break out of the db2look part when the base_table is not like DIM_$TN or FACT_$TN . After this it should come back to while loop to read the next TN . I read the other... (3 Replies)
Hi,
I have a file that looks like this - lets call it fileA
>hhm2
IIIIIIIIILLLLLLLMMMMMMMMMNNNNNNNNNNGGGGGGHHHHHHHH
>hhm4
OOOOOKKKKKKKKMMMMMHHHHHLLLLLLLLWWWWWWWWWWW
>hhm9
OOOOOOOIIIIIIIIIKKKKKKKKKMMMMMHHHHHHHHHHHLLLLLLLLLL
So the file is pretty straight forward. The name is indicated... (2 Replies)
Hey,
I have to take one CSV file and break into more files. Let's I have a file prices.csv and the data in the file like
1,12345
1,34567
1,23456
2,67890
2,77720
2,44556
2,55668
10,44996
based on the first column, I want to create files. in this example 1 is repeated three times... (12 Replies)
I have a main script with while loop having for loop inside. Again in for loop based on if condition few functions will be called. So when a function is called for certain condition it should come out from the main for loop and should continue with while loop.
Let me explain with example here:
I... (6 Replies)
Here's my code -
for File in "${Files}"; do
uuencode "${File}" "$(basename ${File} 2>&-)" 2>&-;
done | mailx -s "subject" "a@b.c"
Now I want to know if there a way to *not* send an email if the "Files" variables turns out to be blank. Any suggestions?
Also, just to clarify, I... (4 Replies)
Hi folks,
I have a scenario to convert the update statements into insert statements using shell script (awk, sed...) or in database using regex.
I have a bunch of update statements with all columns in a file which I need to convert into insert statements.
UPDATE TABLE_A SET COL1=1 WHERE... (0 Replies)
Discussion started by: dev123
0 Replies
LEARN ABOUT PHP
db2_num_rows
DB2_NUM_ROWS(3) 1 DB2_NUM_ROWS(3)db2_num_rows - Returns the number of rows affected by an SQL statementSYNOPSIS
int db2_num_rows (resource $stmt)
DESCRIPTION
Returns the number of rows deleted, inserted, or updated by an SQL statement.
To determine the number of rows that will be returned by a SELECT statement, issue SELECT COUNT(*) with the same predicates as your
intended SELECT statement and retrieve the value.
If your application logic checks the number of rows returned by a SELECT statement and branches if the number of rows is 0, consider modi-
fying your application to attempt to return the first row with one of db2_fetch_assoc(3), db2_fetch_both(3), db2_fetch_array(3), or
db2_fetch_row(3), and branch if the fetch function returns FALSE.
Note
If you issue a SELECT statement using a scrollable cursor, db2_num_rows(3) returns the number of rows returned by the SELECT state-
ment. However, the overhead associated with scrollable cursors significantly degrades the performance of your application, so if
this is the only reason you are considering using scrollable cursors, you should use a forward-only cursor and either call SELECT
COUNT(*) or rely on the boolean return value of the fetch functions to achieve the equivalent functionality with much better perfor-
mance.
PARAMETERS
o $stmt
- A valid stmt resource containing a result set.
RETURN VALUES
Returns the number of rows affected by the last SQL statement issued by the specified statement handle.
PHP Documentation Group DB2_NUM_ROWS(3)