DSXchange

I have a problem with a match spec I'm writing. When I try to test a pass, I get the following error: ##E IIS-DSEE-TOSH-00003 14:43:03(007) <main_program> Syntax error: Error in "QSund_std" operator: Error in output redirection: Error in output parameters: Error in modify adapter: Error in...

Hi all, I've got a bit of a nasty one here and was wondering if someone had some ideas on how to clear it. I started to run column analysis a table. Not a big table, would have taken 15 minutes normally. After waiting much longer than normal, I figure something is wrong. I shut down and restart the ...

Agreed, Andy: awesome responses. Thanks for all of your help, everyone.
:D

Yes, you configure that kind of information, how many CPUs, job's priority, etc. in PBS Pro and it will pass on that information to the Grid enablement software. It's much more to it. So it's not something you can do in the DataStage config file, to limit how much of the grid a project's jobs can u...

I'm not worried about charging the right cost centre, but being able to limit the amount of processing power they can possibly divert from the other more critical processes.
Is it as simple as defining a config file with a reduced list of nodes? Or is there more to it?

Hi everyone, We have a grid setup that is highly utilised already. Now there is another group of developers that need access, but we want to limit the amount of resources they get to use, to reduce the potential performance impact on the other jobs that are running (some of them quite critical). Is ...

Thanks a lot guys that was driving me insane!

It works now that I put apostrophes around the mask. Then I just remove the apostrophes before I attempt to match values.

Now it works fine.

Thanks for the help guys!

BTW the read method inside the loop is:

Hi all, I have a really weird issue for you guys that unfortunately comes with a long explanation... here goes. I have a korn shell scrip which is responsible for deleting old data on a daily basis. We have scheduled it to run through DataStage using a Sequence job. The script uses a configuration f...

Thanks guys I understand the problem now. Did you not do the search I suggested? The cause and solution have been repeated here many times, and as noted your 'dud data' is a Field Mark. Chulett, Honestly your original comment didn't exactly make a lot of sense to me... now it makes perfect sense... ...

Thanks for that info Julio.
Much appreciated.

Hi all, I'm looking for an in-depth explanation about these fields. qsMatchPattern. qsMatchLRFlag. qsMatchExactFlag. I've read the help and apart from saying qsMatchLRFlag can be 'L' or 'R' and qsMatchExactFlag can be 'X' it really isn't any help at all. Google and the QS Redbook are no help either ...

Hi emeri, I've tried that option already.

Hi, I have encountered an error that I do not know how to resolve it. I built a shared container to split a phone number. I have also built 2 different jobs that use the shared container. The first job split a single column called PhoneNo and it works fine (1 shared container implemented). However, ...

Use a Transformer stage. Seriously. That's why all the fiddly QS stage types no longer exist - you have the DataStage engine to do all that for you. Sorry Ray. Can you be more specific? While the example is quite simple we have others that require more complex processes. Can that be done in a singl...