DSXchange

Sounds cool.

Yes it will run under the user you start the job as. When you run a Command stage then it starts in the directory of the project. If you run a pwd command it should tell you what directory it is attached to. Look in the log. The output of your command should be in there. Make you command echo results.

You can always shell out and run pwd. The best way is @WHO will give the Project namd. The path to the project is located in UV.ACCOUNT.

LIST DICT UV.ACCOUNT

This feature started working in Ds7.1. You need to upgrade.

Another good reason is control. If you do it yourself then you can control when and where.

Someone burned Ray?

Depends on how much money you have. If you have enough money to mirror your entire database more than once then it changes everything. You can then break one set of mirrors and unmount them from one machine like production and then mount them to test. This is very fast and very cool. You can do simi...

Is this homework or a job interview question?

Why are you reading the whole file?

I think I understand. You are looking for gaps in your surrogate keys and want to fill them in. Ken Bland posted a nice solution to this before. I would search for that solution. I don't think you want to do this in multiple instances. You are probably correct in trying to lock the file to look for ...

Sunshine Arnd is probably correct but it looks like this file is read only at the OS level. You need to fix that. I would also change the REVISE into ED. REVISE DICT HASH_EMPLOYEES USING ENTER.DICT ED DICT HASH_EMPLOYEES NumTimes10 If Num is field 2 then change Arnd's code into 1 - "I" 2 -...

That should shutdown any system. Nice.

Post the code and the syntax error. Not enough information here. It should work based on what you have stated.

Every time your call this routine it adds one to the value and writes it back. This means that 2 threads can call this routine and both will get different values to write to 2 different keys. So they should not overwrite each other. Let us say instance A calls routine and gets 1 back. Next thread 2 ...

The routine is called for every record. It will add one to the value and rturn that so you can assign it to your surrogate key.