Hello All,,
I'm very new to Unix and I'm more in SAP ABAP. I have a requirement for a shell script which will accept one parameter as Input file name(with directory)
e.g : /sapdata/deubank/dbdirect/out/deu01deupe/in/deu01deupe20051207111320.pmt
In the shell script I have to make two more... (2 Replies)
Below is a description of what im trying to achieve:
Write a shell script to concatenate lists together, and output the resulting list. Do not include any argument that is a sub-list of the entire list. (The script will clean the list of any redundant items.) You must preserve the original order... (1 Reply)
Hi guys,
I have a simple question, I want to store the output of the following command:
As you can see it is running all the time, and we get a new line every 3sec.
I just want to store these new lines into a single variable, so I can use it into a script.
To clear the screen, and... (4 Replies)
i have a mega file in this format:
a,
b,
c,
d,
=
a2,
b2,
c2,
d2,
=
a3,
b3
=
i want to combine lines until = meet. the result should be :
a,b,c,d,
a2,b2,c3,d2
a3,b3 (13 Replies)
Hello,
There is pipe chain and I want concacenate piped data with some variable:
balh blah| ... $var1
What command I should use instead ... to concatenate piped output with $var1. I think I coud solve this using temp var - but could it be done in one line like sample above ?
thanks... (4 Replies)
Hi guys;
TBH I am an absolute novice, when it comes to scripting; I do have an idea of the basic commands...
Here is my problem;
I have a flatfile 'A' containing a single column with multiple rows. I have to create a script which will use 'A' as input and then output a string in in the... (0 Replies)
Hi colleagues,
I have a file in this format.
"/cccc/pppp/dddd/ggg/prueba.txt".
ERROR" THE error bbbbbbbbbb finish rows.
"/kkkk/mmmm/hhhh/jjj/ejemplo.txt".
ERROR This is other error rows.I need my file in this format.
"/cccc/pppp/dddd/ggg/prueba.txt". ERROR" THE error bbbbbbbbbb finish rows.... (3 Replies)
Hi Team -
I"m very new to Shell Scripting so I have a rather novice question. My forte is Windows Batch Scripting so I was just wondering what the Shell Script equivalent is to the DOS command %~n?
%~n is a DOS variable that dispayed the script name.
For instance (in DOS):
REM... (11 Replies)
Hi Guys,
I am very new to shell script and I need your help here to write a script. Actually, I have a script abc.sh which don't get terminated itself. So I need to design a script to run this script, save the output to a file, search for a given string in the output and if it exists send those... (11 Replies)
I'm trying to create a shell script that takes a awk script that I wrote and a filename as an argument. I was able to get that done but I'm having trouble figuring out how to keep the header of the output at the top but sort the rest of the rows alphabetically. This is what I have now but it is... (1 Reply)
Discussion started by: Eric7giants
1 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 tableSYNOPSIS
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)