DSXchange

The only place you have any customization control is by managing the JCL templates. As far as I am aware you can not influence the COBOL source that is generated. But I'd be happy to be corrected.

There's no job of that name (DSJobReportDb) in any of my projects.

Presumably it's something that has been created locally at your site.

Can you be more specific with your question?

If it's the query that's returning different results at different times, that's not a DataStage issue, it's a database issue. Or it may be that it's not the same query - that the parameters used in the WHERE clause change between runs, for example. You have not provided enough information for cogent...

Correlated subqueries are always slowest. Not having an index on column B will cause a table scan to be required. Having an index on the target column will slow updates.

The main reason is that there is no version of SQL Server for UNIX.

What you envisage is not possible in the manner you envisage it. But you might be able to load one parameter with a string that is a comma-delimited list of values and somehow get that into an IN clause in the WHERE part of your extraction SQL. Something like: SELECT column_list FROM table WHERE col...

1. Is it possible to launch several job simultaneously in a job control ? Yes. 2.Why is disadvised to launch a job control with an other job control ? It's not. A hierarchy of control is a Good Thing. 3.I know that we can detach a job with DSDetachJob, is it necessary ? Yes, if you no longer requir...

Use the "Missing Columns Action" rule. Scroll right in the Columns grid to find it, or right click and choose Edit Row...

The r4 in your version number suggests you are running a "rapid repair fix" version. These have not gone through full QA, and therefore may have a bug in the scheduler interface. Check with your support provider; an upgrade to a later version (even if it's 6.x) may be needed. Can you post the cronta...

... or a configuration that uses only a single processing node.

Or a server job to process the single row.

It is not legally possible other than manually. You seek to load values from a Data Set into the list values associated with a List type job parameter. That has to be done at design time. Do you have the Data Set available at that time? Which of the values (if any) becomes the default value? Changin...

What Ajith is suggesting is that your string dates may contain more information than can be converted to a date type - for example they may really be timestamps, so that the time portion is lost so you get warned that this may be occurring.

ALL server job lookups are sparse, in that there is no intermediate virtual Data Set. As Kirtikumar notes, however, enabling row buffering has a similar effect to a virtual Data Set. Nevertheless, a query is executed against the database server (or hashed file) for each stream input row, buffering n...

From today's home page at DSXchange.

Another Membership Milestone!
15,000!

Do you think they mean 15,000, not 15,000 factorial?

For example, and especially in parallel jobs, you need to define what you mean by the term. Most stages support a reject-handling link, but what it means is different in different stage types.