DSXchange

Welcome aboard! :D It's not really clear from your description what you are trying to achieve. Is it some kind of summary report - totals for each separate file sequence number perhaps? Basically, you need the XMLReader stage to strip off the tags and create a stream of data. Process that stream of ...

My bad. Poor attention to detail after a 13 hour work day testing.

At sites where I am the team leader, we use job templates as much as possible. Almost the first things set up are jobs containing the full set of standard parameters. Any job created from such a template can delete any parameters it does not actually require. This method has the additional advantage...

You can also use DSLogEvent to write into a different job's log.

You can also use UtilityMessageToLog or UtilityWarningToLog routines.

Good thought, provided the sync() was successful.

Arnd will edit his post to correct a small syntax error shortly. Then I will edit this post to remove the first paragraph. :D

If you have the "." in your data, you can more simply use the Convert() function.

It would not be a problem from DataStage's point of view - it's just a client. You may need to change some entries in .odbc.ini, and the driver versions may or may not be compatible with your database version (particularly for Informix), but neither of these are actually DataStage problems. It may b...

Just the obvious one - make sure that the schema (metadata) on both sides of the Transformer match.

Are they errors (red icon) or warnings (yellow icon)? Warnings can be issued to inform you that something unusual - not necessarily wrong - has occurred. In this case, since you did not specify change values, the CDC stage is reporting to you that it had to set defaults, which might be a vital piece...

Just an observation in passing. I teach never to use that form for sqlplus connection string. The reason is that your password is exposed; anyone looking at the processes (using a ps -ef command on UNIX) or anyone looking over your shoulder at the screen will be able to see your Oracle password. Be...

Welcome aboard! :D As the other posters have said, Ascential does not currently offer anything like a personal edition of DataStage - you either buy a full licence or nothing. If there is a reasonable prospect of a sale, some vendors may arrange an evaluation licence - a full licence with an expiry ...

Welcome aboard! :D

Yes, the buildop is the nearest equivalent in PX to the (transform function) routine in server jobs.

Take a look at Chapter 55 of the Parallel Job Developer's Guide for more information on custom, build and wrapped stages.

That is true, and I probably ought to have mentioned it rather than responding to the specific "with dsjob" in the original question. But I agree with Vincent that they're much easier to control out of DataStage, and there are then a whole lot of data reformatting operations (still can't lose the IN...

The telnet service is irrelevant. It operates on port 23. The service that is causing the problem is the DataStage RPC service; it operates on port 31538 (unless you've changed it). That's the one you should be checking in the firewall. The terminology "RPC daemon" comes from UNIX - the messages are...

That information is not in the public domain, and 7.5 is still new enough that those of is who do haven't really had a good hack at it yet. My guess is that the checkpoint information is stored somewhere in the repository hashed file (table) called RT_STATUSnnn, where nnn is the job number of the Jo...