DSXchange

Any thought how we can achieve this where sequential file will read a fixed width file where in column the lengths are not fixed. No such thing. If the lengths are not fixed then it needs to be a delimited file. Fixed is fixed, not mostly fixed. :wink: Question though, is this only an issue with th...

Crazy talk!

And then it should be a Server job.

If you don't need it, just chop it off before the function call.

GMT offset?

There isn't.

Oh, and... good luck with that. I know it's not exactly 'on topic' but I found it amusing.

Ok, I'll bite.

Why, what are you up to?

Actually, they linked directly to where you had it hosted. I pushed the URL back to your website.

What Mike noted is still the best advice. In my world we always included that APT as one of four(?) $PROJDEF variables that were in all of our jobs so they could be easily overridden if needed. Sorry but that was much too long ago to remember what the other three were - off the top of my head, the o...

Do you have $APT_CONFIG_FILE defined as a parameter in the job? If so, make sure it is set to your 1 node config file. If not, add it.

See edited reply. I meant your shell script could 'bundle' as in make multiple calls to dssh, one for each command / function you needed to run. Did not mean to imply there is any kind of 'script' capability within dssh itself, although there very well could be. Never had a need to investigate any s...

Not sure about the 'batch mode' you mentioned but you can certainly execute dssh queries from the command line and bundle those into scripts.

But then it seems you already know that.

What 'same issue' - the exact same error calling the exact same parallel routine? If not, you need to start your own post with the gory details of your own particular problem.

You can't just use 'right' in the job as you want weeks not days. Look into the YearFromDate and YearweekFromDate functions.

hargun wrote:I want the last two numbers of first field like 2012-05 instead of 2012-5.

Doesn't DB2 have a "to char" function?