When I try to connect to databse from HP box using the following command
sqlplus <username>@<databasename>
I get this error message:
ksh: <database name> : not found
I can connect to the database outside the UNIX box using sqlplus though.
Looks like the problem is the way HP Unix is... (4 Replies)
Hi,
Please let me know if anybody is having a solution handy for the below tasks...
It would be helpful if somebody can resolve my query. I am new to unix and oracle environment and looking for some online reference for completing a task.
Task:
Check if the network drive exists
Check... (0 Replies)
Hello All,
I was just wondering if there is any direct way to access PL/SQL OUT variables from Korn Shell Script.
I could already figure out how to return a single value back from PL/SQL to Shell Script (using bind variable).
But, what if we want to return multiple values?
One option I... (4 Replies)
Hi,
I was trying to access Mysql Server sitting in Linux Box from MS-SQL through linked server concept. I am getting the error as :
"Invalid use of schema and/or catalog for OLE DB provider 'MSDASQL'. A four-part name was supplied, but the provider does not expose the necessary... (0 Replies)
Hi,
Can anyone assist me on how to access a variable in a shell script from another script.
for ex,
Script-1
-------
#! /bin/sh
c=10
Where as, i would like to access the velue of variable c in another script 'Script-2'.
Thankyou to all in advance !! :b:
:b: (2 Replies)
HI all,
How can i access a variable that is
defined in another file as: $$Name= "abhinav;
in my script.
The catch is that it has 2 $s behind it...
Thnaks
---------- Post updated at 10:36 AM ---------- Previous update was at 10:29 AM ----------
the file from which i have to... (0 Replies)
Hi,
Would like to know the purpose and accessing of local variable as in below code snippet:
a=123
( a=321; )
echo "a = $a" #This will print 123
How to access local a variable which is assigned with value 321 ?. .. (3 Replies)
Hi all,
Here is an outline of the problem:
#variable declared at start of script
x=0;
#a function that increments x by 1 every 10 seconds
incrementX(){
increments x every 10 seconds;
}
#i want this to output the value of x every second. The problem is that x is always reported... (3 Replies)
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 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)