DSXchange

Thanks!

Since I got the "nothing wrong with it" response I was looking for, I'll follow your lead and ignore the rest of this so I don't waste anymore of your time.

I have a Decimal(11,2) that I want to add to a Sequential file in a Varchar field. For instance, I want to see "Total: 9999.99" in the Sequential file. I'm finding that it's not always showing the 2 decimal places. So I went searching for a way to force it to always show 2. I've seen discu...

ArndW, I pulled dsx's from both systems and then used the Show Differences feature in VSS which allows me to see it more visually.

I've compared the dsx and other than date/timestamps, version numbers, PROMOTE/INIT lines, and Read Only vs not, I don't see any differences.

1) If I change: a_a
back to: a.a
It fails/won't compile.
2) We are mostly hardcoding Invocation Ids. Some use variables, but I don't think we are as advanced as you may be indicating. We are more using a Job Parameter as an Invocation Id or the Job Name.
3) I don't think this applies to me.

I compared the dsx. Other than date/timestamps, version numbers, PROMOTE/INIT lines, and Read Only vs Not, I don't see any differences.

1) The jobs were scheduled from Director.
2) These invocation ids worked before: 'a' a.a
3) During failure, they were same as #2. Once they failed, I changed them to: a a_a
4) I don't know what an invocation sequence value reset is, so I'm guessing the answer is no.

uvconfig seems to be the same on each server.

uvconfig seems to be the same on each server.

The similarity is that they all use Invocation Ids. After the issue surfaced, it seemed as though the Invocation Ids were invalid. But prior to the issue surfacing (for instance, last week in production or currently in dev/test), everything seemed fine. So it's like there was suddenly an Invocation ...

The jobs were scheduled in production. I only compile when: 1. I've made a change in development. 2. When I promote to test or prod, I check the compile checkbox. 3. When something goes wrong. For instance, I did a full compilation through Manager yesterday to see how many jobs were suddenly having ...

I've got a strange situation. I've got code that's been running in production without any issues for a long time. Then all of a sudden, various parts started erroring. I can't Compile them from Manager. If I open the jobs in Designer, some of the "nodes" get that little yellow warning symb...

Thanks, Ray! You are awesome!

I want to add the 6th argument and have the routine behave differently based on the value of it. If I create a six-argument routine that simply calls the five-argument routine, what happens with that 6th argument? It can't be passed to or handled by the five-argument routine. So I think I'm on the s...

We've got a routine with 5 arguments that's used in a lot of our jobs. We would like to add another argument to this routine, but don't want to have to go in and modify all the jobs that currently call it. We'd rather just let a default value kick in if a value isn't provided. But we are having a ha...