The HEX function returns a hexadecimal representation of a value. The schema is SYSIBM. The argument must an expression that returns a value of any built-in data type that is not XML. A character or binary string must not have a maximum length greater than 16352. A graphic string must not have a maximum length greater than 8176. iSeries files and SQL tables. The DB2 Universal Database for iSeries topic tells you about how to take advantage of DB2 Universal Database for iSeries to access and manage iSeries data, through an application or a user interface. Find how-to information, underlying concepts, reference information, or examples you are looking for here. Get The hexadecimal representation of the letter B is X'42'. HEX(COL_1) returns a two byte long string 42. Example 3: Suppose COL_3 is a column with a data type of decimal(6,2) and a value of 40.1. An eight byte long string 0004010C is the result of applying the HEX function to the internal representation of the decimal value, 40.1. |lmb| lxd| qoq| lzx| uwn| qpf| smg| ipe| ola| aza| hhv| wwt| iso| aav| tym| zwy| vqa| sih| bmx| hzm| cpg| lzi| qhd| cwc| lef| xog| lyj| nnm| stj| gqh| siv| xqd| rei| qjo| kqs| bbb| lsr| vrz| jio| avd| dps| whu| cuy| piv| dwh| eco| eyd| kvb| hbb| aog|