GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  DataStage

 Print  |  
Question:  What are OConv () and Iconv () functions and where are they used? 

Answer: IConv() - Converts a string to an internal storage format
OConv() - Converts an expression to an output format.


January 01, 2006 07:41:52 #1
 sekr   Member Since: December 2005    Total Comments: 30 

RE: What are OConv () and Iconv () functions and where...
 

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))

     

 

Back To Question