|
View previous topic :: View next topic
|
| Author |
Message |
maxsubrat
Active User
Joined: 27 Feb 2008
Posts: 110
Location: india
|
|
|
|
I want to get all the records from a DB2 table PO_P1 from the ADDR_FLD which does not have any hex value od 1st 1-40 bytes,
the address field has 100 bytes length which has hex values in multiple positions..
I want to get all the records where the address field does not have the hex value of X'0A' in 1st 1-40 length...
Thanks |
|
| Back to top |
|
 |
prino
Senior Member
Joined: 07 Feb 2009
Posts: 1306
Location: Vilnius, Lithuania
|
|
|
|
| All EBCDIC values are hex values, so what you want is impossible. |
|
| Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010
Posts: 3051
Location: NYC,USA
|
|
|
|
| Quote: |
I want to get all the records where the address field does not have the hex value of X'0A' in 1st 1-40 length...
|
Try..
| Code: |
| WHERE LOCATE(x'0A',substr(ADDR_FLD,1,40)) = 0 |
if you want to replace it and make a use of it in where (another solution) or to use it in select then you could try this.
| Code: |
| select replace(replace(X'0A',chr(13),''),chr(10),'NL') from sysibm.sysdummy1; |
|
|
| Back to top |
|
|
|
|
