DSXchange

The COUNT() function will count the number of characters, the DCOUNT() function will give you the number of fields delimited by spaces. DCOUNT('XX','X') will return 3, COUNT('XX','X') will return 2.

An interesting first post which can be interpreted in several different ways. Perhaps you could post a reply to this thread and explain exactly what you did mean.

p.s. Welcome to DSXChange.

The "view data" in DataStage has always caused problems, particularly in NLS installations, because it does its own interpretation of data and can display differently. In your case, please put an output stage after your source stage that just writes this one column into a flat file, then u...

Just doing a full log clear from the director (Job -> Clear Log -> immediate purge of all entries) should do the trick as well, if it doesn't then you can do a CLEAR.FILE (but remember that the purge settings will be gone).

Yep, and with all this deja-vu all over again we still don't have a copybook.

This error means that the log file for this job has become corrupted. The most common cause is that the disk (at one time) filled up.
For LOG files the solution is easy, just clear the log file.

I was just reinforcing your request, Craig

Make a copy of your job which has only the SAP stage and goes to a peek stage or copy stage with no output link. What is the speed? If the speed is similar to the job as a whole you will have to look outside of DataStage for performance improvements.

do a hex or octal dump of the file data (use "od" or a similar tool). I am certain that one of those spaces is not like the others (the not-so-subtle reference is intended).

Are you aware that the DRS stage documentation, on pages 29 and 30, do not contain LONGVARCHAR as a valid Sybase data type? You will have to redefine this as a CLOB.

Convert() and ereplace are very different functions and are not interchangeable.

Could you please post the COBOL PICture clause for this file, it would make it a lot easier to understand the problem.

I think that "cat -v" will show the problem, as HariK has suggested.

Try disabling RCP in the link leading to the Transform stage and in the Transform stage itself. Are there red derivations in the stage? Does it compile?

No reason not to use a row generator in a production job. Most of the projects that I've been on use the stage somewhere in production.