Thank you so much PaulVL.
I'm hoping for a DataStage solution, as the the resources may not have sufficient skills to support a script solution.
Search found 198 matches
- Sat Jun 04, 2022 9:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Concatenate multiple lines of data into a single line.
- Replies: 3
- Views: 10092
- Sat May 28, 2022 6:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Concatenate multiple lines of data into a single line.
- Replies: 3
- Views: 10092
Concatenate multiple lines of data into a single line.
Hello all. I have a requirement to concatenate multiple lines of data into a single line. See example below. I have tried solutions in a transformer stage variables with no success. Any help/advise would be greatly appreciated. Example Input: name age address John|43|1015 main street Queens New York...
- Fri Jun 11, 2021 3:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Looping through fields in a job while using RTP
- Replies: 1
- Views: 10982
Looping through fields in a job while using RTP
Hello All I have an ascii fixed width file with 8 fields. I want to convert that file to a pipe "|" delimited file removing leading and trailing spaces. I’m using RTP to make the job generic and reusable. Is there a way to loop through the fields from 1 to n? Thanks in advance for any help.
- Sun Aug 23, 2020 5:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generic job to convert ebcdic files to ascii.
- Replies: 3
- Views: 14522
Generic job to convert ebcdic files to ascii.
Hello All. I have dozens of ebcdic files I need to convert to ascii. I want to write a generic DataStage job(s) that converts any CFF file pass to it to ASCII text file. I need to / want to bring in the files and metadata at runtime. Is this possible with CFF? Please share any experience you may hav...
- Thu Jun 25, 2020 4:47 pm
- Forum: General
- Topic: Calculating Data Volumes passing through a DataStage job
- Replies: 4
- Views: 13876
- Mon May 18, 2020 5:45 am
- Forum: General
- Topic: Calculating Data Volumes passing through a DataStage job
- Replies: 4
- Views: 13876
Calculating Data Volumes passing through a DataStage job
Hello Everyone.
Does anyone have experience with calculating data volumes in MB?
I have the task of capturing the data volume sent to files, DB, MQ, etc. I have tried using the DSODB. Volume status are not there.
Thanks in advance for any help.
Does anyone have experience with calculating data volumes in MB?
I have the task of capturing the data volume sent to files, DB, MQ, etc. I have tried using the DSODB. Volume status are not there.
Thanks in advance for any help.
- Tue May 12, 2020 8:11 pm
- Forum: General
- Topic: Does DSODB to capture data volume passing thru DB connection
- Replies: 1
- Views: 11294
Does DSODB to capture data volume passing thru DB connection
Hello All. Does the DSODB to capture data volume passing through database connection? I have the task of calculating the volume of data Database connections stages are loading/inserting to tables on our platform. I went through the DSODB documentation and did not see a table and field that would con...
- Sun Apr 05, 2020 3:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Call the invocation of a DataStage job aligned with files
- Replies: 1
- Views: 12452
Call the invocation of a DataStage job aligned with files
Hello All. I have a job that will read a set of files. The files follow the same naming convention. The only difference in the file name is the region node and timestamp node. These files arrive at different times, within sec - mins of each other and in no particular order. I have requirement: - The...
- Sun Jun 30, 2019 12:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to list how much scratch each job uses / allocates?
- Replies: 5
- Views: 5339
How to list how much scratch each job uses / allocates?
Hi All,
Is there a way to list how much Scratch space is used/allocated by each job?, including shared containers. I need to identify job for possible redesign to use fewer resources.
Thanks in advance for any help.
Is there a way to list how much Scratch space is used/allocated by each job?, including shared containers. I need to identify job for possible redesign to use fewer resources.
Thanks in advance for any help.
- Fri May 03, 2019 8:37 am
- Forum: General
- Topic: DSODB - Is there a DSODB data dictionary?
- Replies: 6
- Views: 5668
- Wed May 01, 2019 10:11 pm
- Forum: General
- Topic: DSODB - Is there a DSODB data dictionary?
- Replies: 6
- Views: 5668
DSODB - Is there a DSODB data dictionary?
Hello All,
Does anyone know of a DSODB data dictionary? I'm trying to better understand the model and content.
Thanks in advance for any help.
Does anyone know of a DSODB data dictionary? I'm trying to better understand the model and content.
Thanks in advance for any help.
- Wed May 01, 2019 10:01 pm
- Forum: General
- Topic: DSODB - List details of files written from host
- Replies: 0
- Views: 2314
DSODB - List details of files written from host
I have task to find all files being written from a given DataStage host along with the start write, end write times, and other details. I'm hoping I can pull this information from DSODB. Is it possible to query for the following result set?: HostName ProjectName FolderName SeqName JobName StageType ...
- Wed Dec 26, 2018 6:52 am
- Forum:
- Topic: Importing non infosphere metadata into the Metadata Workbenc
- Replies: 6
- Views: 4100
- Sun Dec 23, 2018 7:09 am
- Forum: General
- Topic: I do not see the ESDB, DSODB, or SRDUSER schemas in the XMET
- Replies: 3
- Views: 3705
- Fri Dec 21, 2018 9:07 am
- Forum:
- Topic: Importing non infosphere metadata into the Metadata Workbenc
- Replies: 6
- Views: 4100
Hello chulett. I have seen this link. Thanks. Apologies for not being more specific. They really are a group of custom homegrown applications built on top of oracle and db2. One example is our customer relationship management system that does not confirm to CRMs off the shelf. So I'm thinking no per...