DSXchange

We havent any more specific information yet. For the moment we are just interested in general advices about this type of configuration. Kasia At 08:54 14/08/2002, you wrote: >we implement a data warehouse project with DataStage v5.2 and DB2 >(as400) but we didnt face such problems can you please be ...

Howdy, I would check the release notes for the Merant drivers supplied with 5.2r2 and confirm that the version of the Informix databases are supported. Particularly the bits about wired and non-wired drivers. Next I would look at the library which you are pointing to, try using the Informix Supplied...

We have to implement a new data warehouse project with DataStage v5.2 and DB2 (UDB7.2) on Aix4.3.3 It seems that there are several bugs, like connection bugs, derivation in stage DB2UDB, others ...? Have you hear about that? Hope that someone can share his experience on the matter. thanks Kasia

Hi all Ill try make it as brief as possible... This error has been haunting me for just over a month now and support and I dont know whats going on. OS: Solaris 8 DStage: 5.2r2 Database: Informix 7.3.1 UC7 and Informix 7.3.1 FD3 The .odbc.ini, dsenv, /etc/informix/sqlhosts, /etc/services, /etc/hosts...

we implement a data warehouse project with DataStage v5.2 and DB2 (as400) but we didnt face such problems can you please be more specific Georges Daher Analyst Programmer Solutions Delivery Unit IT Department Banque AUDI S.A.L. Tel. : 961 1 994000 / 995000 Direct No : 977467 Ext. : 1467 Fax : 961 1 ...

Myles Cleaning up a project will not delete hash files. If they are no longer used, then you will need to delete them manually. You can use DELETE.FILE to remove them. This command will also remove the VOC entry when the hash file is deleted. Don -----Original Message----- From: Myles Sigal [mailto:...

Thanks for your help. Will cleaning up a project remove the hashed files listed in the VOC that are no longer used? Or do I still need to manually delete? And I noticed some past posts about manually deleting the dictionary and related files, I presume if I do that I still have to delete the VOC ent...

Dave thanks for your thoughts on this matter. The problem is that we have about a dozen different conversion sets (each with about 10 characters) and we dont want a different job for each set. If we crack this the whole job becomes very simple so we have quite an incentive to make it work! We are fl...

This is a topic for an orphaned message.

Thanks Kenneth - Ive restarted it and checked the space availability where the hashed file is being built and am still getting the error. I have 5 gig free in the project directory where all our jobs build their hashed files. Youre right about the fixed path for the hashed files, its something I hav...

Hello All, I have never used the Informix bulk loader in any of my jobs. I was wondering has anyone had a simple job loading an OCI stage with a transformer and then redesigned the job using a bulk loader. I am curious of the run time differences. I am looking to decrease the time a few jobs I have ...

The way that account-based hashed files are accessed is through another file called the vocabulary file (the VOC file). It is only through this mechanism that the UniVerse commands can be used. You can, if youve created pathname-defined hashed files, create VOC entries using the SETFILE command. SET...

I take it that its the Informix bulk loader that barfs? Probably you need to escape the backslash (precede it with a backslash? check your bulk loader manual). You can use the Ereplace or Change function for this. See DataStage Developers help for details. >From: Niranjan.Purohit@ing.com.au >Reply-T...

Are there any special tricks in order to use UniVerse commands such as COUNT and LIST.DICT on hashed files that were created using the directory path option? Thanks, Myles Sigal Technical Analyst The MEDSTAT Group 777 E. Eisenhower - 435B Ann Arbor, MI 48108 Email: Myles.Sigal@medstat.com Phone: 734...

First, you must recycle services in order for the new environment to be used. In addition, the path in which your hash file exists must be on a file system with enough capacity. If you didnt specify a fixed path (highly recommended that you use this functionality along with a job parameter for the d...