DSXchange

Or just export it first so you don't need to futz with a backup after the delete.

You really should start your own post rather than jump on the end of a six year old post, but - short answer is 'yes'. Simply 'Add to Schedule' multiple times.

Each job stream updates the CUST_ID.hsh hash file with new CUSTID and DWH_CUST_ID values. There is a situation where each feed may have a new CUSTID and may try to insert the same DWH_CUST_ID value for two different CUSTIDs. How is this situation where 'the same DWH_CUSTID could be assigned two dif...

I've also found a need to put a short sleep - 5 seconds? - between the job reset and the job run, in spite of the -wait option. Perhaps that might help here as well.

As noted in your error message:

pavans wrote:the result is non-nullable and there is no handle_null to specify a default value.

Curious... how do you propose to convert string values like your "WS" into a decimal?

Are you sure you need a 'workaround' for this? It's a character field for a reason, which more than likely means you actually have no issue. If somehow that data now needs to be stored in your database without trailing spaces, then yes you would need to arrange to have the field changed to a VARCHAR...

Not sure, I didn't have that problem when I tried out what I was suggesting. Perhaps just try again and see if it is a little less... busy.

Handle what? As noted, one cannot trim a CHAR field.

While, as you've noted, there's no way to constrain it I have found it simple enough to check the Author column in the search results for that same name. If there are many postings to weed through, then use the Sort By option of 'Author' was well to lump them all together.

One suggestion would be patience. Clear it from the Status view, not the log view and then... wait. That or CLEAR.FILE RT_LOGnnnn if you know the job nnnnumber, but then you'll need to reestablish the auto-purge settings afterwards.

Then you should be able to do what I said, leverage COMMON storage and a dynamic array.

User-defined SQL?

There you go. Time to mark the thread as Resolved, it seems.

First thoughts were how one would do it in a BASIC Server routine, but I'm guessing that wouldn't help here. So this is a C++ routine you wrote? I'm thinking there must be some kind of equivalent you could do... for Server you would: 1. Declare COMMON storage 2. Declare an array to hold the file con...