DSXchange

When the lookup fails, the reference input columns are all set to NULL by the Transformer stage, which invalidates the use of "=" and "<>" operators. You can test the link variable NOTFOUND for the reference input link, which is reliable if the link is fed by Hashed File stage but not, apparently, f...

Source is SQL Server. Target is SQL Server. Where does "spreadsheet" come into the picture?

You shouldn't need to do anything. However DataStage will generate a warning to alert you that you can not fit all known Decimal(12,1) values into a Decimal(9,1) field. If you know that you will be able to, because none of your Decimal(12,1) values has more than nine significant digits, then why not...

Ask your support provider to ask IBM whether there are any known problems with passing values from parameter sets (after all, they are new in version 8) and, if so, whether there is a patch to address the issue. If the answer is yes, please post the eCase number here so that others (with less than p...

In theory there should be no problem given sufficient hardware. Resource demand will, of course, depend on how many of the resources you want to consume - for stand-alone clients IBM recommends a minimum of 2GB memory; obviously this scales somewhat less than linearly on a Citrix server, due to shar...

Version Control is no more.

There will be a new promotion tool from IBM, with hooks into source code control, maybe in version 8.1 (late 2008 probably), maybe in version 8.2.

Meanwhile use export files and a source code control system to version your DataStage components.

... or that the file came from Windows, and has a two-character record terminator string. As noted, this question has been answered before.

You probably also need to set the date format picture, since the format you are using is not the same as the default format. While you are editing the column metadata to accomplish this you will also find the Nullable properties folder, in which you can specify the Null Field Value.

Thread Hijack Alert! Welcome aboard. Your problem is not the same as the one for this thread, which is about parameter arrays. Please begin a new thread with your question, which is about LONG data type. You might even save yourself that work by undertaking a Search to see whether it has already be...

It depends. I would always advocate promoting the table definitions from the Repository as well as the job designs that use them so that tools such as Usage Analysis and MetaStage can successfully be used in the UAT environment.

I guess you posted here because it's a server routine, even though you are in a parallel job. The correct syntax for setting environment variables requires no space either side of the "=" character. In any case you are not setting environment variables, you are setting DataStage BASIC variables. To ...

It shouldn't be necessary but would not do any harm.

DataStage ought not to have any handles to Oracle unless (a) a job is running or (b) a table definition import is occurring. These times, I would suggest, are not good times to re-start Oracle.

The ony thing I'd add to that is my preference to perform FTP transfers using a script rather than the FTP stage. That way I am always sure that the complete data set is available for DataStage to process (and I can achieve binary transfers where necessary, etc.).

Execute a halt command in the operating system. That will get their attention! Seriously, though, you can set up the email system so that an email to a particular address is converted to a pager message or an SMS text message. I'd suggest that such an approach is what you need. Note that this is don...

Given that that's what you have done (and let me state that I disagree with the approach on the same bases as the other posters), log in with Administrator privileges and execute the command UPDATE.ACCOUNT in each project. You can do this from the Administrator client Command window or from a TCL pr...