DSXchange

Too many variables. As the job is busy working on transforming rows, the database sees that it's attention is not 100% needed, and you loose momentum. Constant roundtrips means you are never dedicated to one task at a time. You'd probably find that spooling to a file gives outstanding performance, a...

Since job design information is scattered across different rows (records), the concept of recovering the repository to a point in time is futile given its nature. A file system level backup is unaware of the transient state of the data in the file structures, so a backup could catch an instantaneous...

CHANGE(OCONV(ICONV(yourdate, "D"), "D-YMD[4,2,2]"),"-", "")

Do not thank us for assisting your illegal activities, we simply pointed out that DS is supported on Windoze utilizing the NTFS filesystem, which is the default for Windoze XP Professional.

koolnitz wrote:I wish DataStage had DEBUGGER, as we have this feature inbuilt in Informatica..

Server has an exquisite integrated Debugger that has been there from the beginning. Be sure which flavour of the tool you're addressing.

Please differentiate Server, PX, RTI, etc and their versions.

The war stories for each is vastly different, as well as their successes.

Can it be done, yes. Is it worth the effort, probably not. A realtime connection from the database either needs DS RTI, or you're going to need to embed triggers in the database to feed updates to either a queue or a queue table and use microbatches to continuously query the table and feed to the ha...

Options: 1. Write a sqlplus script to query the table and get the single available next value. Use job control to feed that as a parameter to a transformation job. 2. Write a sqlplus script to query the table and get the single available next value. Use a DSExecSH call at stage variable initializati...

Well, apart from declaring to the world you're installing an illegal copy of the Server engine on your home PC, the only other error you're encountering is that you have to be running Windows XP Professional. It sounds like you're not.

Changing the hardcoded values in a Sequencer job activity stage will not change the hardcoded values defaulted in the controlled job.

Okay, you're in the wrong forum again. This is the FAQ discussion forum. If you have Server questions, please post them in the Server forum. To answer your question, subtracting dates gives an answer in the grain of the question, so if you're subtracting dates you will get either DAYS or HOURS or SE...

Welcome aboard. Since you're posting a new message for your own separate issue, please start a new message thread. That will force you to enter all of the relevant information, such as your version of DataStage, etc. You're asking a Server question in the Parallel forum, so please repost there. Than...

Or the RND (expression) should give you a unique number everytime. Have you tried it? Are you sure 100% of the time two simultaneous processes won't generate the same random number? What will prevent that? The easiest solution is to use the process ID. Two job control processes will be exec...

What's in the Batch or Sequencer job logs, is anything running? Can you run a single job and see if it works? We need a lot more information. Does anything work?

1. Physical deletes do not reclaim space, you'll still have gaps where the rows "used" to be. A column that indicates the row is "voided" is the preferable architectural solution. Rather than delete, you could update this indicator column. By excluding rows that have this set, you avoid all of the n...