DSXchange

I am putting as much detail as I can in case someone can use this eventually... Sorry for my English, it is not my first language. Feel free to contact me if you need more details. Anyways... I had to parse the string to get rid of the code=-4 [ParamValue/Limitvalue is not appropriate] error. There ...

Execute Command ---> User Variables ---> Start Loop <------- End Loop | ^ ...[/quote] I assume you mean Execute Command for the SQL query and get the list then filled in a user variable to use with the loop. That's what I've done now. I still have that annoying Controller problem: Error calling DSS...

Hmm, I am surprised that you've managed to delete your admin user with only one admin user in the system (ie. The only that you were using to delete itself). That is surely something that you shouldn't be allowed to do (to delete current user). I personally always use isadmin and dsadm as suite admi...

Hi Ray! Indeed, that's exactly what I use to do with SSIS but I am having difficulties to pass that list to the StartLoop stage in DataStage. I normally pass values using $userStatus but I can't find the way to pass a list correctly and in a clean way.

I am sure there is a neat way to do this.

Hi everyone. Hope you are doing well. I am on a migration project at the moment. I have to ETL legacy apps information for the new applications tables but I also have to move some legacy apps tables with no modification for backward compatibility. There is not that much tables but I was wondering if...

Hi. Which OS exactly ? I had similar issues twice. The first time... a JRE was already installed and set in the path. The installer was using this once and it went wrong. Fixed by correcting the path. Second time, JRE was corrupted in the download (or something similar I assume). I downloaded the IB...

Hi Everyone. Thanks to my friends from IBM, I've managed to solve the problem. Since I still didn't find that in the documentation, I'd figure it would be nice to share my experience. So, first thing to know... DataStage doesn't propagate the compile code through the MMP. So when you compile a job, ...

Hi Ray, Thanks for the tip, I did found some information on p.604 of the Parallel Job Developer's Guide (Chapter about remote deploying). I've been re-reading it and some things are still unclear to me. I was hoping you could help me understand the process. 1 ) When you create a new project, do you ...

Hi Everyone, I have a problem with the install I have on a 2 nodes windows server 2003. Install looks fine (rsh -l dstage IS8node2 ls works on both node) and ssh RSA key is good. I build a basic job with a row gen, transformer and peek ... it works fine on 1 node but with 2 nodes I have the followin...