DSXchange

Ok. What have you tried? What specific problem are you having?

Then as long as you have tnsnames entries for both and can tnsping both from the DataStage server, you'll be fine. Assuming someone has configured DataStage for Oracle, that is.

Sure, just make sure you have connectivity to both from the DataStage sever. What database?

Which of those do you consider to be invalid years? What is your validation business rule? If the planet lasts long enough, all of those are technically 'valid'.

Thanks Craig. But I'm not allowed to create/drop/delete any table on production database using datastage. Is there any other work around? That's just a silly and stupid restriction. A 'connection' account can easily have its own 'schema' (whatever the DB2 equivalent is called) where work tables can...

Amit_111 wrote:I searched in the forum and found out the solution for parallel version. The functions mentioned are not in Server version.

Funny, I searched for "month end date" and was able to find several Server posts on the subject.

Sounds like a classic Microsoft problem with dlls, etc - something else probably overwrote what DataStage needs. First suggestion would be to uninstall and then reinstall the client from your PC. Sometimes you have to do that 'with extrememe prejudice', meaning take alot of what seem like extra step...

There's a pdf document on your PC in the 'Docs' directory for XML just like there is for everything else. You can also go to Kim Duke's site and download the XML Best Practices document from his Tips & Tricks section. Well worth a read.

That would depend entirely on the proc, would it not? Try it, let us know.

Is that the case with everyone in your organization or just you on your PC?

Search. The. Forums. It has been fully explained ad nauseam here.

Map them again. No rule against having multiple stages writing to the same instance / schema / table as long as you don't create locking issues. Or use another stage to combine the two streams before sending the data to Oracle.

Have you tried searching the forums for "vmdsedit.dll"? We just went through this with someone in the last few days.

Add two more Oracle stages. Link both from the 'third' transformer.

If 'add the user through datastage server' means create the O/S user using DataStage, then as noted the answer is no. If you mean something else, let us know.