DSXchange

Dump and examine the score to determine where any tsort operators might exist in the job (step) that actually gets executed.

Can PATH find the compiler?

Are there any compiler libraries that have to be findable via LD_LIBRARY_PATH?

Just get it right. If the data can contain nulls, mark them as nullable and handle the nulls. If the data can not contain nulls, do neither of these things.

Welcome aboard.

There's a few ways you could achieve this, the most maintainable of which is probably a DataStage routine that effects the same logic.

You could use a heap of nested pxEreplace() functions (which, again, is a DataStage routine).

Can you capture the real time data from the same source as SQL Server is capturing it from? If you wait till it's in SQL Server it's not real time any more. The next best thing is some kind of CDC approach, for example scraping the SQL Server transaction logs. Investigate IBM's CDC product and IBM's...

... then you can return your DataStage for a refund!



That said, DataStage can perform a read of this file, but you have not specified entirely what you want to do with the data.

You can, for example, parse name=value pairs using Field() functions.

DATA.30, OVER.30 and .Type30 files.

This is because the new VOC was created as a dynamic hashed file rather than the usual static hashed file.

There's no good reason for doing this, imho. Can you please ask IBM support why they suggested it?

You might look at an input pattern override. I presume that the H-2462 is a postal code of some kind. An input pattern override could parse this into a postal code field or discard it (whichever is appropriate). You could edit the pattern-action language to achieve the same result, but that would me...

You must handle the nulls before essaying the use of any other function in the Transformer stage.

Did you install the supported C++ compiler? Did you correctly set the environment variables that control the compiler and linker?

What we are asking is whether it's really a tilde in the data in the table, or some other character that displays as a tilde in some viewers.

Three streams of processing, entry to one driven by Filter stage (or Transformer stage constraints).

What have your own investigations revealed?

Who knows? For what purpose is this POC? Does the prospect have no idea at all of what function they require?

Search DSXchange for solutions using the Index() function.