Search found 53125 matches

by ray.wurlod
Tue Mar 04, 2008 5:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel Jobs not compiling/running
Replies: 3
Views: 961

The problem is that you do not have a properly installed/configured C++ compiler.
by ray.wurlod
Tue Mar 04, 2008 5:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: LAST DATE OF A MONTH
Replies: 3
Views: 1021

LastDayCurrentMonth, FirstDayNextMonth, ThisDayNextMonth, LastDayLastMonth, FirstDayLastMonth, ThisDayLastMonth are all good columns to have in a time dimension table.
by ray.wurlod
Tue Mar 04, 2008 5:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: migrating a mainframe job to parallel job?
Replies: 5
Views: 903

It is not possible. The stage types are different, the mode of thinking behind them is different. You need to analyze the logic of the mainframe job and implement that logic as a parallel job.
by ray.wurlod
Tue Mar 04, 2008 5:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ISSUE WHILE CONNECTING ORACLE
Replies: 9
Views: 2563

You need to find a colleague conversant with Oracle client software. The tnsnames.ora is one of the fundamental Oracle client configuration files. Involve your Oracle DBA.
by ray.wurlod
Tue Mar 04, 2008 5:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Insert not happening when the job is run through sequencer
Replies: 4
Views: 799

sumesh.abraham wrote:The paramters are correctly specified in the sequencer.
How can/did you prove this?
by ray.wurlod
Tue Mar 04, 2008 5:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while taking export of Datastage project
Replies: 3
Views: 1541

It may be a job for which only the executables were imported. In this case there is no ROOT record; attempting to open such a job in Designer or Manager will result in "this job has no design time information" error.
by ray.wurlod
Tue Mar 04, 2008 5:06 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sequence job in loop getting aborted
Replies: 12
Views: 3224

No, there's no time awareness, but the Iconv() functions mean that you are working with seconds, at least conceptually. Yes, they're meaningless in the context of the loop, but fundamental to my explanation of why you might be seeing -14 errors being thrown.
by ray.wurlod
Tue Mar 04, 2008 5:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: lookup options
Replies: 1
Views: 553

Welcome aboard.

Look carefully at what you are doing. These expressions govern the conditional lookup capability - they determine whether or not even to attempt the lookup.
by ray.wurlod
Tue Mar 04, 2008 5:03 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: converting string to timestamp
Replies: 7
Views: 1368

If your number is of the form 20080303 and you have converted it to a string then you can use StringToDate() but you must provide the correct format string ("%yyyy%mm%dd", with no delimiters). Because you have a string, you can concatenate the time portion and use StringToTimestamp(). Again you need...
by ray.wurlod
Tue Mar 04, 2008 4:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash Files
Replies: 4
Views: 1224

The number of types of hash file is zero. There is no such thing as a hash file. The term you're looking for is "hashed file". There are eighteen different kinds. Stick with the default unless you have very good reason not to: it works well in the vast majority of cases, and you thereby have one les...
by ray.wurlod
Tue Mar 04, 2008 4:53 pm
Forum: General
Topic: initial project creation fails, creates javacore .txt file
Replies: 7
Views: 4054

That only tells you that (a) the dsrpc daemon is running and (b) there are no other processes waiting on the port. You really do need to involve your support provider here - there may well be more Java components in version 8 than in version 7. Is the javacore file really text? That is, can you view...
by ray.wurlod
Tue Mar 04, 2008 6:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage equivalent for 'Scan' function of SAS
Replies: 1
Views: 1247

There's nothing out of the box. You would need to write your own. If the number of delimiters is limited to one, then you can find the rightmost delimited substring readily using a combination of Field() and DCount() functions.
by ray.wurlod
Tue Mar 04, 2008 6:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while File Set creation
Replies: 14
Views: 6521

There are several stages that expect a particular node pool or disk pool to exist, and which log a message indicating that they will use the default pool when the expected pool is not found. For example, as you've found, a File Set stage expects a pool called import or export (depending on what you'...
by ray.wurlod
Tue Mar 04, 2008 6:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: converting string to timestamp
Replies: 7
Views: 1368

Please post not only the derivation but also one or two samples of the strings you are attempting to convert.
by ray.wurlod
Tue Mar 04, 2008 6:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Regarding the residense of log files in datastage.
Replies: 13
Views: 5414

I disagree with Arnd. There is almost complete metadata for job logs in the file dictionary of RT_LOG. I have posted the same on DSXchange in the past. The problem is that you are blocked from importing it into the Repository (though you can work around even that).