DSXchange

Hi ray, I need to conver the Hex to Char Below is the example F9 is hex format for and its conversion in ascii is 9 same for the 2 column Column 1 (Hex Format) Output D F9F9F9 999 Column 2 Output C8D9 HR You said I need to check my NLS tab for that can you suggest which NLS I need to select . [quote...

Thanks Ray , It solves the problem for the PArticular date but how to use your logic at runtime as the logic given the 90851 is hardcoded for only one type of date 104314, it will be impossible for calculating the difference for each type of date in data i.e. can we pass it as an argument it will be...

Hi Ray , I tried it with Ans= Iconv(Arg1,'MX0C') also woth Oconv But still its not working ...do we have some routine to convert Binary or hex format to Char or Numeric. Char() function works but will pick up only the last bit and display it i.e 0009 will turn out to be 9 [quote="ray.wurlod&quo...

Hi, I'm extracting data from DB2- AS400 thro' ODBC stage. The data I'm looking at is in format Column 1 (Hex Format) Output D F0F0F0F9F9F9 000999 Column 2 Output C8D9 HR I need to changed the value of the Input(source) to desired Output * I even converted the Input data to Binary format and used fun...

Hi Ken , This is same as Ans=Oconv(ICONV(Right(TheDate,5), "D-YMD"), "D-YMD[4,2,2]") but this will not work i.e what will happen if the date is 1901-12-11 I may be wrong but if we can put the julian format for 1901-12-11 it will fail , i think any year below 1930 fails as 30313 =...

Hi, I've date coming from DB2-AS400 as Julian . I'm able to succefully convert dates with using Functions Ans=Oconv(Iconv(TheDate, "DYJ"), "D-YMD[4,2,2]") Input - 90313 output - 1990-11-09 But I've dates coming in format for example :104314 i.e. 2004-11-09 for which above routine...

Hi, I've date coming from DB2-AS400 as Julian . I'm able to succefully convert dates with using Functions Ans=Oconv(Iconv(TheDate, "DYJ"), "D-YMD[4,2,2]") Input - 90313 output - 1990-11-09 But I've dates coming in format 104314 i.e. 2004-11-09 for which above routine do not works...

Hi, I've date coming from DB2-AS400 as Julian . I'm able to succefully convert dates with using Functions Ans=Oconv(Iconv(TheDate, "DYJ"), "D-YMD[4,2,2]") But I've dates coming in format 104314 i.e. 2004-11-09 for which above routine do not works. Can someone suggest how to conve...