I have a rather large file with XML-style content. Each line contains one full XML entry. For example:
1:<Message><DNIS>1234</DNIS><UCID>3456</UCID><TransferGroup>XYZXYZ</TransferGroup></Message>
2:<Message><DNIS>9999</DNIS><UCID>2584</UCID><TransferGroup>ABCABC</TransferGroup></Message>... (1 Reply)
Hi,
I need to extract values from a CSV file based on some conditions as explained below:
File format details:
1. each set starts with AAA only
2. number of columns is fixed
3. number of rows per set may vary (as they are having different CCC rows)
Now, i need to extract 3rd column of... (3 Replies)
Hi Friends,
I have a file with the following values..
xyz.txt,12345.xml
abc.txt,04567.xml
cde.txt,12134.xml
I would like to extract all the 2nd column values twice as shown in the example like
12345,12345.xml
04567,04567.xml
12134,12134.xml
Please advice!!
In the formus one of... (7 Replies)
I am parsing a log with key values spread all over in the following fashion:
TEST 1 SCHEME 12 SET EMPTY
VARLEN SET TEST 1201 PARAM1 EMTY PARAM2 SET
SCHEME 12 REFRESH TEST 8
I need to extract test number, my result should be
1
1201
8
I use awk for processing this log and use... (4 Replies)
I have two questions that are related, so it would be great if you can help me with both!
Question1:
I have a file A that looks like this:
a x
b y
b z
c w
I want to get something like:
a x
b y; z
c w
Given that a,b,c has no spaces. But the other letters might contain spaces.
... (2 Replies)
Hi,
I would like to search based of "java" and "-Dplatform.home=" and store these two values in bash variables.
ps -xef | grep <pid>
wlsuser 15160 15144 0 Feb 20 ? 17:27 /app1/jdk150_07/bin/IA64N/java -server -Xms1536m -Dplatform.home=/app1/bea/weblogic92... (13 Replies)
Hallo,
I would need to extract only rows which has different value in the second and third column.
Thank you very much for any advices
Input:
A 0 0
B 0 1
C 1 1
D 1 3
Output
B 0 1
D 1 3 (4 Replies)
Hi
Please I need help on extracting values, of certain tagsMSISDN:, and IMSI: in the following text file entryDS: 1
nodeId: 11
MSISDN: 258827475309
IMSI: 643012111658984
NAM: 0
CDC: 41
IMEISV:: U3URIGF2hoc=
AUTHINFO: 0
TSMO:... (16 Replies)
Discussion started by: fretagi
16 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 tableSYNOPSIS
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)