DSXchange

This isn't true, unless you've got a sort somewhere in your job. The join will operate in a 'pipeline' fashion, regardless of whether its source data are provided by a database of dataset stage. Joining data streams that are not pre-sorted on the join key will cause a tsort operator to be inserted ...

The magic number 96 comes from the fact that you are trying to read 32 Cyrillic characters from a database with NLS character set UTF-8. This is a multi-byte character set wherein the Cyrillic characters are encoded using 3 bytes per character.

96 should have worked.

Hi all, Has anyone come across what seems to be a bug in dscc. It only happens when compiling routines. The first time I compile all is good but the second time shows a lock error which I then have to clear using the cleanup_abandoned_locks script. <pre> $ dscc /d mydomain /h myserver /u jim /p jim ...

Hi all, I'm trying to create a parallel routine that uses the C/C++ DS API. I have successfully created applications using the C/C++ DS API and I have also successfully created PX routines but I can't seem to combine the two - i.e. a PX routine that uses DS API. As soon as I include any sort of DS A...

We are currently running 8.0.1 on Windows 2003 Server and having quite a few stability issues as well. We were toying with the idea of moving to RHEL 64. Have you got all the components running on the same box (i.e. Engine, Repository and WAS)? If so, have you been able to identify which component i...

This is the type of error you get when MSVC is not installed.

What version of MSVC did you install?

Ray, I've created another job with a much simpler schema and using a row generator. Here's the score. main_program: This step has 3 datasets: ds0: {op0[1p] (sequential Row_Generator_5) eAny<>eCollectAny op1[4p] (parallel Copy_1)} ds1: {op2[4p] (parallel delete data files in delete G:/Projects/DEV/Wo...

Tried it again just now after creating a completely new job on a different server (same os and ds version) but with 4 nodes and checking that the FORCE option on the copy stage is False. main_program: This step has 3 datasets: ds0: {op0[1p] (sequential ODBC_Enterprise_0) eAny<>eCollectAny op1[4p] (p...

OK Ray. I stand corrected. It's compiled out if it's not needed AND Force Property is set to false. (I'm not referring to force compile. It's the Force property in the Copy stage) In this case, it's a straight copy. No changes to names, no columns dropped, no change to the order of columns. The manu...

I've read in a number of places that the copy stage is compiled out if the Force option is set to false but I've just done a simple experiment. CopyTable1 - From source to target with copy stage ------------------------------------------------------------------ ORACLE--------->COPY------------->DATA...

Hi all, I'm getting a lot of locking problems mainly when I export out of the DEV project and import into another project. The problems start after an import is complete and I try to do a multi-job compile. When I do this most jobs work fine but some fail with the error "Cannot get exclusive ac...

The server must have been a bit confused. I remember we had a few problems that day.

Since then, the server has been bounced and I've used the Multiple Compile a number of times with no problems.

Thanks Ray.

In this case there were no other DataStage clients open. Also you would expect that the Designer would also fail if a job was locked by another client.

I'm trying to compile multiple jobs and for some reason I get the following error on some jobs. "Cannot get exclusive access to job to compile it" Now I know that no-one else is using the job because only I have access to this project and also when I open the same job in Designer, I can co...

lstsaur,

Thanks for your reply before.

In answer to your question, no I haven't applied any patches. I will be looking at doing that though. It would be very handy to be able to see the generated stylesheet.


Thanks again.


By the way, is there a specific patch that I need to be asking for?