11-06-2009
Hi tyler,
I found out the answer if anyone is interested
|
su - d3dadm -c "grep "\"successfully loaded DB2 library \'/db2/db2d3d\"" trans.log" |
I only ever use csh for scripts as its nearly always guaranteed to be on all machines.
Thanks,
C
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi there
I have a data file like so below
'A/1';'T100002';'T100002';'';'01/05/2004';'31/05/2004';'01/06/2004';'08/06/2004';'1.36';'16';'0.22';'0';'0';'1.58';'0';'0';'0';'0';'0';'0';'clientes\resumen\200405\resumen_T100002_T100002_1.pdf';'';'0001';'S';'20040501';'';'02';'0';'S';'N'... (3 Replies)
Discussion started by: rjsha1
3 Replies
2. Shell Programming and Scripting
Hi
I have a shell script with many lines as below:
comment on column dcases.proj_seq_num is dcases_1sq;
....
....
I want the above script to be as below:
comment on column dcases.proj_seq_num is 'dcases_1sq';
I want to have single quotes like that as above for the entire shell... (2 Replies)
Discussion started by: dreams5617
2 Replies
3. Shell Programming and Scripting
hi,
echo 'abc' will give output abc
how can i get output as 'abc'
plz help. thanks in advance (3 Replies)
Discussion started by: javeed7
3 Replies
4. Shell Programming and Scripting
i want to print ' symbol using awk i tried:
awk '{print " ' "}'
awk '{print "\' "}'
both not work please help me. (2 Replies)
Discussion started by: RahulJoshi
2 Replies
5. Shell Programming and Scripting
Hi,
I've been trying to write a regex to use in egrep (in a shell script) that'll fetch the names of all the files that match a particular pattern. I expect to match the following line in a file:
Name = "abc"
The regex I'm using to match the same is:
egrep -l '(^) *= *" ** *"$' /PATH_TO_SEARCH... (6 Replies)
Discussion started by: NanJ
6 Replies
6. Shell Programming and Scripting
Hi I want to replace single quote with two single quotes in a perl string.
If the string is <It's Simpson's book> It should become <It''s Simpson''s book> (3 Replies)
Discussion started by: DushyantG
3 Replies
7. Shell Programming and Scripting
hi all,
i have a data in the file which of the formate :
100,102,103
and the required formate is
\'100\',\'102\',\'103
Idealy we need to replace , with \',\'
Regards
arkesh (2 Replies)
Discussion started by: arkeshtk
2 Replies
8. Shell Programming and Scripting
Hi Guys,
Please someone help me to insert these numbers (enclosed with single quotes) to a statement using awk command. I'm having hard time of putting single quotes on these numbers.
input file:
10214
68441
07205
80731
92234
55432
DESIRED OUTPUT:
My ID Number='10214';... (1 Reply)
Discussion started by: pinpe
1 Replies
9. Shell Programming and Scripting
From:
1,2,3,4,5,This is a test
6,7,8,9,0,"This, is a test"
1,9,2,8,3,"This is a ""test"""
4,7,3,1,8,""""
To:
1,2,3,4,5,This is a test
6,7,8,9,0,"This; is a test"
1,9,2,8,3,"This is a ''test''"
4,7,3,1,8,"''"Is there an easy syntax I'm overlooking? There will always be an odd number... (5 Replies)
Discussion started by: Michael Stora
5 Replies
10. Shell Programming and Scripting
Hi all...
(This is Don's domain.)
I have come across an anomaly in sh and dash compared to bash.
It involves echoing a character set to a file in sh and dash compared to bash.
It is probably easier to show the code and results first.
#!/usr/local/bin/dash
#!/bin/sh
#!/bin/bash
echo... (4 Replies)
Discussion started by: wisecracker
4 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)