DSXchange

Just change the terminator property (Stage properties) from UNIX-style to DOS-style. This will put CRLF instead of LF at the end of each line.

Having just noticed that you are using parallel jobs, please ignore the previous advice. Instead, use 010 as the final delimiter character.

DataStage's claim of "any source, any target" should be one factor. It's a claim that's stood up fairly well over the years. That means that you can accept data from all these disparate sources, yet still use the target format that's best for you. Though it's both easier and faster to produce a CSV ...

Syntax for Convert() is identical in server, BASIC and parallel Transformer stages.

Yes, the orchadmin utility has a subcommand for this task.

At first glance one Merge stage with three Update links ought to do the job. Sparse lookup might be indicated if you are certain that the number of distinct key values in the stream input will be relatively small.

Welcome aboard. :D

This is an issue with the way access to SQL Server has been set up. As the error message says, there is no entry for BiogenixV4 in sysservers. Get your SQL Server DBA to assist with the sp_addlinkedserver stored procedure which can add the entry.

As noted in the other post, it may be the permissions on the uv executable. Once you answer the question there, we'll have a better idea.

You are running version 7.5.2.1. The first shared memory segment is the "system" or "disk" shared memory segment, which contains all the locks, the dynamic hashed file table (T30FILE table) and various other structures. The other shared memory segment (0xadee7521) is the NLS shared memory segment. T...

Who said it's being replaced?

Then whoever is your support provider is entitled to ask on your behalf. In an ideal world a support provider ought to know what patches are available, and which are needed at a particular site.

The DB2 Enterprise stage should be your preferred stage type.

However, if you need to access DB2 tables via DB2 Connect, for example because they're on a mainframe or AS/400 system, then you need to use the DB2/UDB API stage.

My guess is that the OP is executing a stored procedure or some other command from the Close command of an Oracle Enterprise stage, and that this sp/command tries to invoke a sequence. The message suggests that the sequence of that name is not accessible from the instance specified by the job parame...

The DBA might have changed the password, or it may have expired due to too many failed login attempts. It's not something you can correct from DataStage except by getting the user/password combination right.

The message suggests that your process has used up all its allocated memory and is trying to access some more. This might be at a micro level (for example trying to load 14 characters into a Char(10) column) or at a much larger, whole-of-process, level. Without monitoring it's really difficult to te...

Are these hashed files repopulated every run, or are you keeping persistent data in them? If the latter, give serious thought to converting them to static format; you will gain a noticeable performance improvement.