User Tools

Site Tools


sql_value_as_hex

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Last revision Both sides next revision
sql_value_as_hex [2018/01/25 13:09]
mihael created
sql_value_as_hex [2018/01/25 13:09]
mihael
Line 3: Line 3:
 To get a hex representation of a value the SQL function [hex](https://​www.ibm.com/​support/​knowledgecenter/​en/​ssw_ibm_i_73/​db2/​rbafzscahex.htm) can be used: To get a hex representation of a value the SQL function [hex](https://​www.ibm.com/​support/​knowledgecenter/​en/​ssw_ibm_i_73/​db2/​rbafzscahex.htm) can be used:
  
-    ​select hex('​MIHAEL'​) from sysibm.sysdummy1+<sxh sql> 
 +select hex('​MIHAEL'​) from sysibm.sysdummy1 
 +</​sxh>​
  
 {{tag>​devel sql ibm}} {{tag>​devel sql ibm}}
  
sql_value_as_hex.txt · Last modified: 2018/01/25 13:10 by mihael