Search found 53125 matches

by ray.wurlod
Mon Jun 02, 2008 5:29 pm
Forum: Site/Forum
Topic: Search Filtered by Relevance
Replies: 0
Views: 1574

Search Filtered by Relevance

Would it be possible to enhance the Search mechanism so that only posts with a Relevance rating above a chosen value are displayed?
by ray.wurlod
Mon Jun 02, 2008 5:27 pm
Forum: General
Topic: Remove duplicates in Datastage MVS edition
Replies: 8
Views: 3621

It's the Spanish pronunciation of "job".
:lol:

Do you get a lot of alligators in California?
by ray.wurlod
Mon Jun 02, 2008 5:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not able to View Data. -- NLS Enabled
Replies: 13
Views: 5111

View Data is known to be a bit flaky where NLS is involved. Are the data being processed correctly? Can you view them using other techniques (such as text editor for text files, SQL for database tables, Data Set Management for Data Sets)?
by ray.wurlod
Mon Jun 02, 2008 5:22 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Capture the Director job run stats in excel
Replies: 2
Views: 1115

To use ag_ram's approach you will also need a third-party ODBC driver for Microsoft Excel. Unless you have one of these, you will almost certainly need to stage your data somewhere (such as a CSV file or a SQL Server table) from which Excel can retrieve them. The ETLStats utilities that you can down...
by ray.wurlod
Mon Jun 02, 2008 5:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Environment variable transporter
Replies: 13
Views: 5105

None of which I am aware.
by ray.wurlod
Mon Jun 02, 2008 5:14 pm
Forum: General
Topic: Parameterset in Datastage 8.0
Replies: 11
Views: 10575

The ability of a Parameter Set to read its default values from different files in different environments is a good feature to have.

Primarily the benefits of Parameter Sets can be summed up in the phrases "lower maintenance" and "developer productivity".
by ray.wurlod
Mon Jun 02, 2008 5:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error Importing Job in DataStage
Replies: 2
Views: 1336

Please post the exact error message. RT_CONFIG is nothing, not an executable job, not a repository table. The exact error message will have at least one more word, and a numeric component following RT_CONFIG.
by ray.wurlod
Mon Jun 02, 2008 5:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequencer issue
Replies: 30
Views: 8541

Show us, from the job log (unedited) which activities had checkpoints added. Even though they were cleared at the end.
by ray.wurlod
Mon Jun 02, 2008 5:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error 'type mismatch' everytime I paste objects
Replies: 3
Views: 1526

This could be a bug somewhere in the visual components of Designer. Report it through your support provider, and ask (and let us know) whether it's a known bug and, if so, whether there is a fix for it. Does it happen from all client machines at your site, or just one? If just one, you might like to...
by ray.wurlod
Mon Jun 02, 2008 5:00 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Losing Decimal Values
Replies: 2
Views: 1159

Try Decimal(17,2). The precision figure includes the scale digits.
Or try Oconv(InLink.TheAmount, "MD2") as your conversion.

AsDouble() and AsFloat() are pertinent only to parallel jobs.
by ray.wurlod
Mon Jun 02, 2008 4:57 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Retrieving Job name in error
Replies: 13
Views: 3358

Job Ano could be multi-instance, then you could call Ano.E and Ano.T from your job sequence without difficulty and only have one job design to maintain.
by ray.wurlod
Mon Jun 02, 2008 4:17 pm
Forum: General
Topic: Difference b/w the Change capture and difference stage
Replies: 1
Views: 1141

Change Capture stage was derived from, and intended to replace, Difference stage. The only difference is in how the output is generated. Output from a Difference stage is "simple", while output from Change Capture is in the form of a pair of sub-records plus the result, the more easily to be used wi...
by ray.wurlod
Mon Jun 02, 2008 4:11 pm
Forum: General
Topic: Remove duplicates in Datastage MVS edition
Replies: 8
Views: 3621

As far as I can tell without seeing the detail of your design (sort keys etc) it should be able to remove duplicates satisfactorily. There ought to be no need for more than one job. Are you sorting and aggregating (grouping) the same keys (the ones that identify "duplicates"? How are you getting the...
by ray.wurlod
Mon Jun 02, 2008 4:08 pm
Forum: General
Topic: Best way to abort a job
Replies: 13
Views: 5398

This thread, may I remind you again, is "best way to abort a job".
by ray.wurlod
Mon Jun 02, 2008 6:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: oracle warehouse to SAP warehouse
Replies: 1
Views: 730

Yes it is.

You will need some additionally purchased components for connecting to SAP BW - marketed as the SAP BW Load PACK.