DSXchange

If InLink.TheColumn has the value "2006-11-13-00.52.50.932000" then a suitable expression would be:

As advised, check that the passing has been set up within the Job activities. Also check the job log of the job sequence to see with what parameter values the jobs were called, and in the individual job logs ("job starting" event) or in the detail status for each of the called jobs to see what param...

Once a job has started you can not change its parameter values. They must be changed before the job starts - that is, in the controlling job (sequence).

OK, count them (Aggregator) and run them through a Filter stage passing only those with count = 1.

DataStage version 7.5x2 can be installed on Windows XP professional, but you would receive the "not supported platform" if you tried to install it on Windows XP home. I suspect this is the case here. You do NOT need to "install on a Virtual computer which runs the UNIX operating system". MKS Toolkit...

Change the method to Calculation, then you can - for example - count non-missing values of a particular input column.

Arnd makes the point that, since parentheses are meaningful to the shell, they need to be escaped, hence "\(" and "\)".

Assuming that you're initializing the parameter in a job sequence, the DataStage macros and constants ARE available (version 7.5). So you can use DSJobStartTimestamp (macro).

#27 contains its own answer.

The integer that's coming in is the "Julian day" expected by the function. It is the number of days since "day zero".

Is it your table? That is, are you the creator? Otherwise fully qualify the table name. DELETE FROM #Schema#.TABLE WHERE 1 = 1; (It may be that DELETE without WHERE has been barred, so include a WHERE condition that is always true to delete all rows.) The trailing semi-colon may not be needed.

Chek ur partitoning method.but if u r working on default node 1 then result would be same even hash or moduls.Ans for join ur input link to join stage must be sorted.... Grammatical Notes Ur was a city in ancient Babylon. The second person pronoun is "you", not "u". Its possessive form is "your", n...

Read the on-line help or the manual chapter for this stage, in particular its requirement for connected links.

For lookups against hashed files, the rule is "the key, the whole key and nothing but the key", referring to the hashed file's key. Partial key lookups against hashed files are not supported. If you perform partial key selects against an Oracle table, you may get more than one row returned. Moving t...

These days fixtool is the preferred repair utility, rather than uvfixfile. It takes a -H or -help command line argument to give you a syntax summary.