Not quite 100%, but very helpfull indeed
This did the trick:
OCONV(ICONV(DSlink1.date,'D4-YMD'),'D4-YMD[4,2,2]')
Search found 2 matches
- Fri Jan 11, 2008 4:17 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Transform yyyy-m-d to yyyy-mm-dd
- Replies: 4
- Views: 2939
- Fri Jan 11, 2008 3:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Transform yyyy-m-d to yyyy-mm-dd
- Replies: 4
- Views: 2939
Transform yyyy-m-d to yyyy-mm-dd
Hi, I'm new to DataStage and have an issue regarding a transform. All my job has to do is load a .csv file into an SQL2000 tabel. File consists of temperature measures by day: 2007-1-1; 30 2007-1-2; 34 2007-1-3; 29 2007-1-4; 24 ... Problem is that I encouter the following error message when trying t...