DSXchange

Thanks. I used to know these things but getting old.

You can limit the number of rows read at job start up. You can also limit the number of rows written with a constraint.

It is annoying though. It happens even when the connection is local. VPNs are not perfect. They drop connections too. There is some clean up too to release locks and other problems left behind because of a poor connection. I would imagine this happens the farther away the connection like off shore. ...

Not sure what you are trying to do and how we can help. You can easily parse this in BASIC. What do you want as output?

Ray, what are the the sortkkkkk files?

Go for it.

You have to do it in a routine. The routine needs to be executed from a transformer.

Capture files are coming from Universe. When you ExecTCL or ExecDOS or any of these commands they really run execute command capturing OutRec returning RtnVal. The OutRec is a file in the temp directory. It is not good that it is really large. Sort records I assume are similar.

I am not sure I want my rants to be so easily found but go for it if CR agree.

In other words it has been years since Craig has used version 5 and he has no idea. Most of us are in the same boat. Please upgrade soon.

Destroy it first then bill them to rebuild it. Great consulting tip. Thanks.

Ray living on the edge. Geez, pretty wild advice.

The default separator on key fields is @TM. So your key would be Key1 : @TM : Key2.

execute "DSD.RUN JobName -1/0 ParamName=ParamValue"

DSLink2 is probably the link name not the hash file name.