DSXchange

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.

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

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.

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

Hello. Please help. I'm trying to read reply's to my question I'm to renew my membership at the link for "Yes, make me a Premium Member at the regular yearly rate of US$99". I keep getting the following "404 (Page Not Found) Error" I have tried the contact emails for this site bu...

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.

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

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

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.

Thanks ray

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.

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

Thank you everyone for your replies. They have been most helpful.

Apologies chulett and thank you and ray for your replies. I'll take a look at the install scripts and documentation.

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