guys. I'm facing some problems with a year format on Datastage. I have a Oracle procedure that returns me a Date datatype column. I have a business flow job that write this date in a dataset that will be the initial step for another business flow job, consulting another procedure.
I need to format my date, but i don't know how. The Oracle returned value for this date its like '01-JAN-15' in format dd-mm-yy. The Datastage understand this date like '0015-01-01' in format yyyy-mm-dd. Then, when the dataset file is consumed by the other job, i got a "Datetime field overflow" error. I need to set the correct year, but i've tried everything, like Oconv() functions but doesn't helped at all.
Does anyone know how to help me?
Thank you a lot, guys.
Aucun commentaire:
Enregistrer un commentaire