92 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
1
answer
61
views
DataStage XML export modified via Python — new stage not appearing after re-import
I’m working with IBM InfoSphere DataStage 11.7.
I exported several jobs as XML files using istool export.
Then, using a Python script, I modified the XML to add another database stage in parallel to ...
1
vote
1
answer
69
views
Why aren’t my changes reflected after modifying and reimporting an IBM DataStage job XML export?
I’m trying to programmatically modify IBM DataStage jobs to add a new database connector stage in parallel to an existing Database stage.
Here’s my workflow:
Export a job from DataStage Designer as ...
-4
votes
1
answer
83
views
Programmatically modifying IBM DataStage job XML – changes not reflected after reimport [closed]
I’m trying to programmatically add a new database stage in parallel to an existing DataStage job by modifying its exported XML. I export the job from DataStage Designer, modify the XML via a Python ...
1
vote
1
answer
214
views
IIDR CDC Kafka Custom KCOP disable schema auto register
we are trying to replicate Db2 changes from z/OS to Confluent Kafka.
Everything works out fine for the production of simple JSON records in Kafka.
As our policies for Kafka Topics and Schemas are ...
0
votes
0
answers
52
views
Is Q Replication what's called Fast Queue in database async replication
In async replication with PostgreSQL, for example, source db will just transmit chunks of their WAL directly via network to target db, plain and simple. But I saw something like Q Replication by IBM ...
0
votes
1
answer
52
views
Default Extension for Sequential Files in IBM DataStage When Not Specified
are there any DataStage experts here?
I don't have access to DataStage, and I am working on a migration based solely on the DataStage documentation. I came across instances in parallel jobs where the ...
0
votes
1
answer
151
views
trying to read first 9 positions of a Char(50) datatype column
I am trying to compare two columns one with Column1=Char(9) and other with Column2=Char(50). Need to do Column1=Column2, but I need only 1st 9 positions of column2 to be read to do the equality ...
0
votes
1
answer
84
views
Spaces populating as 0 in the first postion in datastage(v8.5)
I am using a condition in transformer to populate space values if two statements gets satisfied. My derivation is as below:
If (Column1=Column2 And Column3='') Then Column4='' Else Column4(It's ...
1
vote
1
answer
232
views
Unsure about InfoSphere 11.7 nulls handling
At work I've come across with an old process written in InfoSphere 11.7, I'm trying to migrate it to another framework but no one seems to know how it works (including me, of course).
The ETL process ...
0
votes
0
answers
389
views
SQLSTATE = 42S02: Native Error Code = -204: Msg = [IBM][CLI Driver][DB2/AIX64] SQL0204N "SYSIBMADM.ENV_INST_INFO" is an undefined name
I am trying to run a DataStage job code of 8.7 version on 11.7.
job has below stages:
output file1 output File2
^ ^
| ...
1
vote
1
answer
620
views
How to aggregate strings in multiple rows in IBM InfoSphere DataStage grouped by a given ID
I am given a table like the following of a attendece of employees at a company. The data should be extracted from a sequenctial file which has comma seperated values.
ID
Weekday
Attendence
1
Monday
...
0
votes
1
answer
186
views
PostgreSQL Table data auto purging through Datastage Job
We are having a Postgres table which is filling very drastically (almost 5GB/day). We wanted to purge the Table for every 2 months old record.
We want to implement a Datastage job for auto purging the ...
0
votes
2
answers
377
views
Bulk edit DataStage jobs? [closed]
We are repointing a large number (>1000) DataStage jobs from one database to another. As part of this, we will need to make the same changes to a single stage for many jobs.
So far, we have been ...
-1
votes
1
answer
878
views
Generating a sequence number in IBM datastage
I have a request to generate a sequence number and it should be done in the following manner
Retrieve the initial value from a seq tracker table
Use that value as sequence number and add it as ...
0
votes
0
answers
648
views
Couldn't get File Lock
In a datastage parallel job we are getting a warning
user prefs: java.util.prefs.BackingStoreException: Couldn't get file lock
Observations : The error is coming up only for one job, and for only ...