Search found 91 matches
- Fri Jan 06, 2012 7:39 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: How to use dsmapconv cmd to upgrade 6.7 to 8.3 xml maps.
- Replies: 2
- Views: 17502
- Mon Dec 12, 2011 1:21 pm
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: DataStage TX - Error Code 21
- Replies: 5
- Views: 27286
Start at the end of the file can count back 5157 bytes. the 1st byte before that point was the last one it could validate thru the end of a segment. After that it got lost. If the file is 5157 bytes in total it could not identify the begining or end of segment/record/row. It appears that it thinks y...
- Wed Nov 16, 2011 3:31 pm
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: job is unable to come to finished state
- Replies: 5
- Views: 20559
- Wed Nov 16, 2011 3:25 pm
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: XML Parsing using WTX Componens
- Replies: 2
- Views: 22314
Agree, you need to compare the data to the type tree. The interesting thing is it that the first one tells you the issue is a offset 0 while the second one tells you the offsets with issues are at 0 and 9. Looking at your trace file a little closer you'll notice the map seems to do fine until it was...
- Fri Feb 25, 2011 7:12 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: WTX Data load to UTF-8 database
- Replies: 0
- Views: 15701
- Mon Jul 26, 2010 10:33 pm
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: What are Functional maps?
- Replies: 5
- Views: 20190
When is your interview? *** Please don't post interview Questations **** Refer Datastage TX User Guide ... Sorry, don't quite understand that comment. You must know or see something I missed. . . . In addition functional maps can be used perform common routines. Don't bother writing a rule 4 times....
- Thu Sep 10, 2009 8:36 pm
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Help Reqd: Unable to load data into the target table
- Replies: 3
- Views: 18218
- Wed Jul 15, 2009 8:49 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Conversion of Hex Value to equivalent Decimal & ASCII Va
- Replies: 5
- Views: 7498
- Wed Jul 15, 2009 8:46 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Datastage TX 7.5.0 Card Editing
- Replies: 3
- Views: 4951
I've seen this happen before. Not sure if it's the map tool or the machine. Try closing the map, clean up all of the extranious files. reopen the map, point to the input file and press enter, save and reopen the input card to make sure it's still pointing to the new file then compile. After you comp...
- Wed Jul 15, 2009 8:38 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Target not available - HELP
- Replies: 3
- Views: 4745
Make sure you point to your MDQ file and table when defining your output card. Also, on the command line you can add a trace command '-t' that will provide a little info on why you may be having a connection problem. When building your type tree for the specified table in DBID make sure you define a...
- Wed Jun 17, 2009 9:47 am
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Need support information on datastage TX/mercator 6.7
- Replies: 7
- Views: 9052
Just an FYI.... I probably wouldn't answer to many questions for a person posting such a defensive response to a simple not so rude but perhaps assumptive question...... But I'll let that go..... The maps are typically used to transform non-standard data to a standardized data format, ie... external...
- Wed May 27, 2009 8:25 pm
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Improving the Maps Execution Time
- Replies: 6
- Views: 6411
How fast does the map run if you just write the data to a file verses loading to DB? Are you mapping and loading at the same time or mapping to one output card and loading from another? Are you doing queries while mapping to the output? If, for example, you are assigning sequence numbers for keys as...
- Sun May 10, 2009 9:30 pm
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Improving the Maps Execution Time
- Replies: 6
- Views: 6411
This is a very simple example. I'm sure you could do this several ways. You'll need SQL Loader installed on the machine you will run the map on. the item below is in a batch file.... sqlldr id/pw@sid control=load_data_cntl_file.CTL LOG=path\file.LOG bad=path\file.BAD The item below is the 'ctl' file...
- Fri May 01, 2009 12:54 pm
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Improving the Maps Execution Time
- Replies: 6
- Views: 6411
Have you played with burst mode and page size/count settings? Have you tried writing your output to files to determine how much time is used on the output side? Outside of that, without seeing your code, it would be difficult to give you solid answers. I can tell you that I have a process that was p...
- Fri May 01, 2009 12:47 pm
- Forum: IBM<sup>®</sup> DataStage TX
- Topic: Generate a type tree from empty stored procedure ?
- Replies: 2
- Views: 3718