DSXchange

Is the DB2 instance on a mainframe or AS/400 machine? If so, you will need to use the DB2/UDB API stage. There is a glitch in the Enterprise stage that prevents connectivity to other platforms.

On some variations of UNIX the ndd command can report (and be used by root to change) the TCP wait timeout.

Disabling RCP means that columns that formerly were automatically transferred are now not being transferred. You have to explicitly design in those transfers (mappings) if you require them to occur without RCP.

Please post the full detailed text of the log message, including the stage name and partition number.

There isn't a directory (folder) called DSHOME; that's a short cut (and may, if you set it up, be an environment variable). Location of the directory in question is "whereever you installed the server directory", by default C:\Ascential\DataStage\Engine. However, on Windows there is no .odbc.ini fil...

Why not just do it in the SQL?

Iconv() and Oconv() do not work with timestamps; you have to break the timestamp down into date and time components to work with these functions.

Try using a Complex Flat File stage to read the file. It will decode the COMP and COMP-3 fields for you, faster than the Transformer stage can do it.

So you have a delimited string of the form x1,y1|x2,y2|x3,y3|... and you want to determine whether x2 exists in it? You can do this with a single FIND statement. FIND Arg1 IN Convert("|,",@FM:@VM,Arg2) SETTING FMC,VMC,SMC Then Ans = FMC End Else Ans = "Not found" End

Draw us a picture of your job design or post an image. If you draw the picture using "ASCII art" enclose it in Code tags and use Preview till you get it right. This will help us to help you.

It would be very unusual for both jobs to take exactly the same amount of time. There are so many factors that can cause variation. Is it the same hashed file? Loading an empty hashed file is quicker than loading additional records into a populated hashed file. Are you using write cache? Perhaps in ...

Having said that, did you choose "TX Map" thinking it was the Transformer stage?

Using the TX stage is only half the story. You also must have created the TX map(s) that it is going to invoke.

Given that you're on UNIX, try using the server machine name as the server name. Every UNIX machine can be its own SMTP client. The machine name is returned by the hostname command.

Such as?

Have you tried anything suggested thus far? If so, with what results? Why are you seeking more? In exchange for money I'm sure you could get someone to design the whole thing for you, but that's not what DSXchange is about. Guidance and assistance, yes; doing your job, no.

SEEK is not available unless the file was opened with OPENSEQ.

You have chosen to write the file into the directory as if it were a record in a database table, which is a perfectly valid approach. But it means you can not take Craig's suggestion to use SEEK.