Search found 61 matches
- Wed Dec 07, 2011 9:18 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: DataStage TX - Error Code 21
- Replies: 5
- Views: 27288
.....
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...
- Thu Nov 17, 2011 7:42 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: job is unable to come to finished state
- Replies: 5
- Views: 20562
- Thu Sep 02, 2010 10:24 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: IBM to purchase Sterling
- Replies: 1
- Views: 15425
IBM to purchase Sterling
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 ...
- Tue Apr 13, 2010 8:09 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Target not available, Error when map is build
- Replies: 2
- Views: 17921
<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...
- Mon Nov 02, 2009 9:49 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: DataStage TX 8.2.0.2 Migration from HP UNIX to AIX
- Replies: 1
- Views: 16250
....
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...
- Wed Sep 02, 2009 11:42 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Wildcard option for filenames in DS-TX
- Replies: 1
- Views: 17008
...
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...
- Fri Jul 31, 2009 11:28 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Implementing a Sequence generator in Datastage tx 8.1
- Replies: 1
- Views: 5795
Re: Implementing a Sequence generator in Datastage tx 8.1
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 ...
- Thu Jul 23, 2009 2:00 pm
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Error Handling with DataStage TX 8.1
- Replies: 1
- Views: 4859
.....
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...
- Thu Jul 16, 2009 11:43 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Installation Configuration
- Replies: 2
- Views: 16337
- Wed Jul 15, 2009 8:15 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: code issue... need help
- Replies: 3
- Views: 4060
...
So you removed the 'EITHER' and are only using the IF statments? Post the code.
- Tue Jul 14, 2009 2:25 pm
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Target not available - HELP
- Replies: 3
- Views: 4745
Re: Target not available - HELP
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...
- Tue Jul 14, 2009 12:35 pm
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: code issue... need help
- Replies: 3
- Views: 4060
...
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...
- Tue Jul 14, 2009 12:15 pm
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Target not available - HELP
- Replies: 3
- Views: 4745
- Mon Jul 13, 2009 7:46 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Datastage TX 7.5.0 Card Editing
- Replies: 3
- Views: 4951
....
A few files are created when you build a map; .mmc, .mopt, .bak, etc.
Delete everything except the mms and rebuild again.
Delete everything except the mms and rebuild again.
- Mon Jul 06, 2009 1:53 pm
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Problem during mapping
- Replies: 2
- Views: 3606
..........
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...