DSXchange

Check your Oraacle manuals - is lower case u-umlaut handled in this map?

Also, what map have you set for DataStage?

The client has MKS Toolkit. It installs with Enterprise Edition on Windows.

Earlier you were complaining about needing to do this 100 times. Presumably you are now happy with that.

The STATUS statement, documented in the Server Job Developer's Guide, returns a dynamic array relating to the file open on its file variable. One of the elements of this dynamic array is the file size in bytes. So all you need to do is read the manual, and you'll have it all. Note that the STATUS st...

The pathname needs to be quoted - Windows O/S thinks the "/" is a switch.

LOCATE will not do a partial string search. You need the FINDSTR statement. By the way, if you OPEN the directory and READ the entire file in a single read statement, you will automatically have your dynamic array.

It is a requirement of the Funnel stage that the record schema on the inputs and output links are all identical. At least structurally.

How is the Preserve Partitioning flag set on the stage that is upstream of the Aggregator?

srini.dw wrote:Thanks for the response,

but I need to write a PX routine to delete a dataset.

Thank You,

No you don't.
If you must have a routine, it must ultimately invoke orchadmin command.
There is no other safe way to delete a Data Set.

Probably worth writing a routine if there are that many.

Start by sharing what your definition of "performance" is in an ETL context.

Tip: Rows/second is an almost entirely meaningless metric.

Welcome aboard. IBM Information Server is the underlying technology behind DataStage version 8.0 and later (that is, not 7.5). The most recently released version is 8.1. DataStage PX was not a long-lived name. It was dreamed up by Ascential Marketing to mean "parallel extender" but it wasn...

dr.murthy wrote:Hi,

just try with this Field(inputcolumn, ',' ,2).it works fine.

Not if the delimiter is ";".

Attention to detail is SO important in this kind of work.

Did you completely uninstall (including cleaning out the Registry)?

That might stop you seeing something in the 62.87.1.* domain from the 62.87.6.* domain.