DSXchange

Thanks satya...we got it working.

Yes ray...we are working on it and we both didn't talk to each other before we posted.

I had the same problem, and even after re installation it didnt show up. Now what I have done is I deleted all the Ascential files and removed all the registry entries and copied the C:\Program Files\Ascential folder from a different develops system. Amazingly the File menu bar appeared in my machin...

I got enterprise edition installed on windows xp machine.Its 7.5 x2 edition.

sorry Its my bad.

I got a DS 7.5.2 installed on windows machine and it compiles and runs.

Suresh,
I dont think so you will get any help with interviews in this forum.
This is for people who has some issues working on DS.
Please dont let yourself down by asking interview questions. Use search if you have any questions in particular.

Thanks

You have to write a routine in datastage if you are planning to implement your unix job functionality in datastage.
Then you can export that server routine to different projects.

Frankly i didnt understand the question. Can you please explain whats the issue.
Thanks

I think you have passed wrong parameters to the datastage job. Check the parameters.

I think some one in your project have done the DS.REINDEX ALL while a client is connected to the server. Make sure yo disconnect all the clients for that project and do the DS.REINDEX ALL for that project.
Thanks

The project got back after rerunning the DS.REINDEX ALL.
This time I made sure that all the clients are disconnected and server was not restarted. It came back as it is.
Thanks Guys

DS.REINDEX ALL has been executed while two clients for that project are connected. :( Jobs cannot be seen in the repository. If i disconnect the clients and re run the DS.REINDEX ALL command will i be able to see the Jobs back. WHat is the prep work to be done to restore all the indexes. Thanks in a...

I had a similar situation where i had to send 1 incoming row to 7 different target oracle tables based on day of the week. If its monday then hit monday table. In that situation i used 7 OCI stages as output. only 1 input record is being passed. I put a constraint over there. Here if you dont have a...

HI for AS/400 i believe you are using iseries Access driver. In that under system make sure you define your system name. Under Server tab define the library you are using like DEVDTA or DEVCOM etc. It should work. If you are using ODBC wire protocol You need to define the collection name as your use...

Hi, This is an urgent requirement. I need to design a datastage job which will process 10,000 records every half hour. My source is Db2 and my target is oracle. Problem is once a record is loaded into oracle, in the source DB2 there is a column value Y which has to be changed to P and if there is a ...

Ok Y do i get this error when iam importing table definitions DSR.MetaGeta(GET.COLUMNS)(SQLStatistics("SPEASUS4","DEVDTA","F5585211")): BCI Error: SQLSTATE=42000,CODE=-551,[DataStage][SQL Client][ODBC][IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0551 - Not authorized to...