DSXchange

Vertical vs horizontal in this case is because you have formatted your output to be wider than your screen. This will not fit even if you spooled your ouput to a printer which can handle 132 character wide columns.

You need to revise your FMT lengths in order to achieve what you want.

Regards,

As pointed out in other posts, it might be better to filter on DSD.RUN vs Phantom since there can be many Phantoms for each job or job sequence. By doing this you can then see how many distinct processes are running. Another question might be - are these processes running many of the same jobs as mu...

If metadata exists for the table/hash in the repository then you can simply use the manager to do a usage analysis. Right click on the object (table def) and choose usage analysis.

Based on the error that you have given it would appear that there are some rows that either have too many delimitters or not enough. Usually this happens when the delimitter you have chosen is found within the data itself.

Is the SID unique? If not and you require all three (3) columns for your key then you have an issue and one that would be present regardless of tool used to join the tables. If SID is unique then you could build the Hash with the SID as the key and Name and Dept as fields or columns. You need to hav...

I was not clear in my post, but you do need to redesign your job as Ray and others posted. Your source now needs to be the lookup and the lookup should now be the source. If your job is not too terribly complicated then I would think that this should be quite easy to accomplish.

Identify the columns or metadata on the target link with all of the columns you want. Perform a lookup against the hash file and interrogate if the lookup was successful by checking LKUP_LINK.NOTFOUND. If the lookup was successful then the target link would be populated with the values from the look...

Can you be more specific regarding your request? Do you intend to accomplish this with a hash lookup or user written SQL in a stage?

Since the paradigm for DataStage is to process one row at a time your situation presents a moderate challenge. You can probably accomplish this several ways, but if you want to use a job and your source is sequential then you might consider using the following - Seq_Master ------->Aggregator--------...

I'm not sure why you are not experiencing problems with this in other projects, but you are most likely calling the user written routine IsBlank from a user written routine without defining the function first. You need to first define the function using syntax like - DEFFUN IsBlank(Arg1) CALLING &qu...

You need to follow Ken's advice to determine CPU usage. There may be other processes/services running on this server that are consuming resources. When you state that one day it runs 7000 rows/sec and the next day 200 rows/sec this tells me that DS is not likely the culprit, but rather something els...

It sounds, from your description, that the network is not the issue since you are processing files that are deposited on the box and then DS processes these files as load files on the same server and then some other process moves them to the DB server. Is this correct? Give us some info about the ty...

I believe Ray posted the correct solution given the posters information. If this were Unix then I believe Ray and others would have certainly given wc -l as an option along with the option of using BASIC to read the file. A routine like what was posted running in the background with no terminal i/o ...

I am currently using version 7.5 on Windows and it works fine with parameters. There were issues with other stage types (sequencer specific) not accepting parameters in earlier versions, but I have not encountered any of these issues with 7.5.

I posted this to the ADN also, but I believe this is a browser issue. Works with IE, but not Mozilla (Firefox too).