DSXchange

Do your sequential files contain binary data?

You have marked the post as resolved. What was the resolution?

You can set environment variables using Control Panel > System. Choose the Advanced tab and, from there, the Environment command button. You may need to re-boot (Microsoft's solution to everything) for the changes to take effect.

Where's the reject link beginning? Reject links from Sequential File stage, for example, contain only one column, containing the source row as a Raw string. This can certainly be written to a file. But the question of adding additional columns may become tricky - you would need to guarantee that the...

Where's the reject link beginning? Reject links from Sequential File stage, for example, contain only one column, containing the source row as a Raw string. This can certainly be written to a file. But the question of adding additional columns may become tricky - you would need to guarantee that the...

A BuildOp is different. A Custom stage is one kind of custom stage (!), a BuildOp is another. A Custom stage allows one to use an existing Orchestrate operator in some new and vitally interesting way. Maybe as simple as providing some other/different options.

chulett wrote:Why did I get a strange sense of deja vu when I read your post?

Oh, no! Not deja vu again!

The install process detects and prevents any attempt to install on a symbolic link. While I can't verify this at the moment, I suspect something of the sort might also apply to NFS-mounted file systems.

Indeed, the job sequence approach allows you the auto-restart for the low cost of checking a check box.

Welcome aboard. :D

If it's always the case that the number will precede the remainder and a space will occur between them, you could use the Field() function.

You can use this function in job control code. But you don't have to; use a Job activity in a job sequence, set it to "Reset if required, then run", and the generated code will contain an appropriate call to DSPrepareJob. However, note that the thread referred to does not provide any routine for com...

WHERE is the sequence. If you are using the SDK key managment routines, then you can update the SDKSequences file (search for details). If you're using stage variables, you can use an If..Then..Else in conjunction with change detection (the data need to be sorted by the natural key for this to work ...

Static hashed files are all those other types than Type 30. They have the advantage of less overhead when reading/writing, but the disadvantage that table space management is not automatic; they need to be tuned accurately to get full benefit. But, if the total volume of data is fairly constant, and...

Nothing special. Your user ID must belong to a group that has at least DataStage Developer role, unless you want to run only released jobs, in which case it an belong to the DataStage Operator role. And, of course, you need read/write permission and SQL privileges as appropriate to the objects you w...

At your site you have single-CPU PCs and (if I recall correctly) 36-CPU SunFire servers. Do you expect the same throughput on each? Do you really need all those IPC stages? Enabling inter-process row buffering will (in general) have the same effect. Are all the lookups in a single Transformer stage,...

I can only suggest that you involve the DBA to track exactly what query was received/executed by the database server.