DSXchange

arunnambi wrote:We ... changed to unix as it wont hamper performance compared to basic.
We are facing some performance issue with this script now.

What's wrong with this picture?

Both will run in the same project. You do not need to set anything, though you may wish to create more parallel execution configuration files to specify different degrees of parallelism.

The issue is exactly what the error message reports - the SQL syntax is incorrect somewhere near a "." character. Copy the SQL and paste it into some other client for SQL Server and you will find that it throws the same error message. You, or maybe someone with greater SQL expertise, then have to in...

Yes I have worked with MVS edition, albeit some time back. It is a COBOL generator and quite easy to use, in that it has comparatively few stage types. It also generates JCL to compile and execute the COBOL it generates. All of what it does can be customized/tuned by editing the JCL templates.

There is no header file. But there are descriptions of all the functions in an Appendix in the document to which I referred. You can construct your own prototypes from that and the APT classes which are also documented.

In theory the Join stage can have more than two inputs. This is taught on IBM classes. If it doesn't work, try a design that uses cascaded two-input join stages. Maybe it only works for inner joins (though this would be odd).

C:\Program Files\Ascential\DataStage\Docs\parjdev.pdf

Welcome aboard. Your long timeout probably means that you are hitting one of the mutex wait limits. Search the forum for SPINTRIES and SPINSLEEP, which allow you to tune the mutex lock mechanism. Search the internet for more information about how "semaphores" are implemented in some operating system...

Yes, if you set the quote character to None you get all the quote characters into your job where you can do something about it, rather than have the Sequential File stage spit the dummy.

APT_NO_JOBMON is set to false and APT_RECORD_COUNTS is also set to True. I have explicitly included these variables in my job and set their values. Still I am unable to see the record counts in my job. It only shows 0 rows. Are there record count entries in the job log? That should be the effect of...

It's in a header file called JOBCONTROL.H in the DSINCLUDE sub-directory in your project.

Declare more columns than you need, and set up default values for all.

Set up a Copy stage (or Transformer stage) to direct the different combinations of columns to different outputs.

That is a singularly lazy response from support!

Not till you tell us how, when and where (in the job or afterwards) you obtained these ones.