634 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
Advice
0
votes
2
replies
74
views
Address Standardization using Databricks Pyspark
I am trying to convert a DataStage code into Pyspark. In existing DataStage code, Standardize stage is used to standardize US Address, US Area and US Name. I want to replicate the same logic into ...
0
votes
1
answer
60
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
68
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
81
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
votes
3
answers
128
views
Datetime conversions through different systems
I'm currently working on a project where I need to import data from multiple sources and use them to build a reporting system.
One of the sources is a Hive table that has a timestamp column (VARCHAR) ...
0
votes
1
answer
138
views
No window when compiling on DataStage
Previously, when compiling on DataStage, a small window would appear throughout the compilation and provide failure reasons, etc... Pretty standard stuff. Recently I've noticed that window doesn't ...
0
votes
0
answers
53
views
java .jar file throwing Closing org.springframework.context.support.ClassPathXmlApplicationContext
From the datastage we have called a script which invokes a jar file, this jar files helps to connect to another application which has user details in it. After fetching all the user details, this jar ...
0
votes
0
answers
2k
views
ORA-12008: error in materialized view or zonemap refresh path and ORA-01722: invalid number when refreshing materialized views
I'm encountering an issue when attempting to refresh a materialized view. The following errors are presented:
ORA-12008: error in materialized view or zonemap refresh path
ORA-01722: invalid number
...
0
votes
0
answers
41
views
Fatal Error: CDIER0943E: The REST step found an invalid URL #$pURL# causing the error java.net.MalformedURLException: no protocol: #$pURL#
Disclaimer: I am very new to datastage and am a Career shifter so forgive me if I do not know much.
I'm encountering an issue with Datastage's Hierarchical Stage. The REST Step Configuration failed to ...
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
81
views
IBM HPU 5.2 - Converting EBCDIC Characters to Blanks
We are using the latest available HPU in our shop, version 5.2.
We need to unload some tables that are quite large (hundreds of millions of records) and transfer those files to an IBM Datastage system ...
0
votes
1
answer
111
views
String parsing in DataStage
I have a problem with a DataStage Parallel Job that doesn't parse strings properly.
I have a csv file, with two columns containing json-shaped strings. The job reads it with a Sequential File stage, ...
1
vote
0
answers
112
views
DataStage Sequencer Stage doesn't continue the process after Nested Condition
I have a DataStage Sequence Job that needs to branch the process on the basis of which value is passed to a parameter.
I decided to add a Nested Condition Stage from which three links part. This is ...
0
votes
1
answer
27
views
Separate Numeric Range value from single row to individual rows per value in range
I have a CSV with one field that has numerical values as strings. A few of these values are a numeric range [e.g. 30-34]. For rows that have a range value in this field I need to split the range ...
0
votes
1
answer
140
views
DataStage Job writes zeros instead of file values
I have a problem with a DataStage parallel Job, that fails in writing the correct values of a column of a txt file. Instead of the values contained in the file, it writes 0 in every record.
The ...