DSXchange

Hi Lawrence, you can change your license via Administrator using root/administrator account. This can be made without unistall datastage. I think that into Ascential site you can find somthing useful but i dont remember if you can download plug-in. Hope this will help you Riccardo ----- Original Mes...

Dear all I need to upgrade my current datastage license to a new one with a greater user limit.. Is there a way I can do this without having to uninstall the client an all the machines then reinstall with the new license details...? Also... I need to get hold of an XML plugin.. Anyone know where I c...

What I have been missing so far in your discussion is, that you can make any externally created hash-file known to any Project with: SETFILE /MyPath/MyFile MyName where /MyPath/MyFile is the externally Path and FileName where it was created and MyName is the Name under which I want to adress it in m...

Dear Raymond, Thanks for your tips. I am unsure of step no (3), as i dun understand what is VSG. Can you pls elaborate on this step? Hope you can help. Thanks celeste Raymond Wurlod wrote: > This would need to be done in the UniData database: > (1) by modifying the file dictionary > (2) by adding th...

I agree with Kens points. However, one reason that I have used hash files "within" the project is that it facilitates the process of copying data between hash files in different projects. I use this technique when I want to copy data from a hash file in a production project to a hash file in a test ...

Hello Kenneth, if you create your hashfiles in a project (different from the datastage project) you have the metadata avaible and can use it in other projects twice. On the other hand you could only analyze statistics about hash files in a project. This is very important for optimize the throughput ...

This would need to be done in the UniData database: (1) by modifying the file dictionary (2) by adding the MONTH values to the newly-created field (3) by processing with VSG if necessary Then re-import the UniData file definition into DataStage and modify any jobs that use it. You can use the where-...

The VOC entry is not made when you put hash files external to the DataStage project. A little history: Creating a hash file without specifying the project or directory path leaves DataStage to create it in your project. This is bad. Putting runtime work files (sequential or hash) in the same file sy...

This task (horizontal pivoting) is exactly what the Pivot stage is designed to do. Raymond Wurlod Trainer, Asia-Pacific Region IBM Informix Education Department Level 22, 60 City Road, Southbank Vic 3006 Australia Telephone: +61 3 9626 6624 Facsimile: +61 3 9626 6622 Notes: Raymond Wurlod/Australia/...

Hi Rui, You can use the Pivot Stage to flip the data on its side. Or I have used HASH files in the past to cycle thru my records in a transformer to build up my single record. Using a unique key and constraints. Cheers _____ Stewart Hanna PreSales Consultant Melbourne, Australia +61 3 85175400 +61 4...

Hi, in my input file, we received in each record , the information for all month. We want to transform each record in 12 records. How can we do this "magic" ? with best regards Rui Soares Rui Soares NOVABASE - Data Quality - QP Mail : Rui.Soares@Novabase.PT Tel (NB) : 351 21 383 65 92 Tlm : 351 96 3...

Christian, yes, you have both options with the give you freedom of choice to either separate your data from project metadata or to have datastage (Universe) care about it. For the directory option - since datastage doesnt know anything about that hash file, you can simply delete it with OS commands ...

Hi Ken I have been told that when creating hash files using the project/account option, the VOC will be aware of their existence (which isnt the case otherwise) Isnt this extra piece important or useful? Could you use Basic commands such as Delete.File if the hash file is externally stored? just won...

Yes, It was. Thanks a lot. The Oracle rel. that Im using right now is 8.1.6, and seems to work correctly (until now). Thanks for your reply. Best regards. Giovanni ----- Original Message ----- From: To: Sent: Thursday, July 04, 2002 12:26 PM Subject: Antwort: Problem trying to work on Metastage dire...

Hello Giovanni, use MS Explorer Maintenance -> Directory Versions and Unlock latest Version (be sure there are no other connections to the repository at this time). also - Upgrade to Oracle 8.1.7 because Oracle 8.1.5 is not supported - Upgrade to MS 2.3.3r1 - If you have sometimes locking problems w...