DSXchange

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,

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. ----------------------------------...

Thanks Paul for your response. As you mentioned about validation of branded odbc. Please elaborate it further how should I do this.

Thanks,

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...

Hi Chullet,

We have just noticed that Oracle Connector Stage -- Output -- Properties tab
Lookup type was Normal. We changed to Sparse and it working fine


Thanks,
Shamim

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...

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 "...

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'...

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,

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...

Hi Craig,

Our source(Oracle) and Target(Netezza) both are UTF8. So we are using project default UTF8, NLS in our datastage job.

Thanks

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...

Hi,

In Iseries DB2, EBCDIC500 is the character set and Thai characters are converted to EBCDIC500.

Thanks

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...

Hi Chulett,

Can you please explain what do you mean by " a routine that leverages DSExecute()"