DSXchange

As a workaround I set up PWD as a user-defined environment in the project, with a default value of . (that is, the current directory).

Define "performance" in an ETL context.

Unless you know what "performance" is, there's no point trying to improve it.

For example, in a mainframe environment where you're being billed for MIPS, the elapsed time metric may be secondary to using the smallest number of MIPS.

How we can achieve hash file functionality in parallel jobs? May I ask why you feel it is necessary to do this? You may be able to use ODBC, with the localuv data source, or you may be able to use an External Source stage invoking dssh with an appropriate query on its command line. I am not in a po...

Another idea - put the list of country codes into COMMON to avoid reconstructing it on every invocation of the routine.

Welcome aboard.

There is no general solution for unit testing. The general principles devolve around identifying where likely problems might occur and checking that your code handles them. Test data should include legal values, illegal values, out of range values and boundary values.

You need to inspect the log of Job J_Stage_PS_BUS_UNIT_TBL_SF_CS_CS9_EPM9 to determine why it failed.

Tip: you can get from the sequence log to the job log by right clicking on the "job run requested" event and choosing "Related Log".

Planning, Installation and Configuration Guide. Search therein for "DataStage Credentials".

The issue is nothing to do with SORT order, so please begin a new thread. This will aid future searchers. Indeed, you might essay a Search yourself, since this question has been answered on DSXchange in the past.

No, but it appears that you can. What you're actually doing, on the Input tab, Partitioning, is setting up sorting on the input link to the stage, rather than within the stage itself. This will become a separate tsort operator in the compiled job. Don't forget to partition and sort both inputs ident...

Yes it's in 8.0 (and later, of course).

You can compare jobs or table definitions within the one project, you can compare jobs across projects. So it ideally suits your requirement.

Assign the DataStage Operator role to the user. Make sure that the user does not receive roles from any group membership. The user can now only run released jobs (so you would need to implement the "release" mechanism). You could, instead, use the Super Operator role, which would allow the...

Is the host name to IP address mapping available (can you ping the hostname)? If not, make it available in the hosts file.

What have YOU tried? Generally speaking DSXchange is not in the business of "providing solutions", though some of us do that professionally. It looks like a routine would be the easiest approach, one that uses the logic that you have outlined.

Create a new field of type date and marked as Key. Derive the value as CurrentDate() - 364. Supply this as the value to the database stage, and use Where (DayDt=?)

InfoSphere is just another brand within IBM Software Group. So, technically, it is IBM who owns the product formerly known as Mercator.