DSXchange

OK, I had to check those things first. In parallel jobs, where data types are strictly enforced, the data browser shows complete precision and scale for decimal values, adding leading and trailing ... Also Ray i have another question...Can we merge two mainframe files using the merge stage....or do...

How are you specifying null handling? Have you nominated a default value for these decimal fields? Are there any warnings about nulls being logged? ... Ray, I have not specified the default value......There are now warnings at all on the nulls being logged.....i can view the data but the data looks...

Hi, I was trying to import the cobol file using the CFF stage...when i did on the server job there was no problem i svieing the data or working with the data come out perferct.. weh i did the paralle job with the same cobol file definition ...the decimal value in paraleel seems to be weired... Serve...

hi,

I am trying to import tabledefintions using the db2 plug in
But it is saying plug in is not intialized....If any anyone can help it will be great....

Thanks,

There's really nothing all that fundamentally different about a UNIX install. You'll have an 'install.sh' script to run rather than (I assume) a setup.exe to double-click on. The Installation and Upgrade Guide has sections for UNIX installs, things to do before and after the install... it's all the...

hello everyone, I want to know how to instaqll Datatstage on the AIX machine.I have done Installation on windows but i don't have any idea on the AIx.Is there any best possible apporch to do.Is ther any installation procedure that need to be carried out for setting up the server before installing.li...

ray.wurlod wrote:The warning can safely be ignored. It informs you that a point has been reached where the hashed file will not fit in the write cache, and that therefore the hashed file writes will go to disk. Disa ...

Thanks ray...The job completed without any issues..

Use HFC(Hash file Calculator) to find out the minimum modulus and other attributes to set up for your estimated data. Then set those in your Create hash file options. Also, Check "Hashed file before writing" option and disable delete file before create option if you have checked it. Other...

Set the caching attributes to NONE and then see what happens? Also, as mentioned in the earlier post Disable "Allow stage write cache" option if you have it enabled. thanks Kris..as you said i turened the "Allow stage write cache" off.but the performance went down than before..i...

What is the average length of record you are trying to load? How many columns does the hashed file have? You might be either hitting the 2.2 GB limit of hashed file or running out of space on the disk? Check for both of them. I have only the key column in the file the size did not hit even 1 GB.i c...

I am doing a extraction and loading to a hash file.the input table has more than 100 million records.I am using a IPC stage and link partitioner to partion it and split them into 4 hash files.The hash file i craeted is dynamic one but after loading 4 million records to a hash file it throws up the e...

Hi, I am using Oracle 9i and Datastage 7.5 Sever Edition. When I write a user defined sql for inserting into target table (Oracle) and update action is User -defined sql, and run the job, it gives warning message is not supported for pre-defined update action. The source is Oracle table. Is user de...

I've been reading and answering a lot of your posts lately. :lol: When doing an SCD, you transform a source row and compare it to the most recent existing row in your database. If there is no r ... there is an excellent document given by craig which gives you everything about SCD.you can refer to t...

chulett wrote:Those have been there for... years. ...

sorry my bad.

Hi We have DS 7.1r1 right now. We are planning to propose the client to upgrade it to DS 7.5. We need to document the differences between the 2 versions. Pls find the differences which I could Identify 1. RowSplitter and Row Merger(not in DS7.1present in DS7.5) 2. Start Loop and End loop activity(a...