Hi,
We have requirement to connect DB2 on Z/OS database through Datastage.
What are the steps required to configure Db2(Z/OS) in Datastage server? Please help me out.
Thanks,
Search found 62 matches
- Sat Mar 10, 2018 10:52 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Db2 Acess
- Replies: 2
- Views: 2481
- Thu Feb 15, 2018 1:59 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle connectivity issue
- Replies: 5
- Views: 4582
Dear Paul, I have looked into fix Central and found odbc driver as follows --------------------------------------- interim fix: is_ddodbc_7.1.4_server_aix DataDirect (OEM) 7.1.4 ODBC Drivers, for InfoSphere Information Server The following files implement this fix. ----------------------------------...
- Wed Jan 24, 2018 9:55 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle connectivity issue
- Replies: 5
- Views: 4582
- Wed Jan 24, 2018 7:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle connectivity issue
- Replies: 5
- Views: 4582
Oracle connectivity issue
Dear All, One of the Datastage job was accessing Oracle DB through ODBC connector stage. It is Oracle 11g version. Now as per new requirement we should switch to new Oracle DB that is 12C version. DB team kept user name and password same as old DB. We have updated existing Oracle DB entry of odbc.in...
- Thu Feb 23, 2017 8:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-01008: not all variables bound
- Replies: 3
- Views: 4915
- Thu Feb 23, 2017 8:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-01008: not all variables bound
- Replies: 3
- Views: 4915
Hi chulett, We have marked field as key in the column tab of output column of Oracle connector stage and similarly Key has been Market for main link as well. We have kept the same name both the side (from Transformer as main and from Oracle connector as reference) We kept the data type as integer in...
- Thu Feb 23, 2017 6:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORA-01008: not all variables bound
- Replies: 3
- Views: 4915
ORA-01008: not all variables bound
Hi, We recently installed Datastage 11.3.1.2. We are creating a parallel job with following design Sequential file ( One filed)---->Transformer( added one more field as key1 with hardcoded value as 1)------> Lookup stage ( Reference link directly from Oracle connector Stage with following SQL "...
- Wed Jan 18, 2017 2:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Update action with NULL Key
- Replies: 1
- Views: 2844
Update action with NULL Key
Hi All, We have a job where it updates a Netezza table through Netezza connector stage. We are using write mode as Update. In key column we have more than one fields and among them one is Nullable. In table we have NULL value for this field for few records. Whenever any row comes with NULL value it'...
- Thu Dec 15, 2016 1:10 am
- Forum: General
- Topic: Install Server and PX separately on same system
- Replies: 4
- Views: 3218
Install Server and PX separately on same system
Hi All,
One request came to us to Install DataStage Parallel with 3 Core and DataStage Server with 8 core on same machine. Is this possible? If yes, how to do it? Also, do we required special licensing for this?
Thanks,
One request came to us to Install DataStage Parallel with 3 Core and DataStage Server with 8 core on same machine. Is this possible? If yes, how to do it? Also, do we required special licensing for this?
Thanks,
- Tue Oct 25, 2016 4:49 am
- Forum: IBM QualityStage
- Topic: Investigate stage
- Replies: 1
- Views: 13760
Investigate stage
Hi, We have recently Installed IIS 11.3 (Datastage and QualityStage). I am new to QualityStage. I am using IBM QualityStage Tutorial (dsx and csv file). I am facing issue in Investigate stage In tutorial it mentioned " Double-click the InvestigateName icon Click the Word Investigate tab to open...
- Tue Jun 09, 2015 11:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: combining marks are not in canonical order
- Replies: 3
- Views: 9220
- Tue Jun 09, 2015 4:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: combining marks are not in canonical order
- Replies: 3
- Views: 9220
combining marks are not in canonical order
Hi, we have a simple job, it extracts data from Oracle and loads into Netezza through Netezza connector. Oracle source contains data in Arabic(Combining Charcater). The job is aborting with following error message --------------------------------- Reason: [SQLCODE=HY008][Native=51] Operation cancele...
- Wed Jul 31, 2013 7:55 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Character Conversion
- Replies: 3
- Views: 4154
- Thu Mar 14, 2013 4:18 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: OR Operator
- Replies: 1
- Views: 2384
OR Operator
Hi, In transformer stage we have one input and one outputlink. For one of output field we have following derivation If LkpSYSTEMIC.ACCOUNT = '119FCE' or '119FSA' Then 1 Else 2 When we pass LkpSYSTEMIC.ACCOUNT = '119FCH' then from above expression it gives output value 1 When we changed the expressio...
- Thu Jan 03, 2013 8:35 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Calling Unix script in Datstage Transformer
- Replies: 12
- Views: 9149