DSXchange

There is a requirement for the Join and Merge stages that the input Data Sets be identically partitioned and sorted on all the join keys. Have you configured this? A Lookup stage has the same requirement or, if you do not want to sort the primary input Data Set, that the reference inputs use Entire ...

You can invoke commands such as echo or touch via a call to the DSExecute subroutine. The touch.exe executable may be found in the DataStage bin folder.

Does it "reset then run" or simply "reset"? Is the reset successful? Find out from the job log of the previously aborted job.

I suspect Ross is referring to this site which you can also access from my profile.

As noted earlier, it's then up to you to put the data together in such a fashion as to identify sub-sub-sequences and lower. The query does not do that. It can be done with a routine.

Not certain what J\68\V0S0R0 is meant to be. Are you sure it's not J\68\V0S0P0 ?

There is currently only one Windows version available (7.5x2) that has the ability to execute parallel jobs. If you're one of those who never gets the first version of anything, you might prefer to stay away.

Note also that Server Edition on UNIX can not execute parallel jobs.

There is no out of the box function. It is easy enough to write one.

Add Int(Months/12) to the years.

Add Mod(Months,12) to the months.

Adjust if the new months figure is greater than 12.

Adjust by subtracting days if the number of days in the new month is illegal.

Search the Forum. You may need to add them, using the Administrator client.

It is vital that both Data Sets are identically partitioned on the comparison keys, so that valid comparisons will be performed. It is highly desirable that both Data Sets are identically sorted on the comparison keys, so that efficient use can be made of memory. What do you mean by "the desired res...

Looks like you're selecting from a non-partitioned table using a partitioning algorithm, hence you're getting all records on each node - effectively Entire partitioning.

... and all that with a new baby in the house. I guess not being able to sleep helps when moderating a 24x7 site! Congratulations.

The vendor's "Best Practices" class used to teach that staging prior to loading was best practice. Primarily, as you say, for restartability, and because you can do all the transformation logic even if the target database is unavailable. I have not seen this class for some time, so do not know if th...

I presume you're getting <<Error>> in the Test grid when testing the routine. What do you see when you double click on this result cell? Add DSLogInfo() calls to your code to display the values of variables. Call DSLogInfo("Value of job_link is " : Quote(job_link), "Testin...

Go to the Columns tab. Scroll the grid to the right. Set the "column contains line terminators" property. Note that this can not be set for the last column in the line - the workaround is to define a dummy final column and set its "missing column" property to "Discard".