How to Convert a string function to date function by using
only sequential file stage with out using other stages ?
Answers were Sorted based on User's Feedback
Answer / venkatesh
1) Open the Sequential file stage properties.
2) Go to Format > Type Default > Date > Format String.
3) Type the format of the string in which the source date is
coming. For ex. For 20101201 - Type %yyyy%mm%dd.
4) Go to Column tab, Chose SQl Type as Date.
Now, try to view data. YOu should be able to see date as
2010-12-01.
Is This Answer Correct ? | 17 Yes | 0 No |
Answer / p.n.chowdary
I think this is not posible......
But we can load date in sequenatial file stage.
Is This Answer Correct ? | 19 Yes | 6 No |
Answer / sneha
Hi ,
In seq stage , in format tab , there is option where we can define format for date . Then we can read date data with date datatype .
correct me , if I am wrong
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / saidarao
by using transformer stage
in functions one option like-string 2 date ,we can possible.
Is This Answer Correct ? | 0 Yes | 4 No |
Answer / 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 |
what is snow flack schema?
what is the main difference between sorragate key n primary key in one word
What is orabulk stage?
what is the difference between datasatge and datastage TX?
what is a force compile
How to reverse the string using unix?
What is audit table?
How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?
source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235
What are the different plug-ins stages used in your projects?
if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi
17 Answers IBM, TCS,
What steps should be taken to improve Datastage jobs?