DSXchange

Thank you for the help. The only solution I can think of would be to create a script which does the following:

1) Call orchadmin -s to output data set schema
2) Convert the output to .dsx format
3) Import from .dsx file

Hello,

I was wondering if it is possible to import a table definition from a data set from the command line, either through Orchestrate Schema Definitions or any other approach.

I believe orchdbutil only works with databases and not data sets.

Thank you.

Ray, I tried your approach and got the same results. The Epoch option is definitely working in the Row Generator stage but no matter which value I set for the limit, it doesn't apply. Whether the Limit value is 20 or 20000, the stage generates the same values. Thanks for pointing out that the Limit ...

Good thing I installed both those fix packs.

Thanks for the help!

Hello, I am working in DataStage v9.1 Fix Pack 2 and am using the Row Generator stage to generate a Date data type. I open the extended column properties and set a generation option of random and a limit option of some date (for example 2013-01-01). The stage generates random dates but doesn't apply...

Checked that too, but they are both setup alike.

For now, we got around by removing the Env Variable entry from the Administrator... this helped it get the NLS_LANG value from the DSENV file.
Thanks for reading and sharing your thoughts.

Hi, We have 2 different datastage projects in the same server. NLS_LANG is set as an Environment Variable in Administrator under both projects.. The initial value is left blank. NLS_LANG is also defined, with a value, in the DSENV file. (and my understanding is that the same DSENV applies to both pr...

I had a question of the job run reporting available in the Web Console. I was able to generate operational metadata for a job run and import the XML report into the repository. After importing, I created a Job Run report for the particular job. My question is: Can we run a script which produces this...

According to: http://www-01.ibm.com/support/docview.wss?uid=swg27018822 1) Depends on your topology. If you plan on installing all tiers on one machine, you need a minimum of 6 GB of RAM. 2) Disk space required depends on which products within the Information Server suite you decide to install. The ...

Hello,

Did you try attempting to retry the failed attempt in the exception handler? Did you just keep getting the error?

Yes I have included the library directory in the LD_LIBRARY_PATH environment variable. I have tried setting this value directly prior to running ISA Lite.

I am performing an 8.7 re-installation on a RHEL system. After I uninstalled and cleaned up the directories I ran the ISA Lite tool. The installation pre-req checker returns a failure saying that the required library libXp.so.6 32bit is not installed. However when I check the machine via the rpm com...

The required version of DB2 and WAS will be installed if you plan on installing them with the IIS installation software.

This was the only topic I found on this exact error and thought I would post my solution as well. I received the same exact error during a fresh 8.7 installation and retrying the failed action was not working. I manually uninstalled WAS/DB2 components and tried to re-install (with the same installat...

I was able to successfully install DataStage with the firewall up. The only ports which were required to be open for installation were: 1) 22 (SSH) 2) 8084 I then opened the remaining required ports for the client to work and it appears to be functioning correctly for now. Also should note that the ...