DSXchange

Brad, once you reply to it it can no longer be removed. At least not by the OP.

Perhaps you might want to consider correcting whatever problem generated so many log entries before you just restart the job. Just a thought.

Search the forums for "Computed blink", you'll find you've corrupted the log hashed file - most likely by running with Unlimited warnings and blowing past the 2G barrier.

No. Perhaps you need to verify what encoding was actually used for your source file if 'UTF8' didn't help.

What version of DataStage do you have? What I posted worked fine in the 7.5.x version.

You don't need NLS. Proper setting of the NLS_LANG environment variable in the job's session should solve your problem. Search for NLS_LANG, LC_CTYPE and Oracle to find several other posts discussing both the problem and the solutions people have found. You'll find mention of creating a user defined...

You can't - that's what the Multi-Client Manager is for, assuming you still have the 7.1 Client installed in a separate directory from the 7.5 version.

You don't need all those parens and shouldn't be checking for 0 or 1, simply let the booleans sort themselves out naturally: If Not(IsNull(DSLink2.DUNS_LEVEL_1)) And Not(IsNull (DSLink2.DUNS_LEVEL_2)) And IsNull(DSLink2.DUNS_LEVEL_3) Then DSLink2.LEGACY_CD Els...

What does who mean by that? There is a product available that was formerly named 'RTI' for 'Real Time Integration' but which is now marketed as the 'SOA Edition'. Read the posts in the SOA Forum to see what kind of things people are discussing there or check IBM's website. At a very high level, it l...

In addition, I have performed maintenance on the project by recreating the repository indexes. Now all the jobs are gone! Then you failed to perform this 'maintenance' in an isolated fashion. If anyone or anything is connected to the Project in question, that is the guaranteed end result, which pre...

Something in your Sequence triggered your Terminator stage, what might that be?

Well known problem caused by Service Pack 2 with a well known solution - a patch. Search the forums for "dsclient_xpsp2" for many discussions on the subject.

Ok, I could see that approach. What kind of file size limitations have you encountered with the approach, Arnd? The Sequence job may still be more appropriate depending on the nature of the loads being performed. If a per-file audit needs to be maintained, for example, or each load needs to be handl...

Only for XML files. The kind of processing the OP wants to do on flat files is what the Start Loop, End Loop and User Variables stages were created for.

When i reset the job I got the below error EligPxiLoadFileExtractJob.12752.INP_PERS_FILE_CNT.INP_CNT_Lnk: DSD.UVOpen Unable to open file '/dso/dsoweb/clients/upac/eligibility/logs/INP_PERS_FILE_CNT_12752'. Errors written to the log by the Reset process can be ignored. What matters are the ones logg...