DSXchange

Bottom line (IMHO) you should be discussing this with your DBA rather than you trying to decide what to even ask them. I'm sure they're aware of the table structure and volume, so explain your needs and see what they recommend. Don't focus on DataStage, just the process as the tool being used isn't ...

anu123 wrote:Indexing, I am not it's a good idea to ask them to create indexes on such tables.

Well... then you are stuck doing full table scans to find the rows you want to extract (even doing it 'parallel') and you will have to live with the performance of that.

What 8.x version do you have? That will dictate where you find the settings I mentioned which control where the logs live.

Let's confirm something - are your logs in fact in the hashed files or are they in the XMETA repository? That would depend on your ORLogging/RTLogging settings, in case you're not sure.

I want to delete juste some establishment and for a specific day. I understood want you wanted, what I don't see right now why you'd "need" to do this kind of selective purge rather than just letting auto purge handle a full day or number of runs. As noted, you'd need to go under the cove...

Are you not leveraging the "Auto Purge" options?

Without an index over your filter criteria (whatever date that is) all you've got is a full table scan.

As noted: it's an alphanumeric check which is NOT what you want. Look at Num() or IsValid() as a couple of other options.

I don't have my documentation here. Is AlNum a custom function at your shop? I'm assuming that "Al" means "Alpha" and thus it is an ALphaNUMeric check rather than an "All Numerics" check. Hence my earlier reply.

The functions available are listed in the documentation, should be fairly straight forward to take what you know the DB2 function does and look for a DataStage equivalent in the list. Only thing that might not be obvious is the use of the substring operators "[]" rather than the function t...

Apparently not if the function isn't valid, never mind that you don't want to check for alphanumerics. That includes number and letters, you just want a numeric check.

I'm going to guess... NLS. Are both installs NLS enabled? Using the same settings?

Lagomorph bifurcation.

Only 13360 posts to go for me!


Ack! Sorry, I cleaned up a double-post of yours and now you need a filler post here to get back to 50,000.

You haven't posted anything to show you could use the Field() function here. Is your source any kind of delimited string? If not then you'll need to stick to substring.