DSXchange

Way too complex! Iconv(inLink.TheValue, "MD2-") will handle the trailing sign.

Abnormal terminations can even be caused by simple things, like the connection name not being in tnsnames.ora. That's why we need to know more about the job design.

Ereplace() is the least efficient of the three suggestions offered.

There is an error in the Parallel Job Developer's Guide. The NullToValue() function is only applicable in the Transformer stage. For the Modify stage you require the handle_null() function.

You might find the resolution to this post interesting.

Welcome aboard.

Are you selecting from the same DB2 table (either in the stream or the lookups) that you are trying to upsert into? You may be experiencing locking problems in the database. Have your friendly DBA monitor locks while the job is running.

You have to trim @FM rather than white space.

Your job does not actually have a parameter whose name is NLS_MAP. Maybe it's cased differently or spelled differently. But the fact that the reference was unresolved in the error message suggests extremely strongly that, whatever job parameters you do have, none of them is called "NLS_MAP".

It's not line 190, it's address 0x190 in the object code. You need VLIST to determine which source statement this is. However, if you tell us what stage types are on the other ends of the links connected to the Transformer stage we can probably take an educated guess where the error is coming from. ...

I wonder whether that counts as Resolved... ?

Is the server in this case a DB2 server or a DataStage server? If it's a DB2 server, check that the DB2 client software is properly configured for that server and that any necessary environment variables have their correct settings. If it's the DataStage server, check whether the repository needs re...

Curious. Were you really root? The root user ought not to be affected by file system permissions. I wonder if the install script starts other processes under different IDs to do things. We ought to begin pressuring IBM for better documentation of these kinds of issues - you're placing your total tru...

You can use drag and drop in the Designer client. I am not aware of any version 8 programmatic method for changing the repository folder in which a component resides. I suppose that you could enable server side tracing then open Designer and perform the drag and drop, investigate the subroutine call...

Welcome aboard. The count is the easy part. As a general rule a running job does not have access to its own metadata within the design. The easiest solution is probably to post-process the file. Are your column definitions in a schema file or in the Repository? In any case, you can create a server j...