WebFeb 16, 2010 · Is there any way to convert a string (dd-mm-yyyy) to date format. I think it is possible to convert a string which is in the format 'yyyy-mm-dd' to date easily using type conversion functions, but i need to convert the above string which is in the format 'dd-mm-yyyy' to date. WebHow to use Convert Function in DataStage Transformer Stage +91 937 936 5515 Logic for Convert function. Show more Show more Chat Replay is disabled for this Premiere. Implementation of...
Datastage Date and time functions IBM Datastage in & out
WebJul 24, 2008 · please check the final ORA stage datatype for Date column. You need to convert date with time also then only Oracle will accept. Like mm-dd-yyyy hh:mm:ss and also you need to declare Timestamp in datastage not Date. Thanks Man ray.wurlod Participant Posts: 54604 Joined: Thu Oct 24, 2002 4:52 am Location: Sydney, Australia WebJan 31, 2024 · Datastage has following Capabilities. It can integrate data from the widest range of enterprise and external data sources Implements data validation rules It is useful in processing and transforming large … mark price rutland vt
DataStage Tutorial for Beginners: IBM DataStage …
WebThe OCONV function is a general-purpose conversion function used to convert from internal (storage) format to external (output) format. The type of conversion is specified by a... Web1 Convert function return a copy of variable with every occurrence of specified characters in variable replaced with other specified characters. Every time a character to be converted appears in variable, it is replaced by the replacement character. example: A="NOW IS THE TIME" PRINT A A=CONVERT ('TI','XY',A) PRINT A A=CONVERT ('XY','T',A) PRINT A http://www.dsxchange.com/viewtopic.php?t=120814 mark priem on facebook