DSXchange

No problem... just a little friendly harrassment.

And you would think the Filter command could handle a 'cat' like you showed but for some reason it doesn't. At least it wouldn't work like that for me on HP-UX 11.11 and DS 7.0.1.

Well... other than the fact that that's for reading and the thread is about writing... and 'cat' doesn't work in the Filter like that... great answer!

Back at ya! :D

Welcome to the first day of the rest of the year.

And just to further beat this poor horse, your situation isn't all that different from anyone needing to delete a large quantity of records from a table. Don't make it more difficult than it is by thinking you are doing something special. Yes, dropping a table will cause things like contraints and F...

No need to revert back to your Primal Scream therapy days, Ray. I thought it was very clear that none of us here were advocating the non-use of metadata. Just trying to be thoroughly anal, make some additional points about metadata usage and do our own versions of a Full Wurlod. Perhaps we should l...

Technically, the information stored under Table Definitions is not needed at all. You can build and run and maintain jobs without ever having generated any metadata, instead typing it in by hand. Over and over again. Not saying that it isn't a good idea to have and use them, just not absolutely nee...

Trim() never results in a zero-length string. Never? I was under the impression that if I trim a string with all spaces I would end up with a zero-length string. And testing seems to hold that out, unless something else is going on: Len(Trim(" ")) Returns a zero.

Actually, they did. Never understood why people felt the need to quote entire messages for no good reason and then compound the problem by burying their response inside the quote. Hi Kim, could you please guide me to write the MonitorGrid to a Flat file by Stage name, LinkName and other details Than...

Very forgiving, actually.

Set the WaitForFile to not wait and it will simply check for existance. Two links out - one 'Ok' link for the file being found and an 'Otherwise' link for when the file isn't found. By itself it should throw a warning, from what I recall. Pretty much the same thing you'd do for the Execute Command s...

Basically a Beowulf Cluster built from Furbys.

You've confused the issue by mentioning 'truncate' when in fact you didn't want to remove all of the records in the table. What I would do to remove 18 of 20 million records would be to create a new table and copy the 2 million records you want to keep into it. Then all that's left is a quick pair o...

Sounds like you need to reindex the project. Search the forum for the proper use of the DS.REINDEX command.

Did you give the WaitForFile stage a shot?

Don't use 'find' as the command, try using something like 'test' instead. Check your man pages.

Well... then have your Admin do it for you. Or have them start the deadlock deamon. Or both.