DSXchange

Take a look at this http://www.dsxchange.com/viewtopic.php?t=89892 Couple of options here.

ODBC on Notes has always been slow. They can dump to a sequential file fairly easy. That works much better and is lots faster.

Are you sure it is a char(25)? Your oconv() should change it to a period not a question mark.

The bug is they print in the log but never get passed to the shell script or UNIX command.

Is is a bug. Supposed to be fixed in 7.5.

Try it on a local directory. Maybe it cannot write to drive E:. Otherwise the test project is Test or some other project.

I would bet you have a metadata problem. Maybe the number of columns do not match the number returned.

Post the SQL.

Craig

Just trying to keep up with your posts. Forget about Ray maybe I can catch Ken between contracts.

If you unlock the jobs then it never skips a job.

My version is in Scripts.zip. It is both ADN and my tips page. It has a way to do a UNLOCK command from the client. Included is Dwn_ExecTCL.exe which will allow you to execute any TCL command from the client. Ray may not like the fact that I released the locks but it solves this problem. If you have...

Here is the code to do this. I am clearing out a few of my mutiple instance jobs. This will not work as a routine. You need to get out of Director and back in before you see a change. This is a job. USE AT YOUR OWN RISK: * ------------------------------------------------------------ * EtlClearLog...

Cmd = 'SSELECT RT_STATUS':JobNo:' WITH F1 = "INVOCATION" TO 2' This is out of one of the programs I wrote for DsWebMon. Field 1 has the word INVOCATION in it. The @ID is the instance id or invocation id. JobNo is stored in DS_JOBS. So if the job number is 957 then: delete from RT_STATUS95...

This http://www.dsxchange.com/viewtopic.php?t=89939 post has the instance id for RT_LOG. Just change this into a delete.

Makes sense.