DSXchange

Thanks Ray. I discovered today, for example, that I can return a char* from my routine into a Double in the transformer. No idea if this is a problem. Also, I am sending a Timestamp into a char*. I think this one is actually correct. So maybe some are obvious

Hi folks, when building an external routine to run in a transformer, the transformer is dealing with these datatypes: VarChar Double Timestamp Date Time Decimal etc. And the routine is dealing with these: char* float long short etc. How do I know what to map to what? What works and what doesn't? Is ...

Thanks Ray, this would be a huge improvement, as it would remove the need to lock down datasets at the UNIX level.

Thanks,
Doug

Hi folks, is there an environment variable or some way of telling the Data Set Management client what to use as a root dir?

We want a project specific way of limiting the scope of the browsing to a project directory.

This would make our UNIX level security MUCH EASIER.

Thanks,
Doug

Sounds like an interview question.

Hi thanks for the followup. This fix did not work for us. The only thing that worked was setting the env variable to false. Are you on 8.1 or 8.5?

We are using SAME and SAME and no manual sorts. We have APT_NO_SORT_INSERTION set to false at the job level.

I suspect that this workaround is not always going to work. If you get to the bottom of this, please post the answer here. I am also curious if this problem occurs in 8.5

Doug

We have seen this problem in both the SCD stage and a lookup stage if a range lookup is used. In the first case, we set the APT_NO_SORT_INSERTION variable to false and that fixed it. Manually inserting sorts did not help. The sort, by the way, did not show up in the score. On the second case, sortin...

asorrell wrote:Was your old installation NLS enabled? If they installed NLS on 8.5 that would cause the Unicode issue.

Hey, I bet that's the answer to that one. Thanks,
Doug

It's really hard to explain without a screenshot of the stage. Maybe some day this forum will support that.

I think mauve has the most RAM.

Hi we (with an IBM consultant) have just upgraded from 8.1 to 8.5 and we have a number of issues. We are on Solaris and we are using Oracle for the repository. So far we have the following problems: 1) Can't import table defs using Connector Import Wizard ODBC driver (Oracle). The database parameter...

Can't you simply cross-mount, and set APT_ORCHHOME (and maybe other environment variables) on each machine? Cross mounting the project is suggested here: http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/index.jsp?topic=/com.ibm.swg.im.iis.productization.iisinfsv.install.doc/topics/wsisinst_co...

Hi we are also interested in this subject. We currently have one UNIX machine as the DS engine, which runs everything off of a mounted directory. Everything is in the directory. Install files, the project (we have one project), the dataset ds files, the dataset node files, the scratch area, and so o...

Hi Ernie, thanks again. We'll look into it.

Doug