DSXchange

I am sorry, reference the patch? I think they sent us this patch in an e-mail. Let me find out the PMR of this and see if they posted it. Before anything, did you have QualityCenter upgraded in your system? Search for "exgrid.dll" in your workstation and see the versions. DS uses 2.0.0.8 a...

I was reading about this online and in IBM site, it says that "For UNIX or Linux, the istool command framework is located in: installation_directory/Clients/istools/cli, where installation_directory is the directory where you installed InfoSphere Information Server. For example, /opt/IBM/Inform...

Thanks for the reply Ray. I see this in our IBM Client Release notes IBM Information Server combines the technologies within the IBM Information Integration portfolio into a single unified platform that enables you to understand, cleanse, transform, and deliver trustworthy and context-rich informati...

I did not see Information Server Manager in the installed Client Components. Is it a special set-up that we need to do to get this client component? I will check on the ISTOOL.

Does IADB migrate the Column Analysis results and other results too as well as the schedules?

Thanks for your response Ray. I do not know much about ISTOOL or the Information Server Manager. I am under the impression that the latter is new to v8.5. If so, how can I use that to migrate the old objects? Where can I find documentation for the ISTOOL? I will try to search here... Also, there is ...

All, We are upgrading our IIS to version 8.5 and I've been entrusted with this task. I have never delved into Information Analyzer and I must confess that my knowledge is next to nothing on this tool. I've been going through some posts on this site and also some manuals to figure out what I need to ...

Thank you for your response Ray. The problem is that the entire properties page is not present when we open the stage. We do not use any Citrix based environment to connect. Our connections are direct from our workstation to the server. However, this issue was diagnosed to be a problem with a "...

All, A strange problem started quite recently in our shop. We extensively use ODBC Connector stage to do our unloads. The "properties" page - which has the SQL and all the important properties - suddenly disappeared in my system, whereas others were able to open it up. This was 10 days ago...

times29, You can solve this in myriad ways. One of the ways is to place your case statements (2 of them) in two stage variables and then concatenate all that you want in another stage variable. Use this final variable in a derivation column of your choice. Otherwise, do it all in one stage variable ...

DSGuru2B is right. That would make it simpler. What I was trying to say is you can concatenate the second if then else in the same derivation/stage variable or a different one - depending on how aesthetic you want to be

It can get pretty convoluted...this is a brute force attack on your question.

Using If-Then-Else

We use the IsNull function extensively, including in stage variables. So, I can confidently say it works. Normally, these kind of scenarios arise by the handling of the data by the tool (w.r.t the Nullable property settings and the data types). Obviously, this is defined by the developer, so it is i...

What is the "Nullable" option set to? If it is set as "NO", then you might not be getting nulls during run time in DataStage, even if you can see Nulls in the Database. Also, jwiles and Soumya's comment should also be looked into.

@jwiles: I have gone through the post and - please correct me if I am wrong - I see that it prescribes methods for orphan processes ?? after job runs ??. The problem as I understood from mandyli and the problem that we have is that when a job is started, it all of a sudden goes into this "hangi...