DSXchange

Not sure why you felt the need to hijack someone else's thread, but here you are in your own now.

The Filter stage "supports standard SQL expressions" so why not give that a try?

Yah, not exactly a DataStage question, is it? Nor in the right forum either, hang on...

what is the right forum to post this question in?

As noted, it depends on how the hashed file was created. The log will show the command used, from which you can infer what you need to do to delete. So, pathed or in an account?

I'm curious why you think you need to delete the hashed file when you are done? From both a lineage and trouble-shooting standpoint, you may be in trouble if that information is gone. Why not simply clear it (or drop and recreate it) at the start of the next run, an ability that's built into the sta...

What you talk'n about Ray?

Here is Ray's post on his technical challenge:

viewtopic.php?t=138403

No and that isn't enough details to go on other than to assume you have some sort of multi-byte characterset issue. You haven't specified what is throwing this error - a database stage? Why not share with us the entirety of the issue?

Of course TEX exists in your string, it is part of TEXAS. If you want to avoid a substring match and only match a unique delimited entry in the string, you need to add the delimiter to both ends of both of your strings: Index(",":pText:",",",TEX,",1) In other words you ...

Sorry, you're correct, that makes the technique acceptable.

As he noted, in the job's project folder. Unless you've overridden the default, it is typically at the same level as the DSEngine directory, so at worst case you can go there and then: cd ../Projects/<ProjectName> Under that folder you'll find the "RT_BP38" folder and the TRANS1 file insid...

Did you get this working? I'm curious why you thought you needed to convert anything, this should have worked fine with strings...

Ya when he was working for ascential I had a class with him in Texas call building dataware houses with datastage about 9 or 10 years ago No worries. I've left copies of his free KBA Job Control Utilities everywhere I've been and constantly added functionality over the years, so that's why it looke...