DSXchange

If you know the decimal value of that character, you should be able to use the CHAR() function to represent it.

There will be a "performance impact" to your jobs. Don't ask me how much, there are too many factors but suffice it to say that it needs to be managed.

I thought what I wrote was pretty clear. Yes, via a script. Yes, by deleting old entries. In essence keeping a "rolling X days" of entries.

You "clear" it the same way everyone else does regardless of environment or schedule - based on the age of the files. Once a job finishes successfully, the information in the phantom files is no longer needed. Pick a number of retention days old that you are comfortable with - three, seven...

Sometimes he just jumps in at the end without reading all the boring stuff before that.

mavrick21 wrote:Now I'm wondering if a hashed file can be marked read-only in VOC.

Possible. I believe all objects have a "read only" attribute but don't recall ever seeing a hashed file with that set. If that's the case, any reason you can think of why someone may have set that?

I believe clear.file should be followed by set file command. Followed by, no. Since CLEAR.FILE only works on "account-based" hashed files, then you may need to preceed it with one if it was "pathed". However, Maveric is talking about one in a project so it comes with one at no c...

Sometimes a fresh brain works wonders. And no, that's not a Young Frankenstein quote.

"Mark unread" is a standard option at every other board that I visit. This is also the only place with two behaviours that irketh me: 1. When you leave the site, everything you haven't read is lost, meaning they show as "read" when next I visit. Everywhere else they stay until I ...

Let's not continue to pile on that four page thread, new issue = new post.

Now... what about the hidden file in the directory? Wasn't sure if you had checked that or not. And how about the D_BLAH_BLAH dictionary file?

Sorry but I have no idea what you are trying to say here. If you've tried something and not gotten the results you needed, explain to us what you tried and what you ended up with.

REPID|last_name|Jan_sales|Feb_sales|Mar_sales|Jan_desc|Feb_desc|Mar_desc
100|Smith|1234.08|1456.80|1578.00|'Jan_sales'|'Feb_sales'|'Mar_sales'

REPID (key)
LAST_NAME (key)
PVTDESC: Jan_desc,Feb_desc,Mar_desc
Q1SALES: Jan_sales,Feb_sales,Mar_sales

OK... wasn't asking how many admins you had but rather how large of a team of developers those five admins covered.

Then forget my whole assumption as to what you want, it was a guess on my part based on what the end result you wanted looked like. Still doesn't change my answer - in order to have quotes of the same type inside a quoted string, the internal quotes must be escaped. Nothing more than that going on. ...

Add in three "Pivot_desc" fields to the link and hard-code them to your values, pivot those along with the sales columns.