Hi Dave,
thanks very much for the reply. yes, it is working fine and also the below format is doing fine.
SUBSTR(ORE_RECORD_DATA,1390,5) = X'000005000C'
Thanks
Bola
Search found 8 matches
- Fri Oct 26, 2007 5:06 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: CAST function
- Replies: 2
- Views: 14434
- Tue Oct 23, 2007 9:14 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: CAST function
- Replies: 2
- Views: 14434
CAST function
Hi, I have a table with one of the varaibles declared as VARCHAR(4000). at position 50 for that variable, i have a packed value of s9(9) comp-3 i need to query this table to pick records that have a value of 5000 @ 5. Sample data in hex format 0004400000 00C000050C when i use the cast funciton to ju...
- Thu Oct 04, 2007 1:49 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: query on sql
- Replies: 4
- Views: 11175
- Thu Sep 27, 2007 11:20 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Query on SQL
- Replies: 6
- Views: 15255
- Wed Sep 26, 2007 6:21 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Query on SQL
- Replies: 6
- Views: 15255
- Mon Sep 24, 2007 7:27 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Query on SQL
- Replies: 6
- Views: 15255
- Mon Sep 24, 2007 7:23 pm
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: query on sql
- Replies: 4
- Views: 11175
query on sql
hi,
i have a char variable with length 6 bytes that contains time in the below format
1014AM
1014PM
..
..
i need to convert into the below foramt
10:14:00 if AM
20:14:00 if PM
Please, let me know if I can use any funtion here. i tried with SUM(INTEGER(SUBSTR(......) but not working.
Thanks
i have a char variable with length 6 bytes that contains time in the below format
1014AM
1014PM
..
..
i need to convert into the below foramt
10:14:00 if AM
20:14:00 if PM
Please, let me know if I can use any funtion here. i tried with SUM(INTEGER(SUBSTR(......) but not working.
Thanks
- Sat Sep 22, 2007 12:04 am
- Forum: DB2 SQL - DB2 PROGRAMMING
- Topic: Query on SQL
- Replies: 6
- Views: 15255
Query on SQL
bolastuff1975@yahoo.co.uk Hi Please, help me out in solving this issue. i need to update field2 & field3 of table-1 when there are more than 2 rows with same key-2 and field1. field2 & field3 are picked from table2 based on key-1 and max time stamp for t1. Table structre and data is shown below. i h...