02-27-2008
i want create table definition also:
List out the file names which has “create table upto ; “ even if it's in next line.
List out directory found and the file name which satisfied the above criteria:
Example:
Ab.text:
create table data (pi int, col1 char(1), col2 char(5), col3 int) primary index (
pi)
;
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
Good day
Here is my data:
<Journal>
<JournalCode>2</JournalCode>
<JournalType>L</JournalType>
<JournalEntry>SG</JournalEntry>
<JournalAmount>-0.05</JournalAmount>
</Journal>
Problem:
1) I need to query the above tags in xml. Which is from the header <Journal>... (4 Replies)
Discussion started by: lutinoman
4 Replies
2. Shell Programming and Scripting
Hello All,
I am a statistician and I am very new to the world of ksh programming. Daily, I analyze millions of rows of data and land information to DB2 tables. I have recently been asked to develop a ksh script to FTP an export file containing line item data from the production environment to the... (2 Replies)
Discussion started by: jonesdk5
2 Replies
3. Shell Programming and Scripting
Hai,
I need to search a variable inside a file using awk in AIX.
for ex:
file.txt
one
two
three
four
five
i need to get the lines with two
awk '/two/ {print}' file.txt
But i need to change the two as a variable since it would be changed on runtime..i tried like below..nothing give... (3 Replies)
Discussion started by: jesu
3 Replies
4. Shell Programming and Scripting
Hello,
I need a shell script which takes search keyword as input and then searches logs in six different servers and provide me the logs where in it found the keyword.
Can anyone help???? (1 Reply)
Discussion started by: tomlui2010
1 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I have an input file with below data and rules file to apply search and replace by each field in the input based on exact value or pattern.
Could you please help me with unix script to read input file and rules file and then create the output and reject files based on the rules file.
Input... (13 Replies)
Discussion started by: chandrath
13 Replies
6. Shell Programming and Scripting
Hello
I have a configuration file and I want to extract a part of this configuration.
Example of configuration:
profile toto {
bla bla
blabla
}
conftest {
toto {
myarguements
}
I try to do a sed command:
sed -n '/'toto' {$/,/^}/p'
But the result is :
profile toto { (6 Replies)
Discussion started by: maverick31
6 Replies
7. Shell Programming and Scripting
I have a server.xml in about 50 instances of JBOSS servers which has
the following line
<Engine defaultHost="localhost" name="jboss.web">
I need to append something into this line based on the hostname . For example hostname
abcdprod40j.corp.abc.net
<Engine defaultHost="localhost"... (1 Reply)
Discussion started by: gubbu
1 Replies
8. Shell Programming and Scripting
Hi
Need help for below coding scenario.
I have a file with say 4 lines as below.
DEFINE JOB TPT_LOAD_INTO_EMP_DET
( TDPID = @TPT_TDSERVER , USERNAME = @TPT_TDUSER ) ;
( 'DROP TABLE '||@TPT_WRKDB ||'.LOG_'||@TPT_TGT ||' ; ') ,
SELECT * FROM OPERATOR (FILE_READER) ; ) ;
Now I want to... (5 Replies)
Discussion started by: Santanu2015
5 Replies
9. Shell Programming and Scripting
I am trying to write shell script to find and replace using Sed. but i am unable to complete the setting. need help in doing that.
Requirement:
FROM
"${O_INSTANCE}/diag/logs/${C_TYPE}/${C_NAME}/httpd.pid"
TO
"/var/opt/<SID>_<HOSTNAME>/Apache/httpd.pid" (10 Replies)
Discussion started by: avmk0407
10 Replies
10. Shell Programming and Scripting
good afternoon friends
how can I find a shell in all server paths I have only the name of the shell (2 Replies)
Discussion started by: tricampeon81
2 Replies
LEARN ABOUT PHP
db2_primary_keys
DB2_PRIMARY_KEYS(3) 1 DB2_PRIMARY_KEYS(3)
db2_primary_keys - Returns a result set listing primary keys for a table
SYNOPSIS
resource db2_primary_keys (resource $connection, string $qualifier, string $schema, string $table-name)
DESCRIPTION
Returns a result set listing the primary 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_primary_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 primary keys for the specified table. The result set is com-
posed of the following columns:
+------------+---------------------------------------------------+
|Column name | |
| | |
| | Description |
| | |
+------------+---------------------------------------------------+
| TABLE_CAT | |
| | |
| | Name of the catalog for the table containing the |
| | primary key. The value is NULL if this table does |
| | not have catalogs. |
| | |
|TABLE_SCHEM | |
| | |
| | Name of the schema for the table containing the |
| | primary key. |
| | |
|TABLE_NAME | |
| | |
| | Name of the table containing the primary key. |
| | |
|COLUMN_NAME | |
| | |
| | Name of the column containing the primary key. |
| | |
| KEY_SEQ | |
| | |
| | 1-indexed position of the column in the key. |
| | |
| PK_NAME | |
| | |
| | The name of the primary key. |
| | |
+------------+---------------------------------------------------+
SEE ALSO
db2_column_privileges(3), db2_columns(3), db2_foreign_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_PRIMARY_KEYS(3)