DSXchange

Yes, this could be the cause. It's expecting the terminator, but finding the data listed. It's not 100% that it's the problem, but it's worth looking at. Let's say you have an input with 4 different record types, Header, detail 1, detail 2, detail 3. Each has an initiator, H, D1, D2, and D3. While t...

jvmerc wrote:

ray.wurlod wrote:...This product used to be called DataStage TX,....

This tool used to be called Mercator and I think before that it was TSI?

I think TSI was the company that owned/supported it. I believe they also owned Trading Parnter PC.

I just heard about this. I was wondering if anyone had info on had they will integrate the products. I've been trying to get experience with GIS (sterling integration tool) to have a more rounded resume, but never found a job willing to train. Now it looks like I may not have to, but if the plan is ...

<5120-3920>: INSERT INTO TABLE_THREE VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) <5120-3920>: OLE DB Error code: 0x80040e2f <5120-3920>: The statement has been terminated. <5120-3920>: The following values were being inserted: It has been a very long time since I've connected to a DB. Years, litteraly. F...

While I've upgraded on Windows machines and Unix machines, I have never upgraded across a platform, but from what I understand, it shouldn't be much of a change. First and obviously, you have to change your deployment servers in your msl files to AIX from UNIX-HP. Second, you're going to have to set...

You should have no problems using wildcards; I haven't. I usually use something like; *.txt I haven't had the need to use ?. I have had wierd error messages on "shadow file rename failure" inregards to using wildcards, but after messing around with it, trying different things, I would alwa...

Is there an option to implement Sequence generator/surrogate key generator functionality in Datastage TX 8.1; without the use of database create sequence? If I'm reading you correct, you have your DB key as an incrementing numeric and want to use TX to grab the next number? If so...and it's been a ...

In your reject functional map, do; IF(WORD(ERROR_REC, "," 1)="", ERROR_REC + "Contains Null values for Not Null fileds - ID ", //else IF(WORD(ERROR_REC, "," 2)="", ERROR_REC + "Contains Null values for Not Null fileds - NAME ") Does that so...

I don't believe you can have the install files without a "readme.txt" file, but.... No matter what, the development tools are only ever going to be install on a Windows desktop, where you build, compile and test maps. To run them on a Unix box (for example), you install LAUNCHER on the Uni...

So you removed the 'EITHER' and are only using the IF statments? Post the code.

First you set up the ODBC, then you open the mdq and point to that ODBC. If you did build your type tree from the table via the MDQ, you're halfway there. Once you can see the table in the MDQ file, you want to set the update key's first, then build the type tree. You point your output card to the t...

It's not going to be easy without seeing the input data and knowing what you're trying to anticipate, but I will say this; EITHER says "do the first thing that does not equal none". So if you say EITHER (LOOKUP(FIELD)), LOOKUP(FIELD2))) If field=none, then it will attempt field2. If field2...

ODBC to what type of database? Oracle? Access?

Once you set up the ODBC via Windows, can you "test connection" successfully?

A few files are created when you build a map; .mmc, .mopt, .bak, etc.

Delete everything except the mms and rebuild again.

You should be able to handle this. I used to have a system where; A nurse fills out a form, including an ID field, and sends the info as a Word Document. A VB program saves it as text file, and my system gets it. I do a DB look up to a table, DBLOOKUP() , to see if the nurses ID is present. If it is...