DSXchange

If it's dumping wrong data how can you assert that "everything is fine"? Etiquette Note We do not do "urgent" here, so we do not do "imdtly" either. This is an all-volunteer site, as far as posting is concerned. If you want urgent answers, sign up with your support provider for premium service, and ...

Usually this occurs when the file system where your project resides becomes full. The tables that contain the status information (RT_STATUSnnn) can not be extended. (They may even become corrupted, but re-compiling can have the effect of clearing them and rebuilding from scratch.) It might be worth ...

You have to enable APT_DUMP_SCORE environment variable.
Hint: make it a job parameter, then you can choose whether or not to use on any particular job run.

Welcome aboard. :D This error is often caused by the configuration file having no nodes in the default node pool, which is not the case here. Is DataStage server installed on HOSTNAME ? That is, are all the pieces needed by the conductor process, such as access to DataStage logs, available on HOSTNA...

What do you want to do when you find a row out of sequence? You could run the stream through an Aggregator stage and assert that it's sorted - any out of order row will cause the job to abort. But this does not let you pick up the last value from the previous run, which you seem to indicate as a req...

I would bet money this command works in the next release. I doubt if the next release changes that much. Except that you may need to issue such a request via the Metadata Delivery service. The Repository database will not be (is not) UniVerse-based, and there's no guarantee that the table names wil...

DRS is Dynamic RDBMS Stage. It was introduced to allow the likes of PeopleSoft to deploy canned DataStage jobs to their customers; with a DRS you dynamically choose the database connection (e.g. DB2, Oracle, ODBC, SQL Server, etc), perhaps using a job parameter to specify it. As far as I am aware it...

Correct, if you had partitioned the data feeding the update links differently when creating them. Do you check what partitioning has been used?

... and get the apostrophes correct!!! Slightly more seriously - not that I'm flippant about misuse of apostrophes - common sense ought to prevail in ETL design, and Kim has summed it up fairly well. It is an unfortunate fact that common sense is not nearly as common as once thought. It is another u...

Entire guarantees that all records will exist on each partition, so all valid lookups will work. If you use any other partitioning algorithm with the Lookup, Merge or Join stages you must make sure that the Data Sets are identically (sorted and) partitioned on the lookup key columns.

It is not possible to run a routine from a shell script because there exists no argument passing mechanism. When you test a routine in the routine editor, it actually builds a "test bed" (a main program) that is used for passing the arguments from the test grid. This test bed program is discarded wh...

Design your algorithm on paper and from that produce a design plan and test plan. Generate some test cases and document these. In the Repository choose New Server Routine. Make sure that the routine type is "Transform Function" (this should be the default). Document the routine on the General tab. G...

What is your test plan to ensure that things behave the same before and afterwards? Do you have a documented test plan and appropriate test data? If not, why not? Does your client not require that you prove that the behaviour is unchanged (other than as documented with the product)?

The number of spaces is irrelevant. The Field() function I provided counts them in order to yield the final delimited field. If there are trailing spaces, you might like to apply a TrimB() function before applying the Field() function. Field(TrimB(InLink.Address), " ", Count...

Do you have row buffering enabled in this job and, if so, is it in process or inter-process?