DSXchange

Ok... that would have been a nice fact to mention up front. Next question, why are you doing that? You are obviously doing a wee bit more than simply reading 2 million rows into a hashed file...

And how does one resolve the dubiousity? By trying it. Hopefully Chandra will and let us know how it goes!

Neither, which is why I asked the question. Unless Angela has done something 'special' to only bring over the job executables, it's not something that typically happens.

This used to be what you always got from the Designer when you weren't in Dev, back in the days of 'released' jobs.

Wasn't the only change you made to the sdk routine one from 'Open' to 'OpenPath'? Something else going on here that I'm missing? Your problem looks to be the fact that you specifically log a warning on the first line of the routine. Why would you want to do that? Change it to a DSLogInfo call - or b...

I assume you are using 'dsjob' from AutoSys. You need to pass the Project name on the command line to dsjob. Sure, you could setup an environment variable and use that or - since there's only one - just (gasp) hard-code the Project name in the AutoSys job.

parameter2: i have to pass job name Which job name? The controlling job? The current job? Some other job's name? If you want the current job's name, there is the DSJobName macro. For the controller job, DSJobController would be your macro of choice. i want find out can i call any DS function in ora...

Would depend on operator precedence and associativity... and I don't recall seeing that specifically documented somewhere. I would suspect you are correct. At the very least, adding the parens would remove any doubt as to how it would be evaluated.

How did you make the copy?

I was hoping to see something more specific than that. Ah well.

You could also substring off the first 10 characters and then use Convert to strip the delimiters from the result.

What have you tried so far?

Yeesh... are you not using Version Control?

Never seen that kind of message before? It means you need to include the header file with the function declaration for DSGetLinkInfo... JOBCONTROL.H off the top of my head. Search the forum for the proper syntax, something like: $INCLUDE DSINCLUDE JOBCONTROL.H This needs to be at the top of your rou...

I need to have the column names in the file. In that case, skip the whole 'check the file size' way and check link counts instead. An after job routine can be used to query the job using DSGetLinkInfo to determine the count of rows that went down any given link. Check for a zero count there and the...

You could do it 'after stage' from the transformer that feeds the Sequential stage, but I did specifically say 'after job'.

Yup, that's the way it works. When the stage is 'started' the file is opened and created as a zero byte file if needed. There's no 'only create it if I write to it' option.

You'll need to do something after job, a script or batch file or routine that checks for a zero size and deletes if it is.