User Profile

Collapse

Profile Sidebar

Collapse
ramanivx
ramanivx
Last Activity: Oct 15 '15, 03:08 PM
Joined: Aug 25 '15
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ramanivx
    replied to Convert Char string with Sign to Decimal in DB2
    in DB2
    I think it is possible to code but it is tedious to convert the last character into a hexa using a function in DB2. Can anyone help me come up with a hexa table for all the last characters. BTW, is there any better way in DB2 SQL?
    See more | Go to post

      Leave a comment:

    • ramanivx
      started a topic Convert Char string with Sign to Decimal in DB2
      in DB2

      Convert Char string with Sign to Decimal in DB2

      I need to convert a character string using DB2 SQL into a decimal (11,2). This character string has a sign also. I tried using Decimal verb and it gives ++++++++ sign after converting.
      Appreciate help.

      Example
      input:
      SUBSTR SUBSTR
      110006 0000000000{
      110011 0000000000{
      110016 0000000000{
      110020 0000000893H
      110071 0000000000{
      ...
      See more | Go to post
      Last edited by ramanivx; Aug 25 '15, 08:51 PM. Reason: given example
      No activity results to display
      Show More
      Working...