DSXchange

If the type trees haven't changed I'm surprised you have unresolved rules.

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...

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?

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...

Did you use DBID to generate your type trees? It should define the trees with character sets in mind.

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....

The standard map log will be insufficient when dealing with DB errors. You'll want to follow Rep's advice and turn on the db trace '-t'. run the map and look for a dile extention of 'dbl' unless you override the trace file name.

If your type tree is defined correctly you should be able to simply point the new field at the old field and run your map. Your output will be in the format you require.

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...

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...

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...

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...

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...

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...

Not being overly familiar with 8.2n and beyond I can't answer if IBM has changed this. Depending on your version, you are going to need to use a runmap which will call the stored procedure that will perform the updates.