What are OConv () and Iconv () functions and where are they used? 

IConv() - Converts a string to an internal storage format
OConv() - Converts an expression to an output format.
  • Interview Candidate
  • 1
  • 21495

Editorial / Best Answer

sekr  

  • Member Since Dec-2005 | Jan 30th, 2006

iconv is used to convert the date into into internal format i.e only datastage can understand

example :- date comming in mm/dd/yyyy format

datasatge will conver this ur date into some number like :- 740

u can use this 740 in derive in ur own format by using oconv.

suppose u want to change mm/dd/yyyy  to dd/mm/yyyy

now u will use iconv and oconv.

ocnv(iconv(datecommingfromi/pstring,SOMEXYZ(seein help which is iconvformat),defineoconvformat))

Showing Answers 1 - 1 of 1 Answers

sekr

  • Jan 30th, 2006
 

iconv is used to convert the date into into internal format i.e only datastage can understand

example :- date comming in mm/dd/yyyy format

datasatge will conver this ur date into some number like :- 740

u can use this 740 in derive in ur own format by using oconv.

suppose u want to change mm/dd/yyyy  to dd/mm/yyyy

now u will use iconv and oconv.

ocnv(iconv(datecommingfromi/pstring,SOMEXYZ(seein help which is iconvformat),defineoconvformat))

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions