DSXchange

I hate Windoze. It's a necessary evil, like cable television companies and car dealerships.

This file is irrelevant on Windoze. You configure ODBC connections under the Control Panel-->Administrative-->ODBC icon.

Any chance you cut-and-pasted into something during design? The internal delimiter used to store job design information reserves specific characters in the ASCII chart. You somehow used one somewhere in the design information. You probably need to review your job design changes from the last time yo...

Arnd, within the same job I'll use the link collector if the metadata is consistent, but I understand the reformatting trick. However, it's not apparent from a design metadata perspective what is happening. It's just a difference of style. If we were all the same, life would be boring.

I understand your design now. You are using the pipe functionality in the Sequential stage to act as an IPC stage/column redefiner. If you used a Transformer and did the redefinition there you would not need to do all of the work you are doing. The inter-processing gives you an inherent fifo effect ...

I don't know how you can accomplish this without removing the validity of the data. If your QA folks are validating totals and such, this won't work. You also have to be aware of how much effort you're going to suffer to write jobs to do this. The easiest solution would be to load the database, then...

It seems to me your job designs do nothing special. You should consider merging them all together and turning on inter-process, because if all three jobs are executing simultaneously than that's the same effect. If you're not executing them simultaneously, then all you're doing is avoiding writing a...

Somehow you avoided the word encrypt. Why not encrypt sensitive data? If the point is to avoid exposing sensitive information in clearcase, then a simple encryption/decryption set of functions is needed.

Is my coffee too strong or am I missing something?

You're going to need to unlock the USERNO for the lock in question. Use the UNLOCK USER nnnnn ALL syntax. Telnet the DS Server, login as the Administrator, at the account (project) prompt enter UV for the system account. At the > prompt type in LIST.READU to get a list of the locks, find the USERNO ...

Or you could get the DS Server Batch job on my website that lets you run a DS job that compiles jobs according to some parameter values (folder, jobname match, uncompiled state). Just run that as part of your scripted process. It's multi-instance enabled, so multiples can run simultaneously to compi...

If it doesn't work again, get a DBA. This error should be greatly infrequent.

If you mean rename, use a Routine call to the OS and the "ren" command.

Sourcedata is moved to targets -->mapped. In order to squeeze data in, you sometimes change it --> transformation.

Should be sufficient to scan thru all lines up until 2+ where the issue is reported, then display the last 4 lines. Go get a cup of tea and a biscuit while it runs.

Look under your Start menu button.