5 More Discussions You Might Find Interesting
1. Web Development
Hi all,
I am studying PHP and MySQL and I have landed to use this book "Web Database Applications with PHP and MYSQL". I could see it has all I need (based on my limited experience on the subject and my requirements) to quickly learn how to build such applications as a web store, or any... (0 Replies)
Discussion started by: faizlo
0 Replies
2. UNIX for Dummies Questions & Answers
Hi there,
I have a problem in my script,
I need to check whether file exists in remote server or not,
if the file exists, then stop copy
else copy the file to the server..
my code is something like this
while read $server
do
if ssh $server "cd $directory_name; if ; then echo "Error:... (2 Replies)
Discussion started by: beezy
2 Replies
3. Solaris
Hello,
I need to install a Jboss AS 4.2 asap. But I dont want to use the GUI. I need to install a solaris 10 server with the minimal packages but I dont know how deep I should customize and select the packages.
You guys , how you decide to select a package installation level ? Each server's... (7 Replies)
Discussion started by: shadowfaxxxx
7 Replies
4. Shell Programming and Scripting
Dear friends,
:) I need your help again. This time I have written 2 scripts i.e. A.sh & B.sh and both of them takes “serial no” as input. Both the scripts are exactly same except one thing, both are pointing to different tables.
Now I want to write another script that will decide whether to... (4 Replies)
Discussion started by: anushree.a
4 Replies
5. UNIX for Dummies Questions & Answers
I've got an old laptop and i want to try unix on it, but i'm a unix newbie, so i don't know what i have to choose.
We're talking about a laptop with an intel 80C386SX-20 CPU in it, with 2 MB Ram and 40 MB harddisk. Not really powerfull specs.
Is it possible to install a unix version on it. Or... (8 Replies)
Discussion started by: rolfvandekrol
8 Replies
LEARN ABOUT PHP
db2_procedures
DB2_PROCEDURES(3) 1 DB2_PROCEDURES(3)
db2_procedures - Returns a result set listing the stored procedures registered in a database
SYNOPSIS
resource db2_procedures (resource $connection, string $qualifier, string $schema, string $procedure)
DESCRIPTION
Returns a result set listing the stored procedures registered in a database.
PARAMETERS
o $connection
- A valid connection to an IBM DB2, Cloudscape, or Apache Derby database.
o $qualifier
- A qualifier for DB2 databases running on OS/390 or z/OS servers. For other databases, pass NULL or an empty string.
o $schema
- The schema which contains the procedures. This parameter accepts a search pattern containing _ and % as wildcards.
o $procedure
- The name of the procedure. This parameter accepts a search pattern containing _ and % as wildcards.
RETURN VALUES
Returns a statement resource with a result set containing rows describing the stored procedures matching the specified parameters. The
rows are composed of the following columns:
+------------------+---------------------------------------------------+
| Column name | |
| | |
| | Description |
| | |
+------------------+---------------------------------------------------+
| PROCEDURE_CAT | |
| | |
| | The catalog that contains the procedure. The |
| | value is NULL if this table does not have cata- |
| | logs. |
| | |
| PROCEDURE_SCHEM | |
| | |
| | Name of the schema that contains the stored pro- |
| | cedure. |
| | |
| PROCEDURE_NAME | |
| | |
| | Name of the procedure. |
| | |
|NUM_INPUT_PARAMS | |
| | |
| | Number of input (IN) parameters for the stored |
| | procedure. |
| | |
|NUM_OUTPUT_PARAMS | |
| | |
| | Number of output (OUT) parameters for the stored |
| | procedure. |
| | |
| NUM_RESULT_SETS | |
| | |
| | Number of result sets returned by the stored pro- |
| | cedure. |
| | |
| REMARKS | |
| | |
| | Any comments about the stored procedure. |
| | |
| PROCEDURE_TYPE | |
| | |
| | Always returns 1, indicating that the stored pro- |
| | cedure does not return a return value. |
| | |
+------------------+---------------------------------------------------+
SEE ALSO
db2_column_privileges(3), db2_columns(3), db2_foreign_keys(3), db2_primary_keys(3), db2_procedure_columns(3), db2_special_columns(3),
db2_statistics(3), db2_table_privileges(3), db2_tables(3).
PHP Documentation Group DB2_PROCEDURES(3)