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
Search found 25 matches
- Tue Feb 18, 2014 5:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Importing table definitions from a data set in command line
- Replies: 3
- Views: 2183
- Sun Feb 16, 2014 2:02 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Importing table definitions from a data set in command line
- Replies: 3
- Views: 2183
Importing table definitions from a data set in command line
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.
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.
- Wed Sep 25, 2013 1:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Row Generator stage in 9.1
- Replies: 5
- Views: 3423
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 ...
- Wed Sep 25, 2013 8:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Row Generator stage in 9.1
- Replies: 5
- Views: 3423
- Wed Sep 25, 2013 8:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Row Generator stage in 9.1
- Replies: 5
- Views: 3423
Row Generator stage in 9.1
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...
- Fri Aug 16, 2013 1:32 pm
- Forum: General
- Topic: NLS_LANG not populating from DSENV
- Replies: 2
- Views: 1838
- Wed Aug 14, 2013 1:45 pm
- Forum: General
- Topic: NLS_LANG not populating from DSENV
- Replies: 2
- Views: 1838
NLS_LANG not populating from DSENV
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...
- Wed Jun 05, 2013 8:52 am
- Forum: General
- Topic: Job Run Reporting
- Replies: 1
- Views: 1655
Job Run Reporting
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...
- Wed Jan 09, 2013 9:16 am
- Forum: General
- Topic: System Requirement for DS 8.5 installation
- Replies: 4
- Views: 2518
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 ...
- Thu Oct 18, 2012 8:34 am
- Forum: General
- Topic: CDIIN4361E: Model deploy failed
- Replies: 4
- Views: 4111
- Tue Oct 16, 2012 3:24 pm
- Forum: General
- Topic: ISA Lite shows missing libXp.so.6 library
- Replies: 2
- Views: 1878
- Tue Oct 16, 2012 3:07 pm
- Forum: General
- Topic: ISA Lite shows missing libXp.so.6 library
- Replies: 2
- Views: 1878
ISA Lite shows missing libXp.so.6 library
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...
- Fri Sep 14, 2012 2:06 pm
- Forum: General
- Topic: IIS 8.7 installation help
- Replies: 18
- Views: 8458
- Mon Jul 16, 2012 3:20 pm
- Forum: General
- Topic: CDIIN4563E: Could not determine what profile was created
- Replies: 3
- Views: 5820
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...
- Tue Jul 10, 2012 8:13 am
- Forum: General
- Topic: 8.7 Installation with Firewall Up
- Replies: 3
- Views: 1825
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 ...