DSXchange

We have upgraded from 4.11B to 5.2R1. Our complex flat file stage is no longer performing properly. We are receiving garbage data (control and special characters). Our platform is AIX UNIX. Has anyone run into this problem, or is anyone successfully using the CFF Stage with 5.2R1?
- Doreen

Hashed files are the physical implementation of UniVerse RDBMS tables. You can therefore query them with a UV stage or a Hashed File stage. The former uses UniVerse SQL, which is compliant with the ODBC 2.0 grammar with extensions for handling multi-valued columns (probably not an issue in your case...

Hi, This sounds more like a problem for support. I think you are running out of unix file descriptors when you fail to open a file that you know exists. There is a unix kernel parameter that limits the maximum number of files that can be opened at any one time. This manifests when the job(s) run ind...

We are running DataStage 4.1 in our Production environment at Present. Server: Win2K DBMS: Ingres II on Solaris With one of my control jobs we rely heavily on ODBC to pass data into Ingres. I run a number of queries before loading into and Ingres Table, which are taking a long time due to the slow I...

Wow that was helpful! I have 5.2 and it works great!

Techniques are taught in Ascentials "Programming with DataStage BASIC" class. 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/IBM@I...

This is a topic for an orphaned message.

yes there is. I have a document and couple of routines that do it for you. Ill email them once I get to my hotel room tonight. PKM ----Original Message Follows---- From: Shrikanth Ramanathan Reply-To: To: datastage-users@oliver.com Subject: Reading from INI files Date: Tue, 14 May 2002 10:02:39 -070...

Hi, I have seen performance increase of 2 to 3 times, if you write the output to file and use oracle bulk loader component to load data into the table. Dinesh Jain -----Original Message----- From: Marzio Rotondo [mailto:ce101882@tlsoft.it] Sent: Tuesday, May 14, 2002 3:54 AM To: datastage-users@oliv...

Is there any way of reading data from an INI file
using a Job Control?

__________________________________________________
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com

Well having personally spent a lot of time in various hardware vendor Benchmark labs the results of one test can be seen at www.etlbenchmark.com I would have to say that people are using DataStage PX simply because its the only way they can process the amount of data they need to in the batch window...

Actually, ETL tools are great for complex transformation, as well as bringing extra technology to the table. You have to remember that mixing database activity in with DataStage RESTRICTS DataStage to operating at the speed in which the database can supply data. Passing data from one table to anothe...

I should add on a Unix server. -----Original Message----- From: Myles Sigal [mailto:Myles.Sigal@medstat.com] Sent: Tuesday, May 14, 2002 9:29 AM To: datastage-users@oliver.com Subject: RE: Automatic export Tell me more about dscmdexport and import. Were running 5.1. Thanks, Myles -----Original Messa...

Ops!!! Im sorry, dscmdexport.exe/dscdmimport.exe are available only on DS5.2 (Ive not found it on DS5.1). This tow utilities are command line application and can be run unattended. Also, dscmdimport.exe allows to import ALL project or "ASK" for component. Regards, Riccardo ----- Original Message ---...

Marzio, Perhaps this is overly simple, but I would create and run the same thing via SQL*Plus with an insert/select statement and compare the results. Either replace the @outrownum with an Oracle sequence or some constant. BTW, an Ascential consultant/trainer has told me that in his opinion the main...