DSXchange

kashif007 wrote:I did not get any reply for my question. Which stage should I use to load to an SAP BI Info Object. Is it SAP BW Load stage????

Please do not demand quick response

As suggested go through the Docs.

You can use BW Load Stage ( may be the latest version is 4.2.1)

Does your routine have other logic or are you using it only for the copy?

No idea , i can check with my team.

Thanks Craig.
Paddu

What is enterprise software delivery system?

we have lot of developers working on different projects but on the same server . We have frequently invalid password issue . All the developers have admin login as it is windows usr/pwd. I would like developers to access designer and director and not Administrator. Is there anyway to do . By the way...

How can we restrict a User ID to access Datastage admin.

let me know if my question is vague
Thanks
paddu

just an update . Looks like version 7.5.2 has fixed abnormal termination problem . In our project we did not see this problem after switching from datastage 7.5x2 to 7.5.2 march 2006 release. IBM told us they had a patch for this problem and fixed in 7.5.2. I wish they come up with a patch for abnor...

i used this TRIM(Oconv(Iconv(src_out_LICENSE.Raw_St_Lic_expr_dt, "D/MDY[2,2,4]"),"D-YMD[4,2,2]"), "-", "A") .

worked fine . i think even it we load in orace format ,it is something to do with TOAD . In TOAD i view the date as MM/DD/YYYY.

DSguru2B, I tried your option . it is working but whenever there are blank dates coming in, it is throwing an error as ORA-01858: a non-numeric character was found where a numeric was expected and rejecting the record result in datastage Dir log RAW_ST_LIC_EXPR_DT = - - function used in transfomer i...

As i mentioned before my source date format is MMDDYYYY . In my target oracle we want the date to be like MM/DD/YYYY

kumar,

on oracle side my field is Date , front side in datastage it looks like timestamp 38 when i imported the table definition from oracle .

us1aslam1us

i tried your solution
it ended as blank in oracle.

i even tried

OCONV(ICONV(src_out_AMA_LICENSE.Raw_St_Lic_expr_dt,'D4MDY'),'D4/DMY[2,2,4]')

even ended as blank in oracle.

i first added Date of length 10 and loaded into oracle and it gave those values which i mentioned earlier ,

Now i changed the field as Timestamp length 38 while loading into oracle ( which we actually want ) . datastage threw an error as DBMS.CODE=ORA-01861 literal does not match format string

No, it did not work


For a date from source which is 12312006 i got 2/14/5677 as the result in oracle.

so we don't have to use any date conversions ????.
just loading string to date would resolve ? let me try.

i will update you quickly.

Thanks
paddu