Search found 53125 matches

by ray.wurlod
Wed Jun 06, 2007 8:34 pm
Forum: General
Topic: Wrong dates in Hash File
Replies: 9
Views: 4030

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

Code: Select all

DIGITS(Field(InLink.TheColumn,"-",1,3))
by ray.wurlod
Wed Jun 06, 2007 1:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequence Job Parameter passed to each jobs it runs
Replies: 4
Views: 1288

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...
by ray.wurlod
Wed Jun 06, 2007 1:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: about passing parameters dynamically
Replies: 10
Views: 2473

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).
by ray.wurlod
Wed Jun 06, 2007 1:37 am
Forum: General
Topic: How to Remove Duplicates?
Replies: 14
Views: 5319

OK, count them (Aggregator) and run them through a Filter stage passing only those with count = 1.
by ray.wurlod
Wed Jun 06, 2007 1:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Running parallel jobs on XP PROF OS
Replies: 7
Views: 1847

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...
by ray.wurlod
Wed Jun 06, 2007 1:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Aggregator stage - counts
Replies: 7
Views: 5918

Change the method to Calculation, then you can - for example - count non-missing values of a particular input column.
by ray.wurlod
Wed Jun 06, 2007 1:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Escape Character in ExecSH Routine Activity Sequence Job
Replies: 2
Views: 1863

Arnd makes the point that, since parentheses are meaningful to the shell, they need to be escaped, hence "\(" and "\)".
by ray.wurlod
Wed Jun 06, 2007 1:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Initialize parameter
Replies: 3
Views: 1076

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).
by ray.wurlod
Wed Jun 06, 2007 1:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage
Replies: 4
Views: 1095

#27 contains its own answer.
by ray.wurlod
Wed Jun 06, 2007 1:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: julian to timestamp
Replies: 6
Views: 1656

The integer that's coming in is the "Julian day" expected by the function. It is the number of days since "day zero".
by ray.wurlod
Wed Jun 06, 2007 1:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORACLE Open Command
Replies: 15
Views: 6157

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.
by ray.wurlod
Wed Jun 06, 2007 1:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Join Stage
Replies: 5
Views: 1390

Re: Hi

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...
by ray.wurlod
Wed Jun 06, 2007 1:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2 Bulk Load
Replies: 6
Views: 2186

Read the on-line help or the manual chapter for this stage, in particular its requirement for connected links.
by ray.wurlod
Wed Jun 06, 2007 12:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hitting a hash file with a partial key - will that work??
Replies: 2
Views: 837

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...
by ray.wurlod
Wed Jun 06, 2007 12:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Log file corrupted
Replies: 3
Views: 1338

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.