Search found 53125 matches

by ray.wurlod
Thu Mar 13, 2008 2:21 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dynamic ETL process - Performance fix
Replies: 6
Views: 1712

Re: Dynamic ETL process - Performance fix

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?
by ray.wurlod
Thu Mar 13, 2008 2:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Running Both Server and Parallel Jobs in the Same Project
Replies: 3
Views: 1013

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.
by ray.wurlod
Thu Mar 13, 2008 2:16 am
Forum: General
Topic: ODBC connectivity issue for SQL server
Replies: 3
Views: 10231

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...
by ray.wurlod
Thu Mar 13, 2008 2:14 am
Forum: General
Topic: DataStage 7.5.2 MVS
Replies: 8
Views: 3817

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.
by ray.wurlod
Thu Mar 13, 2008 2:12 am
Forum: General
Topic: USE FUNCTIONS LIKE DateFromDaysSince() IN PARALLEL ROUTINES?
Replies: 9
Views: 2614

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.
by ray.wurlod
Wed Mar 12, 2008 11:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Left Outer Join - Urgent :(
Replies: 6
Views: 1488

We don't do "urgent" here. DSXchange is a community of all-volunteer participants who post as and when they can. If you require urgent support sign up with your support provider for premium service, and learn the true cost of "urgent".
by ray.wurlod
Wed Mar 12, 2008 11:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Left Outer Join - Urgent :(
Replies: 6
Views: 1488

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).
by ray.wurlod
Wed Mar 12, 2008 11:14 pm
Forum: General
Topic: USE FUNCTIONS LIKE DateFromDaysSince() IN PARALLEL ROUTINES?
Replies: 9
Views: 2614

C:\Program Files\Ascential\DataStage\Docs\parjdev.pdf
by ray.wurlod
Wed Mar 12, 2008 7:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ds_ipcput() - Error in mutex_unlock() - Not owner
Replies: 2
Views: 1512

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...
by ray.wurlod
Wed Mar 12, 2008 7:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: not abl to read flatfile with quote as double
Replies: 4
Views: 1183

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.
by ray.wurlod
Wed Mar 12, 2008 5:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with the Job Monitor
Replies: 20
Views: 5854

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...
by ray.wurlod
Wed Mar 12, 2008 5:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Enumeration List of SQL-Constants
Replies: 3
Views: 1138

It's in a header file called JOBCONTROL.H in the DSINCLUDE sub-directory in your project.
by ray.wurlod
Wed Mar 12, 2008 5:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Variable length columns
Replies: 2
Views: 928

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.
by ray.wurlod
Wed Mar 12, 2008 5:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DateTime using RowGenerator gives incorrect output
Replies: 15
Views: 4098

That is a singularly lazy response from support! :shock:
by ray.wurlod
Wed Mar 12, 2008 5:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Link Count
Replies: 22
Views: 6577

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