DSXchange

If you had searched the Forum, you would have determined that pre-loading a set of the current keys from the target table into a hashed file allows rapid and easy detection of existence, and can deliver the corresponding surrogate key values too. On the basis of that selection, you can determine whe...

Search the Forum for //JOB.STARTED.NO which you will find to be a particuarly useful nugget of knowledge in your current quest.

Certainly it's a steep part of the learning curve you're on. What you are seeking from this list is free tuition, that would take at least fifteen days of formal class time. I doubt that any of the contributors here can afford that amount of time as a gift. Either enrol in one of the standard class ...

Clever, innit? What's happening is that the timestamp is being converted into "seconds since a certain zero", an hour (3600 seconds) added, and that converted back into a timestamp. The Iconv/Oconv functions are completely cognizant about the calendar, including the 11 days that the Pope removed in ...

And you must post the entire message. There is no such message as "TR detected". It probably says something like "abnormal termination of stage TR detected".
Without the entire message your question is like "My car is. Can you fix it?" Not helpful, is it?

Another possibility is that someone killed your agent process (dsapi_slave or dsapi_server) on the host machine, possibly thinking it was a defunct process because it was doing nothing. Alter them to the fact that this is not a good plan.

Is your network stable and reliable? The message suggests that there are interrupted calls to socket routines, or interrupted system calls while sockets are being used. This amounts to much the same thing. Get your network administrator to trace the source of the interrupts. For example you may have...

You're correct in asserting that the STATUS statement gives you lots of information about a currently open file. To process all the files in the directory, you need to open each file separately to apply this statement. (This is not really a problem; under the covers any utility you use would have to...

Welcome aboard! :D There is no built-in operator for this task; you probably have to construct your own. Do you need whole hours or fractional? If whole hours, is this a rounded or truncated number? (A truncated number would be "completed hours".) Basically you have to pick apart each timestamp, con...

If you have QualityStage installed there is a manual called Stages.pdf that contains detailed information about each of the stages that are available. If you've been used to INTEGRITY (the former name for QualityStage), the names have changed; operators have become stages. The following table is fro...

This is a generic error code; the text accompanying it seems to say it all. It's probably the case that your PC can not resolve the DataStage server machine's IP address from the host name, but the other developer's PC can. Try using the IP address rather than the host name. If that doesn't work, tr...

Welcome aboard! :D The Folder stage is notorious (at least in version 7.1 and earlier) for not being able to handle large files in the folder. Create a server job to process one sequential file into the target table. Make the name of the file a job parameter. Create another server job. Open its prop...

Each instance runs as a separate process. COMMON is intra-process, it is not an inter-process mechanism. Therefore, even though one process opens the file into a variable named in a COMMON area of memory, that area of memory is private to its own process. Another job will create its own, private, co...

There are three different kinds of DataStage job. Server jobs run on a single server. The underlying language (in which you develop routines, expressions, etc.) is DataStage BASIC. Parallel jobs run on one or more "processing nodes" in an SMP or MPP environment. The underlying language is C/C++. Mai...

Welcome aboard! :D There's not really much information here. Were there any other warnings in the log for this job? What I can see is that you have a job with two Transformer stages, and the one called FDM84_88_BUS_UNIT_TBL_PM.exp_EMPTY_STRING_FDM had a problem. But without other error messages, thi...