Search found 4 matches

by andregomes
Thu Feb 25, 2016 11:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: HOW CONCAT "0 " IN MONTH TRANSFORMER
Replies: 7
Views: 7018

Sorry, In the field is string database ( 6) in the transformer also like to know that the transformer is with drawing 'not significant ?
by andregomes
Thu Feb 25, 2016 10:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: HOW CONCAT "0 " IN MONTH TRANSFORMER
Replies: 7
Views: 7018

Same result, "12016" i need to " 012016"
by andregomes
Thu Feb 25, 2016 10:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: HOW CONCAT "0 " IN MONTH TRANSFORMER
Replies: 7
Views: 7018

Thank you before was that way with CATS, had already made ​​the move to Oconv ( DataAtual , " DMY " , " [2.4 ]" ) ---- but not yet solved the problem of the month , I believe it is something in sql server
by andregomes
Thu Feb 25, 2016 9:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: HOW CONCAT "0 " IN MONTH TRANSFORMER
Replies: 7
Views: 7018

HOW CONCAT "0 " IN MONTH TRANSFORMER

Good Morning, I have a date field that shows the month and year , but the format is that way, " 12016 " but I want to show this way " 012016 " as include 0 left on the date ? I use the transformer the clause " Cats ( Oconv ( DataAtual , " DM [ 2 ] " ) , Oconv ( Dat...