DSXchange

Run the OS level command using DSExecute() in a routine. Reference that routine inside the transformer.

How are you parametrizing it. Make sure you surround it with hashes. Plus you need to give the instance name for Data Source.

Parametrize it. Pass it as a parameter to your stored procedure.

You can also use awk to append lines. Its better to do number of lines then number of bytes.

Care to share your 'work around' ???

ArndW wrote:Plugins tend to be faster with DataStage.

...due to the fact that it uses native drivers than generic ones.

How many open cursors are allowed by your id? There might be a limit to the number of open connections allowed by your id. Your DBA will be able to tell you how many connections are allowed by your id.

Uncheck the clear option, do create file and open the options box and check "Delete file before create". See if you see this error again.

Or you can do it in the OPEN command of a database stage. And how exactly are you going to do it in a routine? Are you planning do use a Basic Transformer?

I wonder if this functionality is added in 8.0

O they started emailing you, bad bad. I guess thats my fault as I gave away this secret of yours. But its good that you have it in one place here, that is accessible by all.
Thanks Craig.

Two different animals. I like to put it that way

I think the OP was referring to 100 points rather than currency. Or are you being sarcastic

Thanks for confirming that Ray. I thought I was being hasty in concluding that its not possible as a one liner in a px transformer.

#!/usr/bin/ksh export FILE='file/to/check' export DIR='dir/to/check/' ls $DIR | wc -l | read val if [ -f $FILE && $val -eq 0 ] then exit 1 else exit 0 fi If you get 1, stop the job. You can also directly stop your job by replacing 'exit 1' with 'dsjob -stop' command to stop your job.