DSXchange

No guessing required, that is how it works - wildcards are not supported.

Both of your posts on this subject are either marked as or it is mentioned that you are working with the Server product, so no idea where Ray got the idea that it 'needed' to be like that.

Have you looked at what I wrote here to see if it helped at all?

I'm well aware of the history of all this. Basically, you've got someone trying to learn something without access to that something... other than documentation, that is. Besides, this isn't anything that a quick Google wouldn't turn up. No skin off my nose to give a quick 'answer' to questions like ...

Basically, yes. Minus the 'into the database' part... just 'before loading' is fine for a generic definition.

kashif007 wrote:i need some information. If i had to install a new license of datastage. can any one tell me how many users can it support.

As many as you were willing to pay for. Concurrently.

mouthou wrote:The problem here is we dont have database business. Everything is file to file.

Ansered in your other thread for this issue.

Ok then, tell us what the heck 'trace the contents' means? I had no problem clicking on the link you provided and seeing the post, hence my assumption you did not have an id for the site.

What exactly happens when you try to visit that URL?

Darn, you should really start reading replies too before you go and give advice that's already been given.

Is this a dynamic hashed file? Did you copy all of the parts that make it up - the directory, the three files in the directory and the D_ file that lives at the same level as the directory?

[sigh] Of course it will. Follow all of my instructions, not just parts. Both commands are confused by your tactical air-strike at the operating system level. You need to put something back to replace what you nuked so that it has all the bits it needs to delete all of it properly.

Why not just talk to your DBAs? They love explaining stuff like this.

This is my personal opinion, so keep that in mind.

I've never seen a situation where 'one link' was better than two. Best, IMHO, to take the time to determine what needs to be done with each row and handle each accordingly. Those dual-action updates actions are evil.

Copy a different hashed file in using the name of the one you dropped - in other words, give it something to delete in addition to the VOC record. Then use the proper command. Check your job's log that created it in the first place and use whichever command is appropriate for the method used to crea...

Jeez, why make it more complicated than it needs to be when a simple solution has already been posted? Convert("X","",TheField) -or- EReplace(TheField,"X","") The OP hasn't mentioned anything that would require the solution be any more involved...

Put some other hashed file there using that name and then delete it the right way.