DSXchange

stuartjvnorton wrote:Rinse and repeat.

I love it!!!

Access to Unidata is through UniODBC so the date format should be YYYY-MM-DD (which is what you did, according to your post). You can verify this in the database by executing the same query. SELECT columns FROM table WHERE REG_DATE = '2009-11-25'; Access is through SQL, so Iconv/Oconv should not com...

VMark Software brought out version 1.0. They went through a merger with Unidata to form Ardent Software. Versions 3.0 through 5.2. Ardent was in turn acquired by Informix Corporation. Informix sold all its database products to IBM in 1999/2000 and renamed itself Ascential Software. Versions 6.0 thro...

Get someone to investigate what's happening once the IDOCs reach SAP.

Why store configuration files in the etc directory? Why not store them in the Configurations directory? But it strikes me as odd that having only read access to the configuration file ought not to prevent opening of the Administrator client. After all, every user is entitled to use this client to in...

Using a BASIC Transformer stage: (I have tested this one and it does work.)

Before you started designing you have a source-to-target mapping document of some kind. Create a corresponding unit test document which specifies, for each transformation, a set of expected results. Record the actual result beside each, then address discrepancies. When contemplating your test data, ...

One data set will suffice. Each reference input to your Lookup stage creates a separate virtual Data Set into which the reference data are read and build an index on the identified key (the LUT_CreateOp operator). So you do actually have separate data sets at run time - you don't have to design this...

On the server, in the DataStage engine directory, execute the following command from an operating shell after executing the dsenv script. Client license seats available and in use are reported at the end of the report.

Please elucidate how this is the same issue - how a problem whose symptom is NLS map related can be fixed by tweaking array size.

I do not know of any way that this is possible, so I seek your enlightened guidance.

1.0
1.1
1.2
2.0
2.1
2.2
3.0
3.5
2.5
3.6
4.0
4.1
4.2
5.0
5.2
6.0
7.0
7.1
7.5
8.0
8.1

Perhaps there's no problem between your friend's keyboard and chair?

Do you have identically-installed client software?

What is "valid"?

Is "R2D2" valid in a name context?

That's not the right question. Is "R2D2" (or "kennedy123" for that matter) valid in YOUR name context?

There is an infinite number of ways, and therefore no-one is going to attempt to do what you ask. From my experience you do it by running data through Standardization then use Investigation on the unhandled patterns/data - at least the most frequently-occurring ones - to refine your rules. Since you...

There is no Change Capture stage in WebSphere Transformation Extender (formerly known as DataStage TX). If you post in the correct forum, you might receive more cogent answers. If you post the same question in multiple fora, you will get exasperated answers from regular posters, who reasonably consi...