Stack Overflow
Stack Overflow

Questions tagged [ibm-infosphere]

IBM InfoSphere Platform provides all the foundational building blocks of trusted information, including data integration, data warehousing, master data management, big data and information governance.

87 questions
0
votes
1 answer

IBM IIDR for kafka - User Exits are not clickable

I am currently using IIDR v11.4.0.3 linux x86. Subscription setup - using kafkaproducer.properties file to setup my kafka properties. After setting up the subscription and confirming that replication is working, despite stopping the replication, i…
Lim Gangyi
  • 5
  • 1
0
votes
1 answer

Unable to connect IIDR CDC to kafka

When trying to connect IIDR replication engine for kafka to a kafka cluster via Zookeeper, I am getting the following error kafka.common.KafkaException: Failed to parse the broker info from zookeeper:…
Lim Gangyi
  • 5
  • 1
0
votes
1 answer

IBM Datastage - input file metadata

We have multpile DataStage jobs that input flat files. Is there a quick way to find what job uses specific 'file.csv'? I'm looking for some kind of search bar within DataStage or Governance Catalogue.
marcin2x4
  • 1,321
  • 2
  • 18
  • 44
0
votes
2 answers

Misinformation in DataStage XML Export

As the title suggests, I am just trying to do a simple export of a datastage job. The issue occurs when we export the XML and begin examination. For some reason, the wrong information is being pulled from the job and placed in the XML. As an…
lildakota
  • 141
  • 3
  • 15
0
votes
1 answer

Why stored procedure stage in DataStage not working properly?

I need to use the stored procedure stage. Currently I'm making just for an example for how to use it right. CREATE OR REPLACE PROCEDURE "STG"."TRUNC_TEST" AS BEGIN execute immediate 'truncate table TESTSP'; END; That's my example of simple…
PiPio
  • 89
  • 1
  • 3
  • 11
0
votes
2 answers

IBM Infosphere Data Flow designer Server Access is denied when starting

I installed Infosphere Information server 11.7.1 Information Server on a Windows 2019. All the services for Infosphere and DB2 started in when I check the Window Services. However, when I log into the server as admin, a console appear The message on…
user2315860
0
votes
0 answers

Db2 errors post installing through InfoSphere Federation Server

I am planning to do SQL replication through InfoSphere Federation Server and installed the latest version from IBM website, while running the executable iisetup.exe, federation tool create the db2 instances and ask for db2user password and port as…
sandhya agarwal
  • 5
  • 2
0
votes
2 answers

How to insert value with quotes in DataStage?

Hello i've been having a problems because of the source file containing multiple double-quotes. I've been trying to figure out how it is, and i'm currently using a regex in transformer stage This is the Source (csv) "Error--Setting Bp Auto Risk…
PiPio
  • 89
  • 1
  • 3
  • 11
0
votes
0 answers

Converting Decimal to Timesamp issue

I am new to the Data Stage. My question is: how to convert decimal value into Timestamp? I had got a few of ideas but the tricky part is the incoming value might have: - 16 digits (real example:2101202016241758), - or 15 digits (real example…
arhetyp
  • 85
  • 6
0
votes
0 answers

How can i make the XPATH FORMAT as i wanted to (customized) in DataStage?

I'm literally confused how to make the XPATH in DataStage, because i've tried some things from Google and that gave me no hope or whatsoever. What i wanted is something like this :
PiPio
  • 89
  • 1
  • 3
  • 11
0
votes
1 answer

How to run a Java Integration Stage with a different version of JRE?

My current InfoSphere Datastage 11.5 has JDK 1.7 installed. In this I have a considerable amount of developments (over a thousand) but I'm developing a specific requirement with a Java Integration Stage that needs a larger version (JDK 1.8 or…
ByteBat
  • 337
  • 4
  • 14
0
votes
0 answers

Why join result reutrns 0 records in Datastage?

I've got a join , which the join is from another join and an Oracle Connector It does kinda looks like this : but the inner join results returns 0 records, which is not how it should be. Because i've made a query before designing the Job and i…
PiPio
  • 89
  • 1
  • 3
  • 11
0
votes
3 answers

How to get current date -1 (yesterday) in DataStage?

Hello i've been working on how to get yesterday date in DataStage? CurrentDate()-1 When i compile the job, it gave me an error. So how should i do to get the yesterday date? btw that code i'm doing it in the Transformer stage
PiPio
  • 89
  • 1
  • 3
  • 11
0
votes
1 answer

How to change 2 digit years into 4 digit year in Datastage?

Hello guys i wanted to asks , i have some problems with my source data Which is like first column is 01-Dec-18 and second column is 07-Jan-65 Which is the first column that i guess it should be 01-Dec-2018 because it can't be 1918 right? And the…
PiPio
  • 89
  • 1
  • 3
  • 11
0
votes
0 answers

How to add new line after closing tg in Datastage xml output?

So i've been making a XML output with the output layout/format/styling like this 20191021 1 20191021 1 …
PiPio
  • 89
  • 1
  • 3
  • 11
1 2 3
4
5 6