DSXchange

OutLook is different. Try using an SMTP mail client from Windows. Ideally try using the same one that DataStage is using, and switch on any tracing that may be available with it.

You found it, but did not realize it. The LOCKED clause is indeed what you want. $INCLUDE UNIVERSE.INCLUDE RECORDLOCKED.H Equate MAXTRIES To 5 ; * maximum number of attempts Equate NAPTIME To 1500 ; * 1.5 seconds For Attempt = 1 To MAXTRIES FileLock HashedTargetFile Locked Nap NAPTIME End ; * end of...

There are no programming tricks - the Sequential File stage already uses the STREAMS I/O module. What else is happening? Are you getting contention on the disk, so that the heads keep being moved away from this file? Try a test where the file is the only thing being accessed on its spindle (an ideal...

Restart only skips leading checkpointed activities, not all checkpointed activities. Restart is from the first activity that does not have a checkpoint, resulting from unsuccessful completion. ("Do not checkpoint run" activities are executed, but later checkpointed activities can still be ...

I disagree with Rai - metadata reporting/management is vital for everyone, in my opinion. Yes, budget is an issue. However, if you are paying maintenance on version 7.5, then the upgrade to version 8.0 is at no cost. You will, of course, incur greater hardware requirements. Server edition will be ma...

Do your lookup using a database stage with user-defined SQL. Specify start_date as the Key column (it means "search key" in this context) and include the parameter marker in a BETWEEN clause in the WHERE clause.

Split your data into two streams based on batch ID (Transformer stage).
The txnID value on each output link is given by the system variable @OUTROWNUM.
Done.

Neither is preferred, as you probably need both. Job auditing reports on things like row counts. Job sequence auditing reports on the logic and success/failure of execution flow.

Welcome aboard. My guess (since you did not provide any information about your job design) is that you have a Modify stage in which both of the following are true. (1) Field pl_id appears in a KEEP specification or does not appear in a DROP specification. (2) There is a specification that derives a ...

We await your post in the server forum. Or for the moderator to move this thread to that forum.

Please verify that sambi-acer is the network node name of the machine on which Information Server was installed, and that that name can be resolved to an IP address on the machine on which you are running Internet Explorer. Please also verify that Information Server, its associated database, and the...

Use a Column Import stage to re-parse the raw string.

You can get days between two dates (DaysFromDateSince() function). The rest should be arithmetic. However, you need to document your business rules thoroughly, and will probably need a custom function, to generate interval as years, months and days.

Yes, they use the electrical wall plug icon for Build stage.