DSXchange

So sorry to here of Kim's passing. While I never met him personally, I always found him to be extremely helpful whenever he could...and his input will be greatly missed in this forum

I've used the find command to execute the orchadmin command in the past quite successfully..although all my datasets where in the one directory...but I see no reason why the code you wrote wouldn't work...have you tested it on a small subset to confirm , or as suggested used an echo command to confi...

The issue is that certain stages have issues with password containing '*'. The resolution is to ensure all password fields wrap the password in double-quotes to ensure the full password is passed back to the database system.

Traps for young players...

I've worked around this problem for now by removing the Surrogate key stage and using the .NEXTVAL function to build the key...but i will chase this issue with IBM for a resolution.

Hi Roland

Yes the sequence is present, and I have access to sequence to generate the next value...confirmed through Toad

I have a job that has run successfully on my dev and uat servers, but is failing in Production. The error seems to be in the Surrogate key stage - SK_Employer,0: Caught exception from runLocally(): APT_ParseError: Expected "," or "}", got: "*", line 1. The stage is desi...

Have you checked your .odbc.ini and uvodbc.config files are setup correctly on your server?? You can use the DS_CONNECT command from a universe command prompt within your project directory to confirm if you have setup your config correctly. I.E. locate directory where project is on file system, and ...

Check your Version.xml file in the default installation location, this will tell whether the install was successful or not.

To reinstall you will need to use the -force option on the install command

Hi Just had a similar problem myself. You probably need to download and install the MSXML Parser. See system doco http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/index.jsp?topic=/com.ibm.swg.im.iis.productization.iisinfsv.install.doc/topics/wsisinst_chk_server1.html The parser can be found by...

Check your JAVA_HOME environment variable is pointing to the correct java engine location

Hi IBM recently release a patch for DataStage 8.1 Fixpack2 which I have discovered corrects a lot of issues around the SCD stage, so before you do anything I would recommend applying this patch. There are a number of tutorials around the SCD stage if you do a Google search, I used this one and found...

Hi Ernie As part of the training process various users were assigned data steward status, this gave them ownership of various categories and terms within the glossary and I believe made them more engaged. Procedures have been put in place to allow for feedback and suggested changes to definitions, w...

We've just put BGA onto 1500 desktops across the organisation...taken about 6 months to get the glossary into a shape that is meaningful to the business community. We are still taking baby steps, but the feed back I'm getting in regard to BGA is positive currently. Had a number of issues around MDW,...

Hi all Was just wondering if anyone has thought about being able to expose a read only version of business glossary to a public website?? As an organisation we publish a number of documents/reports on our externally facing web site. As we have a fairly rich deployment of Business Glossary for intern...

IBM have made a patch available to optionally allow you to determine if the 'Before SQL' will be executed before the 'Table Action'. The patch is JR38195 and it requires 8.1FP1 installed, and is available for AIX. I'm not sure if its available for any other systems, and it only applies to the Oracle...