DSXchange

RCP doesn't (can't) perform metadata checking.

This has to be a bug. DSD.RUN is one of "theirs". dyn_replace assigns a value to an element of a dynamic array. The code should be loading the value 11 into field 2 of the dynamic array called JOB. Involve your official support provider. It may be that a vital run time option has been omit...

Random thought: I wonder if it's rounding based on the oddness-evenness of the final digit? What happened on the third day? If my hypothesis holds up, it should add one day. Of course if it were working properly, it shouldn't add or subtract at all! Maybe you need to effect DecimalToString() earlier...

Show us how you configured your Filter stage, in particular the filter WHERE clauses and associated output link identifications.

Ah. An easy question. You can't.

You ask them how long is a piece of string, enumerate maybe half a dozen of the variable factors, then get them to do one. That's the best estimate of elapsed time you're going to get.

The DataStage Resource Estimation tool will estimate resources required, but not elapsed time.

Welcome aboard. This seems to be a similar requirement to that posted by bicap earlier today. Perhaps you've been to the same interview? It's readily enough done using Runtime Column Propagation except that, if you have to mention a column name in your logic, that column name must appear in your met...

Welcome aboard. When's the interview? Why the requirement to use partitioning technology? It probably can be done, but would not be for the faint-hearted. As SURA suggests, the partitioning technology handles from one to a countably infinite number of processing nodes, so you would need to devise a ...

So what you've sent to Teradata is the equivalent of UPDATE stuff WHERE 1=0 and it didn't like it. You need to re-design to avoid this situation.

What reason for Abort is given in the job log?

We can't see your system!

That's pretty straightforward. Parameterise the table name and use the same parameter in the text file name. Use RPC throughout (you effectively get select * from table happening). Loop through a list of table names obtained from the database's system tables to get the names. Maybe create a simple (...

I have to read from Database and write into a DataSet from all the available tables in each schema by using a single DataStage job. Why? A DataStage Data Set can only have a single record structure. So, unless every single one of these tables has the same record structure, or your single DataStage ...

What does the source actually put into those fields to represent NULL? That's what you must have as the Null Field Value property. If they are actually empty, try using double quotes rather than single quotes for Null Field Value. If you have a fixed-width format, however, you need the Null Field Va...

And do you have a reject link from the Sequential File stage also? You need to be able to handle the case that the data don't match the metadata.

I think that that is how it should work. It's the same concept as grouping all the nulls together when sorting - it's not an assertion that they're equal, but it is saying that they're "together" in some sense.