10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi, I am new to shell scripting and Sybase database i need a help that i try to execute a SYBASE stored procedure from a Unix shell script and wanna write the output of the SP into a Text File.somehow i try to find a solution but whwn i try to run the script i am not getting the output file with... (1 Reply)
Discussion started by: Arun619
1 Replies
2. Post Here to Contact Site Administrators and Moderators
Hi, I am new to shell scripting and Sybase database i need a help that i try to execute a SYBASE stored procedure from a Unix shell script and wanna write the output of the SP into a Text File, somehow i tried to find a solution but when i try to run the script i am not getting the output file with... (1 Reply)
Discussion started by: Arun619
1 Replies
3. Shell Programming and Scripting
Greeting everyone. Ok, I have spent the past few days googling for this and I keep hitting a wall. Many results brought me here, but the solutions were not quite right for this.
Basically my script (ksh) is run with an arg for a csv. My script so far appears to be storing the values from my... (4 Replies)
Discussion started by: dezdiggler
4 Replies
4. Shell Programming and Scripting
Hi All,
I am connecting to Oracle DB from UNIX script. Want to capture all dates between start date and end date and store them in file. Once this is done, want to read dates one by one. How to achive this in UNIX and Oracle? Please let me know if you have any idea on the same.
Thanks and... (4 Replies)
Discussion started by: Nagaraja Akkiva
4 Replies
5. Shell Programming and Scripting
Hi,
I am writing a script that needs to call a stored proc which would update a column in a table based on a condition.
I need to also capture the number of rows updated.
However, When I execute the script I keep getting this error:
./test_isql.sh: syntax error at line 33: `end of file'... (3 Replies)
Discussion started by: karthikk
3 Replies
6. Shell Programming and Scripting
Greetings,
I need to make an open server call to a shell script from inside a Sybase Stored procedure.
Coul any one please provide a sample code?
TIA (0 Replies)
Discussion started by: rajpreetsidhu
0 Replies
7. UNIX for Advanced & Expert Users
hi all
is there any way to capture the segmentation fault error when i run sqsh on a unix shell script.
Ex:
#!/bin/ksh
sqsh -S "server" -U "user" -P "pwd" << EOF
use mydb
go
exec proc1
go
exit
EOF
retval=$?
echo "sqsh return value $retval"
if
then
exit (1 Reply)
Discussion started by: sudheer1984
1 Replies
8. Shell Programming and Scripting
hi fndz.
Can you please help me with the code if I call a stored procedure from my shell script and stored procedure returns a cursor,
cursor output should be saved to a file (3 Replies)
Discussion started by: enigma_83
3 Replies
9. UNIX for Advanced & Expert Users
Hi All,
I want to run/execute a stored procedure (sybase) from unix command prompt not by login in isql utility which is provided my Sybase guys.
Is there way ..?
Thanks in advance for your help !!!
Regards,
Arvind S. (0 Replies)
Discussion started by: arvindcgi
0 Replies
10. UNIX for Dummies Questions & Answers
Hi All,
Want to know if is it possible to run / execute any stored procedures (sybase) from unix command prompt.?
Thanks for your help in Advance.
Regards,
Arvind S. (0 Replies)
Discussion started by: Arvind_temp
0 Replies
DB2_PROCEDURE_COLUMNS(3) 1 DB2_PROCEDURE_COLUMNS(3)
db2_procedure_columns - Returns a result set listing stored procedure parameters
SYNOPSIS
resource db2_procedure_columns (resource $connection, string $qualifier, string $schema, string $procedure, string $parameter)
DESCRIPTION
Returns a result set listing the parameters for one or more stored procedures.
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.
o $parameter
- The name of the parameter. This parameter accepts a search pattern containing _ and % as wildcards. If this parameter is NULL,
all parameters for the specified stored procedures are returned.
RETURN VALUES
Returns a statement resource with a result set containing rows describing the parameters for 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. |
| | |
| COLUMN_NAME | |
| | |
| | Name of the parameter. |
| | |
| COLUMN_TYPE | |
| | |
| | An integer value representing the type of the |
| | parameter: |
| | |
| | box, tab (|); c | c | . T{ Return value |
| | |
| | Parameter type |
| | |
+---------------------------+---------------------------------------------------+
| 1 (SQL_PARAM_INPUT) | |
| | |
| | Input (IN) parameter. |
| | |
|2 (SQL_PARAM_INPUT_OUTPUT) | |
| | |
| | Input/output (INOUT) parameter. |
| | |
| 3 (SQL_PARAM_OUTPUT) | |
| | |
| | Output (OUT) parameter. |
| | |
+---------------------------+---------------------------------------------------+
T} T{ DATA_TYPE
T} |T{ The SQL data type for the parameter represented as an integer value.
T} T{ TYPE_NAME
T} |T{ A string representing the data type for the parameter.
T} T{ COLUMN_SIZE
T} |T{ An integer value representing the size of the parameter.
T} T{ BUFFER_LENGTH
T} |T{
Maximum number of bytes necessary to store data for this parameter.
T} T{ DECIMAL_DIGITS
T} |T{
The scale of the parameter, or NULL where scale is not applicable.
T} T{ NUM_PREC_RADIX
T} |T{
An integer value of either 10 (representing an exact numeric data type), 2 (representing an approximate numeric data type), or NULL (rep-
resenting a data type for which radix is not applicable).
T} T{ NULLABLE
T} |T{ An integer value representing whether the parameter is nullable or not.
T} T{ REMARKS
T} |T{ Description of the parameter.
T} T{ COLUMN_DEF
T} |T{ Default value for the parameter.
T} T{ SQL_DATA_TYPE
T} |T{ An integer value representing the size of the parameter.
T} T{ SQL_DATETIME_SUB
T} |T{
Returns an integer value representing a datetime subtype code, or NULL for SQL data types to which this does not apply.
T} T{ CHAR_OCTET_LENGTH
T} |T{
Maximum length in octets for a character data type parameter, which matches COLUMN_SIZE for single-byte character set data, or NULL for
non-character data types.
T} T{ ORDINAL_POSITION
T} |T{ The 1-indexed position of the parameter in the CALL statement.
T} T{ IS_NULLABLE
T} |T{
A string value where 'YES' means that the parameter accepts or returns NULL values and 'NO' means that the parameter does not accept or
return NULL values.
T}
SEE ALSO
db2_column_privileges(3), db2_columns(3), db2_foreign_keys(3), db2_primary_keys(3), db2_procedures(3), db2_special_columns(3), db2_statis-
tics(3), db2_table_privileges(3), db2_tables(3).
PHP Documentation Group DB2_PROCEDURE_COLUMNS(3)