DSXchange

Andrew, I followed your suggestions but DataStage reads all microseconds as zeros. For example, at the database is "2008-02-18 08:31:39. 12 " and DataStage interprets it as "2008-02-18 08:31:39. 00 "? That's first. Second, I've a bigger problem, as I mentioned above hundreds of j...

Thank you for your reply, Chulett. I was talking about Oracle RDB v7.1 not Oracle v7. This is another version of Oracle, it's an older one which has different structure other than the relational Oracle database and which has this form of timestamp e.g. "2009-06-23 10:49:22. 79 ". It's defi...

I need to read the microseconds from timestamp column from Oracle RDB 7.1 (as a data source) to Oracle 10g as a destination but I couldn't. The default timestamp format at the job & projet level is %yyyy-%mm-%dd %hh:%nn:%ss. I found the following solutions on the forum but it didn't work: 1- cha...

Thank you for your reply :) the issue is that i have actually tried setting the NLS_LANG on the windows client to read Arabic, as i believe it's a client setting issue as you said. My plan was to try reading Arabic correctly from the windows client, and which then in turn should prove that the datas...

Hi, This is urgent! :? Givens: - Oracle RDB 7 database, holds US7ASCII character set (Contains Arabic data) - We need to migrate this data to Oracle 10G database using datastage ETL. - Oracle SQLPlus from the client on Windows reads this data as rubbish one, and datastage do the same thing each time...

Source Database: Oracle RDB Release 7.1.0 on Open VMS server DataStage Server: Red hat server Problem: - we have installed Oracle 9i Client on the datastage server to connect to RDB database, and have succeeded to connect to RDB using SQLPlus from the datastage server - but we could not connect to ...

i have got the error of "an invalid remote file" everytime i try to FTP a squential file from a WinXP FTP to Win2003 server.. Note: FTP server on the Win Xp is accessable and workin from the win 2003 server IE!.. so i just dun know why the datastage just cant verify it!! my FTP Stage Input...

I am workin on DS 8 IBM Websphere OS : Win. 2003 Server + SP1 I have got the same error while tryin to FTP a squential file from a WinXP FTP server.. Note: FTP server of the Win Xp is accessable and workin from the win 2003 server IE!.. and i just dun know why the datastage just cant verify it!! FTP...