How to Convert a string function to date function by using
only sequential file stage with out using other stages ?

Answer Posted / ramesh

Datastage contains so many inbuilt functions...
simply we use this type conversion like this
StringToDate(file1.Date1,"%mm/%dd/%yyyy");

Is This Answer Correct ?    0 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

1766


Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

974


How to clean the datastage repository?

699


Triggers,VIEW,Procedures

805


What is the precedence of stage variables,derivations, and constraints?

604






What are the important features of datastage?

623


Describe routines in datastage? Enlist various types of routines.

586


i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2277


What are the types of containers and how to create them?

562


What is datastage?

652


Have you have ever worked in unix environment and why it is useful in datastage?

657


What is process model?

1558


How can one find bugs in job sequence?

793


Explain the datastage parallel extender (px) or enterprise edition (ee)?

744


Why do you need stage variables?

669