DSXchange

Hi I have a sequentail stage reading a txt file pipe delimited. I had to set the line termination to DOS - Style. However i am getting this error row 1, too many columns in record. I checked many times and the number of columns is the same as every other row anyone ever run into this issue before. W...

************************************************************************* * Copyright (C) 2004, 1997-2003 Ascential Software Corporation. All Rights Reserved. * * This code may be copied on condition that this copyright * * notice is included as is in any code derived from this source. * ***********...

I got it i built my own routine to get what i need thanks

Thanks that helped i almost the only issue i see is where do this forumla DateDaysSince1970ToTimeStamp(1233260928 /86400) I am getting 2009-01-28 however when i run this query in oracle sql select to_date('01-JAN-1970 00:00:00', 'DD-MON-YYYY HH24:MI:SS') + NUMTODSINTERVAL(1233260928,'SECOND')from du...

Ok i am hoping i am close
DateDaysSince1970ToTimeStamp(1233260928)
ouputed this 85230926 00:00:00.000

so i am assuming this is another format i have to convert does it look familiar to anybody

Where can i find this function TimestampFromTimet".

Where can i find this function TimestampFromTimet".

its being passed in the data

Does anyone know how to convert a unix time ("1201546826")
into an oracle date in datastage.

I know it can be done in the sql but i am passing this into a procedure that i cannot change right now.

Thanks.

How do you specify the worksheet you want to pull from the excel workbook in the sequentail file stage

i mean datatype timestamp in the stored procedure

I have tried all the conversion functions but point is Datatype of Date in datastage does not allow for time so when you change it to timestamp it does now all you to put it in my nls format of dd-mon-yyyy. I tried all the conversions modifying datatypes back and fourth and i can not get it to work....

I gave up I put a request to the DBA to change the procedure to have the procedure parameters as VARCHAR and i sent them the to_timestamp sql to modify that field. So now I will just pass it as a varchar throughout the datastage job THanks for your help. Datastage really has to do something to be ab...

It looks like to me when you specify a timestamp in datastage it overrides and converts into another format and oracle does not like. Oracle is looking for yyyy-mm-dd hh:mm:ss however when i change the derivation OCONV(ICONV(Field(DSLink2.CreateDate," ",1,1),"D"),"D4YMD &quo...

the data in the source file "10/29/2008 8:31" this is what i did in datastage i change the transformer output type to be of data and this is the derivation i had in the transformer OCONV(ICONV(Field(DSLink2.CreateDate," ",1,1),"D"),"D-DMY[2,A3,2] ") loaded the...