DSXchange

The lookup will work with an 'empty' value, but not with a NULL. For nulls, you'd need to translate that to another unique value (both sides) and use that for the lookup. For example, perhaps '*'. Do the swap in the Key Expression of the lookup.

I must have hallucinated writing something... that or I just can't find it. However, this did turn up:

http://www.dsxchange.com/viewtopic.php?t=82785

You can also do an exact search on one of the hashed names to find other posts, some with even more low level detail. For example, try searching for 'APM.BATCH'.

Ug. An upgrade is the simplest thing in the world. Other than taking a backup, as you did, the process is to simply install the new version right over the top of the old one. It handles everything automagically. Did you uninstall the old version or do something that caused the Projects to need to be...

You didn't answer my question. What should happen in that case? Then we'll see about implementing it.

Short answer, you can't. How about you tell us your requirements - what should happen when B is null?

Yes, you have to specifically request it and they will make it available to you.

If you have DataStage installed on your PC, then you do have all of the manuals. You'll find a 'Docs' folder under your software install directory where all of those pdfs live. There is also a 'Documentation' link from the start menu.

Hmmm... I really don't think that's true Arnd. It still has to be read.

I believe a small test is in order.

You two need to get a room, take your side conversation elsewhere.

Ken, no one has ignored anything, you've just taken a more literal interpretation of the problem. When the OP talked about deleting log entries, but makes comments like: at the end of the day same job has run more than 10 times with different invocation_id .this creates several entries of same datas...

I had a similiar if not the exact same problem on a Itanium server here. PA-RISC, fine, Itanium, not so fine. That was with 7.5.2, I would think the problem would have been resolved with 7.5.3. There was some kind of odd problem with the installer and IBM Support had me create a soft link from where...

Only if there are multiple delimiters in the string and you want all of the 'fields' after the first one. The assumption here was there were only two fields in the string, i.e. one delimiter.

I believe that the administrator userid can compile in a protected project.

I think the OP wong_ricky said that checking the checkbox saying the first line is column headers requires that the first line still be formatted correctly. That is, contain the right number of delimiters. I assume that is correct. Is it? A blank line isn't formatted according to the file schema. Y...