12-17-2003
I was looking to view table in one of my databases. I just found it. It's dbdef, simple enough but my mind went blank this morning!
Thanks!
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
How do I view pdf files on a Solaris 9 environment?
Links and such would be grateful.
"AAAAHHH!! They're everywhere!!!" - Halo Grunt (3 Replies)
Discussion started by: antalexi
3 Replies
2. UNIX for Dummies Questions & Answers
hi all,
how to view crontab entries of user2 logging as user1 (7 Replies)
Discussion started by: matrixmadhan
7 Replies
3. UNIX for Dummies Questions & Answers
I have a file (called CORE) that is a dump created by a crashing process. This file, I believe, is in "binary" form, so when I try to use cat, more, or vi on it, it has a bunch of garbage. Is there anything I can use to "read" or view this file just like I might a non-binary file? I am running... (2 Replies)
Discussion started by: dsimpg1
2 Replies
4. Shell Programming and Scripting
I am trying to transpose tables listed in the format into format. Any help would be greatly appreciated.
Input:
test_data_1
1 2 90%
4 3 91%
5 4 90%
6 5 90%
9 6 90%
test_data_2
3 5 92%
5 4 92%
7 3 93%
9 2 92%
1 1 92%
...
Output:... (7 Replies)
Discussion started by: justthisguy
7 Replies
5. UNIX for Dummies Questions & Answers
I am having trouble viewing these files from my unix session. vi comes back with line too long. Also an m_dump with the relevant dml comes back with problems.
How can I view this as a text file? Also is there an easy way to view specific records within. Eg I have a policy id (4 Replies)
Discussion started by: trek88
4 Replies
6. Shell Programming and Scripting
Hey,
I know the head and tail function is to view like the top or bottom lines for each file. But lets say I want to view the top/bottom 100 or top/bottom 1000 for a file. whats the command that I use to do this?
thanks (2 Replies)
Discussion started by: kylle345
2 Replies
7. UNIX for Dummies Questions & Answers
Sometime I have to deal with very large log files and I cannot view them for analysis using more or vi. The attempts to open the files error out saying there is not enough memory.
Is there any tool or method with which I can go through huge files? (2 Replies)
Discussion started by: rcchume
2 Replies
8. Shell Programming and Scripting
I have a file name as logfiles_tar.tgz. How can I view the contents of the log files present in logfiles_tar.tgz ? Any help would be really appreciated.
Thanks (3 Replies)
Discussion started by: bobby1015
3 Replies
9. Tips and Tutorials
Hi,
I have a directory, and there is a job running and constantly writes and removes files from and to this directory.
I would like to see somehow these changes without pressing `ls` every second. Kind of `tail -f` command, but for a directory list and not for file content.
I thought maybe kind... (5 Replies)
Discussion started by: ilya_dv
5 Replies
10. Emergency UNIX and Linux Support
Hello All,
I have issues in unix file when I loaded that to database and do select * from table where description like '%'+char(13)+'%' on it I am able to get records. I tried to view the file in unix it is all having blank character which I think is all non ascii which I am not able view.... (11 Replies)
Discussion started by: arunkumar_mca
11 Replies
LEARN ABOUT PHP
db2_foreign_keys
DB2_FOREIGN_KEYS(3) 1 DB2_FOREIGN_KEYS(3)
db2_foreign_keys - Returns a result set listing the foreign keys for a table
SYNOPSIS
resource db2_foreign_keys (resource $connection, string $qualifier, string $schema, string $table-name)
DESCRIPTION
Returns a result set listing the foreign keys for a table.
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 tables. If $schema is NULL, db2_foreign_keys(3) matches the schema for the current connection.
o $table-name
- The name of the table.
RETURN VALUES
Returns a statement resource with a result set containing rows describing the foreign keys for the specified table. The result set is com-
posed of the following columns:
+--------------+---------------------------------------------------+
| Column name | |
| | |
| | Description |
| | |
+--------------+---------------------------------------------------+
| PKTABLE_CAT | |
| | |
| | Name of the catalog for the table containing the |
| | primary key. The value is NULL if this table does |
| | not have catalogs. |
| | |
|PKTABLE_SCHEM | |
| | |
| | Name of the schema for the table containing the |
| | primary key. |
| | |
|PKTABLE_NAME | |
| | |
| | Name of the table containing the primary key. |
| | |
|PKCOLUMN_NAME | |
| | |
| | Name of the column containing the primary key. |
| | |
| FKTABLE_CAT | |
| | |
| | Name of the catalog for the table containing the |
| | foreign key. The value is NULL if this table does |
| | not have catalogs. |
| | |
|FKTABLE_SCHEM | |
| | |
| | Name of the schema for the table containing the |
| | foreign key. |
| | |
|FKTABLE_NAME | |
| | |
| | Name of the table containing the foreign key. |
| | |
|FKCOLUMN_NAME | |
| | |
| | Name of the column containing the foreign key. |
| | |
| KEY_SEQ | |
| | |
| | 1-indexed position of the column in the key. |
| | |
| UPDATE_RULE | |
| | |
| | Integer value representing the action applied to |
| | the foreign key when the SQL operation is UPDATE. |
| | |
| DELETE_RULE | |
| | |
| | Integer value representing the action applied to |
| | the foreign key when the SQL operation is DELETE. |
| | |
| FK_NAME | |
| | |
| | The name of the foreign key. |
| | |
| PK_NAME | |
| | |
| | The name of the primary key. |
| | |
|DEFERRABILITY | |
| | |
| | An integer value representing whether the for- |
| | eign key deferrability is SQL_INITIALLY_DEFERRED, |
| | SQL_INITIALLY_IMMEDIATE, or SQL_NOT_DEFERRABLE. |
| | |
+--------------+---------------------------------------------------+
SEE ALSO
db2_column_privileges(3), db2_columns(3), db2_primary_keys(3), db2_procedure_columns(3), db2_procedures(3), db2_special_columns(3),
db2_statistics(3), db2_table_privileges(3), db2_tables(3).
PHP Documentation Group DB2_FOREIGN_KEYS(3)