DSXchange

If you want to change the value when you request a job run, add the environment variable to the job as a job parameter. Set the default value of the job parameter to be $PROJDEF or $ENV. The first will pick up the value from whatever has been set in Administrator, the second will pick up the value f...

I read that as Santosh admitting that Santosh's way is not an excellent way, merely offered as an alternative.

Columns for DataStage log tables are: @ID INTEGER displayed 10 characters wide with leading zeroes TYPE TINYINT encoded severity value WAVE.NO INTEGER internal uniqueness number used by DataStage FULL.TEXT VARCHAR text of the log event SEVERITY VARCHAR decoded severity value e.g. "Info", &...

In Appendix A of the Parallel Job Developers Guide is a list of all the Transformer stage functions. My first guess would be to use DaysSinceFromDate(). In a Modify stage this function is called days_since_from_date() My second guess would be to apply JulianDayFromDate() to both dates and subtract. ...

OK, I'll take your word for it. The most recent advanced class I've seen is for version 7.5 (course code DX436). And there's nothing newer mentioned in IBM's Course Catalog for Jan-Jun 2008. There is, however, an essentials class for version 8 (course code DX444). Based on IBM's course coding conven...

Sounds like a reasonable request to me, but you may not need to. Open Director then, from the View menu, disable the display of Categories. Click on the Last Ran column heading to sort by last run date. I think that's what you're after - no need for Excel at all. From the Project menu you can choose...

Please verify that "automatically handle activities that fail" is checked and, when it is, re-compile just to make sure. Let us know (I'm sure you will).

The full answer to that involves a deep technical understanding of the IEEE standard that describes storage in a specific-sized binary structure of floating point numbers.

The non-technical answer is "because that's how it is".

Job1 needs an OK trigger or a Custom trigger, one that does not handle Failure (an Unconditional trigger does "handle" failure). When Job1 aborts, the Exception Handler should fire, provided that the "automatically handle activities that fail" check box in job properties is checked.

The result of Fabs() is a dfloat. Floating point numbers can not be represented accurately in computers. That is an artifact of they way they are stored: not of anything in DataStage.

Please try to choose more meaningful subject lines. The error is being generated when DataStage is checking the licensing (the "APT_LicenseOperator" in the error message). Either your licence is not valid or you have not made the PXEngine components visible/accessible on all nodes in your configura...

IBM has a version 8 class for essentials, and will be releasing an advanced class sometime soon. I have no information about whether or not they are planning an administration class - contact IBM Learning Services. That said, the version 7.5 classes for advanced and administration have a high degree...

No, it's a server job function (DataStage BASIC). It can be used in the BASIC Transformer stage in parallel jobs. In parallel jobs use the Abs() function, which returns a dfloat result, to remove the sign from a number. To remove leading zeroes the target field must be a string of some kind, and you...

What are the "leading characters" that you want to trim? What syntax of the Trim() function you are using? TrimB() trims trailing white space characters, not leading - you need TrimF() for leading white space. Do your data in fact have leading white space? Further, if you have 45 non-white-space cha...

Have they created the entire Data Warehouse database without transaction logging?

If not, you only need to create transaction logging on the table; it was the table that had a WITH NO LOG in its CREATE TABLE statement.