Hi All,
I want to connect two tables in DB2 using shell script and then compare the contents of two tables field by field. Could any one please help me in connecting database tables using Unix and retriving data from the same.
Thanks,
Durwas (0 Replies)
Can anyone please help me with an unix shell script to connect a DB2 database. My requirement is just to display the no of records present in a table of a DB2 database through Unix Shell script. Thx - Ram (1 Reply)
i have a file tabel.out which contain table name in this format.
xyz
abc
qwe
Plz help me writing one script which actually takes tablename from file table.out file one by one and then select count (*) from $tablename limit 10; and print error in output file if any tabel is not... (4 Replies)
Hello,
Objective is to insert bulk values in DB table using isql.
Following code tried:
isql -SServer_name -Ddb_name -Uuser_name -Ppassword < file.txt
cat file.txt
for i in `cat data_value_file.txt`
do
insert into tempdb..temp_table11 values ('$i')
go
done
cat... (3 Replies)
Hi,
I want to replace a chain of if-else statement in an old AWK file with values from Db2 table or CSV file. The part of code is below...
if (start_new_rec=="true"){
exclude_user="false";
user=toupper($6);
match(user, "XXXXX.");
if (RSTART ==2 ) {
... (9 Replies)
Dear team
I am using DB2 and wish to capture the ETL status on daily basis so that i can run the query and share the details in xls format to respective mail ids .
Currently i am using below query but this displays table name and counts for latest run.
select name ,CARD from... (0 Replies)
HI team
Is it possible to track DB2 table on the data insertion,deletion and updates on daily basis . Do we have any inbuilt feature to handle audit analysis ?
Any help appreciated (1 Reply)
Team
I have files in different directories . How can i take the count of latest file and insert into Db2 table .
I am using
awk 'END{print NR+1-ARGC}' (File name)
to get the counts.
How can i take
1.The count of latest file
2.Insert into Db2 table( File Name and Counts) .
cd... (4 Replies)
Dear Team
I am using DB2 v10 z/os database . Need expert guidance to figure out best way to track table activities ( Ex Delete, Insert,Update )
Scenario
We have a table which is critical and many developer/testing team access on daily basis . We had instance where some deleted... (1 Reply)
Dear Team
I am using DB2 v10 z/os database . Need expert guidance to figure out best way to track table activities ( Ex Delete, Insert,Update )
Scenario
We have a table which is critical and many developer/testing team access on daily basis . We had instance where some deleted entire table .... (1 Reply)
Discussion started by: Perlbaby
1 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 databaseSYNOPSIS
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)