ODBC_PROCEDURECOLUMNS(3) 1 ODBC_PROCEDURECOLUMNS(3)odbc_procedurecolumns - Retrieve information about parameters to proceduresSYNOPSIS
resource odbc_procedurecolumns (resource $connection_id)
DESCRIPTION
resource odbc_procedurecolumns (resource $connection_id, string $qualifier, string $owner, string $proc, string $column)
Retrieve information about parameters to procedures.
PARAMETERS
o $connection_id
-The ODBC connection identifier, see odbc_connect(3) for details.
o $qualifier
- The qualifier.
o $owner
- The owner. This parameter accepts the following search patterns: "%" to match zero or more characters, and "_" to match a single
character.
o $proc
- The proc. This parameter accepts the following search patterns: "%" to match zero or more characters, and "_" to match a single
character.
o $column
- The column. This parameter accepts the following search patterns: "%" to match zero or more characters, and "_" to match a sin-
gle character.
RETURN VALUES
Returns the list of input and output parameters, as well as the columns that make up the result set for the specified procedures. Returns
an ODBC result identifier or FALSE on failure.
The result set has the following columns:
oPROCEDURE_QUALIFIER
oPROCEDURE_OWNER
oPROCEDURE_NAME
oCOLUMN_NAME
oCOLUMN_TYPE
oDATA_TYPE
oTYPE_NAME
oPRECISION
oLENGTH
oSCALE
oRADIX
oNULLABLE
oREMARKS
The result set is ordered by PROCEDURE_QUALIFIER, PROCEDURE_OWNER, PROCEDURE_NAME and COLUMN_TYPE.
PHP Documentation Group ODBC_PROCEDURECOLUMNS(3)
Check Out this Related Man Page
ODBC_PREPARE(3) 1 ODBC_PREPARE(3)odbc_prepare - Prepares a statement for executionSYNOPSIS
resource odbc_prepare (resource $connection_id, string $query_string)
DESCRIPTION
Prepares a statement for execution. The result identifier can be used later to execute the statement with odbc_execute(3).
Some databases (such as IBM DB2, MS SQL Server, and Oracle) support stored procedures that accept parameters of type IN, INOUT, and OUT as
defined by the ODBC specification. However, the Unified ODBC driver currently only supports parameters of type IN to stored procedures.
PARAMETERS
o $connection_id
-The ODBC connection identifier, see odbc_connect(3) for details.
o $query_string
- The query string statement being prepared.
RETURN VALUES
Returns an ODBC result identifier if the SQL command was prepared successfully. Returns FALSE on error.
EXAMPLES
Example #1
odbc_execute(3) and odbc_prepare(3) example
In the following code, $success will only be TRUE if all three parameters to myproc are IN parameters:
<?php
$a = 1;
$b = 2;
$c = 3;
$stmt = odbc_prepare($conn, 'CALL myproc(?,?,?)');
$success = odbc_execute($stmt, array($a, $b, $c));
?>
If you need to call a stored procedure using INOUT or OUT parameters, the recommended workaround is to use a native extension for your
database (for example, mssql for MS SQL Server, or oci8 for Oracle).
SEE ALSO odbc_execute(3).
PHP Documentation Group ODBC_PREPARE(3)
Hello friends,
I couldnt connect two search patterns in awk, what i want is to search for two words in a log file;
"+MB)" and "Done"
i use this code
/usr/xpg4/bin/awk '/+MB)/ {gsub("\(","",$5);print int($5)}' mylog.txt
and i get integer part of (123,45MB) in a log file "mylog" with ... (1 Reply)
Hi everyone,
I am trying to retrieve certain log from a big file. The log size can be from 200 - 600 lines. I have 3 search patterns, out of which 2 (first and last lines) search patterns are common for all the transactions but 3rd search pattern (occurs in the middle of transaction) is... (5 Replies)
I have two files. The first containing a header and six columns of data.
Example file 1:
Number SNP ID dbSNP RS ID Chromosome Result_Call Physical Position
787066 SNP_A-8575395 RS6650104 1 NOCALL 564477
786872 SNP_A-8575125 RS10458597 1 AA ... (13 Replies)
Hello,
I'd like to print line if column 5th doesn't match with exm. But to reach there I have to make sure I match single quote.
I'm struggling to match that.
I've input file like:
Warning: Variants 'exm480340' and '5:137534453:G:C' have the same position.
Warning: Variants 'exm480345'... (9 Replies)