DSXchange

I think you had to be able to read all of it to get to the 'insightful' part.

Phooey, didn't notice that three different columns were being tested here, which can change things a bit. My first comment is more applicable to something like this "A=5 or A=6 or A=7" but is still perfectly valid here. All of the columns would need to be not equal to their pass value for ...

The second. Think about the first... 5 is not equal to 6 (or 7) so it would pass. All of the values would pass. You could also Not() the original one if the syntax is allowed there:

Welcome! I would assume this has to do with the dynamic repartitioning that can go on and so something you'll have to account for, but will defer this to the more smarter people here running this on more than one server. Me, haven't been anywhere yet where it wasn't constrained to a single, typicall...

If it doesn't, i.e. you just need to skip Sat & Sun, then you could write something to loop from one date to the next and not count them. A lookup would be best, however, as you may be able to get the number of 'working days' a week or a month at a time.

Short answer is 5. :wink: I'm assuming you mean the number of working days between two dates. Regardless, you would need to define a 'working day' for us. Does it include company holidays? If so, you'll need some kind of 'date dimension' like lookup, be it a warehouse table or spreasheet dumped to a...

Thank you, another Andy Nugget stashed away in my Favorites.

Thanks for your reply but your suggestion does not solve my issue. Because you tried it and it didn't "solve your issue" or you looked at it and decided it wasn't going to work? Ernie is The Man when it comes to DataStage and XML around these here parts so I'd be shocked if he suggested s...

The only other place I can think of might be in the dsenv file but I'm not sure why anyone would do that. Or perhaps the user's .profile has it set.

How well have you managed your table metadata? From the Manager, find the table definition in question and use the Usage Analysis tool to see all jobs where it was used. The icon looks like a glass beaker.

Please also tell us what database this is and what your target column's data type is.

zulfi123786 wrote:This is strange but i am unable to delete this post, Please ignore

Not so strange, rather one cannot delete a post that has been replied to. So if you accidentally 'double post' (which is what I assume happened here) you need to delete the second one.

So, I am using following code: mv #SrcDir#/Filename* #TgtDir# || echo Move Failed and it is working for me.. I'm always curious in situations like this - did you look up what the "pipe pipe" means in UNIX or since it works for you are you just using it? Serious question, btw. It has a sis...

You would do all that from the Manager. The Usuage Analysis tool icon looks like a 'beaker' from a chemistry set.

Interesting. If you check the document outside of DataStage, is it valid / well formed? Is the version of the file you are processing in the job the same as what you posted, i.e. the 'pretty printed' version from XMLSpy, or is it as it was sent from the source?