DSXchange

I am on 3.6 and I have some big routines so I think its been fixed Mark Griffin AMP Sr. Application Developer Data Warehouse Systems CIGNA Healthcare Two College Park Drive, 454 Hooksett, NH 03106 Phone: 603-430-7610 603-268-7239 Fax: 603-268-7909 email: griffimk@hlthsrc.com >>> David.Barham@angloco...

That is what saved me when I blew the 32k limit. Except, I was using a real editor, not notepad. I thought an editor which could use colour syntax highlighting, had advanced search and replace options and could use macros was slightly more useful than the supplied editor in Manager. I didnt realise ...

They had a "cunning plan". They edited the expressions in Notepad, and used copy-and-paste. > ---------- > From: David Barham[SMTP:David.Barham@anglocoal.com.au] > Reply To: informix-datastage@oliver.com > > Gee, 8k expressions. Can you imagine trying to edit those in the > little window y...

DataStage has an XML writer stage! > ---------- > From: Louis Orloff[SMTP:LO@EMatrixSports.Com] > Reply To: informix-mv@oliver.com > Sent: Wednesday, 9 August 2000 06:49 > To: informix-mv@oliver.com > Subject: Universe to XML > > Can anyone give me some assistance on the possible existence of a > tr...

This is a topic for an orphaned message.

I had one customer ran into an undocumented "gotcha" with long expressions. There is a limit of 8K for an expression. At 3.1 this customer had expressions about 6K in length (!). In 3.6, names are substituted, so that stage, link and column names in other languages can be converted into AS...

Gee, 8k expressions. Can you imagine trying to edit those in the little window you get in designer. Mind you, there is (was?) also a limit on how big a routine can get in Manager. I found out the hard way that the limit is 32k. (This is in 3.5, I think it was fixed at one of the 3.6 point releases)....

Any special reason why you are upgrading to an already out of date release? From what I have read, there are a lot of useful new features in DS 4. I believe 4.01 is the current release and 4.02 is available this month. (Ive heard rumours that 4.1 is also fairly close as well). -----Original Message-...

Brad, this has been a known (sporadic) issue with Oracle since sometime in the early 7s release. I have seen this on HP and IBM systems and remember dealing with the installations in-house support as well as Oracle directly to see if the cause could somehow be removed and must, to my shame, admit th...

Has anyone run into the following situation? We have jobs that update Oracle via an OCI8 stage. On occasion, we get the following error: "ORA-03113: end-of-file on communication channel" Our DBA and network people dont observe any communications problems. In fact, other people connected to...

Oops! Almost forgot. Regarding the upgrade from DS 3.1 to DS 3.6+: When I upgraded from 3.0 to 3.1 way back when, I remember we had to install Microsofts MDAC version 1.5 on the NT Server. I dont see anything in the release notes of 3.6.2E mentioning anything about installing a later version. Anyone...

Well be converting in the next month from DS 3.1.1r3 to 3.6.2Er1. Our platform is DS running on an NT Server and sending data to an Oracle 8 database which resides on a DEC Alpha. Any lessons or experiences out there from others that I can learn from? Thanks in advance. Sincerely, Brad Vincent Compu...

You might need to configure the SQL server DSN to point to a default database. When reading from a SQL Server ODBC stage, you can specify the database, but when importing with Manager, you cant. It only seems to look at the default database set in the ODBC DSN definition. We are also using 3.5. I do...

This is a topic for an orphaned message.

This is a topic for an orphaned message.