DSXchange

This is almost like pulling teeth. What program did you use to get the output? What character set is the source using (actually, what is the source?)?

Teh fix process will tell you if a group is corrupted and deleted - when you see that message you know that record loss has occurred. If that does not happen then things look a lot better. Force-recompiling all jobs after a truncation should also show you which job(s) might be corrupted. Since you h...

Where are you getting the output? From "View Data" for from SQL in your database (outside of DataStage)

They have removed the ability to see the source code for these internal routines at Version 8.x

Have you tried using the builtin "Warning" and "Error" codes? Do you have "automatically handle activities that fail" switch activated?

What are they being turned into in the database?

Perhaps. Make a backup of the project at Unix level when all users are logged off. Then use either the preferred method of running "fixtool" from UNIX or doing a "UVFIXFILE" from TCL. This has a good chance of repairing the file, or at least most of it. Do you have a backup that you can re-load into...

You can write a BuildOp to do this splitting of rows if the solution given above is not sufficient.

The READ that is done on the hashed file containing the log entry will not cause locking problems in DataStage. If an explicit lock is taken on the log entry record at all, it will be released after the call; and since no log entries are ever updated by the system even if there were an exclusive loc...

Which one - the folder or the registry? I would guess that the folder did it, but it would be nice to know.

I am not at a session where I can check the names, but after deleting the old files you should also delete all of the registry entries.

Could you explain the actual variable name and value at runtime, since the spelling of

#Environmnet variable#

doesn't look quite right?

The UNIX command would be "dsjob -run -mode RESET {proj} {job}"

Hello and welcome to DSXChange, Susha. Without additional information there is no possibility of getting help. What stages are you using?Do you have NLS enabled? What database and what are the NLS settings for that DB? Which French character is it, and what ASCII value is it being turned into (and h...

What kind of a stage is "APS_DB_REMAINING_JOIN_INDICATORADD_tras"? The processes communicate between each other with pipes, so the error message indicates that the process that is supposed to writing to the pipe has either failed or timed out. Any other error messages or warnings in the log?