Search found 7201 matches

by admin
Fri Oct 19, 2001 6:39 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: format.conv on >2GB files flunking on Compaq/Dec Alpha to HP
Replies: 2
Views: 524

My experience is you can only READSEQ large files. We have some very large records in type 1 and 19 files and get the same error if you try to edit or list. -----Original Message----- From: Stevenson, Charles [mailto:Charles.Stevenson@getronics.com] Sent: Friday, October 19, 2001 9:42 AM To: u2-user...
by admin
Fri Oct 19, 2001 6:00 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: HELP.........
Replies: 1
Views: 474

I would run guide on your file INVOICE.SALES.STATS and delete and re-create the indexes. (Of course, repairing the file if guide reports errors). Colin Alfke Product Development Manager Vertical Technologies Inc. #450, 800 - 6 Ave. S.W. Calgary T2P 3G3 P:(403) 237-7095 F:(403)237-7080 -----Original ...
by admin
Fri Oct 19, 2001 5:46 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: HELP.........
Replies: 1
Views: 474

HELP.........

HELPPPPPPPP, We have encountered some errors when doing a MATWRITE on Unidata version 4.1 on a Solaris Spark box. The errors are as follows: Index: invalid idx_no (18) of node 670240768 (should be 5). 1: Inserting index value(s) error in U_append_strtuple for file INVOICE.SALES.STATS, key 008_J_0802...
by admin
Fri Oct 19, 2001 5:45 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Happy 12345
Replies: 2
Views: 467

A similar problem appeared last month on September 8 when Unix timestamps finally reached 1000000000. Some programs truncate it to 9 characters resulting in the believe that its March 3, 1973. However, the only one Ive noticed so far is HPJetAdmin. >>> tpellitieri@centuryequip.com 10/19/01 08:01AM >...
by admin
Fri Oct 19, 2001 4:42 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: format.conv on >2GB files flunking on Compaq/Dec Alpha to HP
Replies: 2
Views: 524

format.conv on >2GB files flunking on Compaq/Dec Alpha to HP

Trying to move large files (64BIT) from a DEC alpha to HP and FORMAT.CONV ( fnuxi ). It fails. I get blink errors & "available memory exceeded" with bomb out of uv & coredump.

All 3 of the >2GB files have these same troubles.
None of the
by admin
Fri Oct 19, 2001 4:24 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: File type of /uv/catdir
Replies: 0
Views: 475

File type of /uv/catdir

Currently we are running Universe 9.4.1.1 on an IBM RS/6000 39h. We are going to be switching to an IBM RS/6000 F50 which will be running Universe 9.5.1.1D. I noticed that /uv/catdir is a Type 1 file (.Type1 is present). Question #1: Does the /uv/catdir directory have to be a Type 1? While in the pr...
by admin
Fri Oct 19, 2001 4:24 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: order by clause
Replies: 0
Views: 411

order by clause

Hello everyone, we are on Datastage version 4.1 on an NT Server, using the ODBC stage as a lookup to a Sql Server 7.0 table. Its possible to get more than one row on a lookup, and I want to return the first row based on the order by clause. I cant seem to get the order by clause working, even when I...
by admin
Fri Oct 19, 2001 4:00 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: copying U2 databases
Replies: 16
Views: 1758

At 09:35 AM 10/19/01 -0600, you wrote: >All this talk of UD triggers has got me wondering about Universe >triggers. At one time UV only supported triggers for Tableized files. >Is this still true? > >Jerry Cantwell > > Unfortunately, yes... Dave ======================================================...
by admin
Fri Oct 19, 2001 3:49 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: [OT] Fujitsu+IBM versus NEC+Microsoft
Replies: 4
Views: 772

Paul: Thats probably a very good analogy because the auto industry also has a huge segment of both suppliers and resellers that are typically much smaller in size than the "assemblers". However, in our own mdRDBMS industry there are actually VARs that are actually quite a bit larger than at least on...
by admin
Fri Oct 19, 2001 3:49 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Request for Comments on Unidata 5.2.x
Replies: 3
Views: 451

Request for Comments on Unidata 5.2.x

This is a topic for an orphaned message.
by admin
Fri Oct 19, 2001 3:49 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Request for Comments on Unidata 5.2.x
Replies: 3
Views: 451

We are up to 5.2.17 and have no problems with it on NT 4 or 2000. The only release we have had an issue with lately was 5.2.9 where looking at a variable in debug caused the session to freeze. So I would have no concerns about 5.2 over 5.1. Since you are on SB 4 I would also serious look at moving t...
by admin
Fri Oct 19, 2001 3:42 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: copying U2 databases
Replies: 16
Views: 1758

ECL RESIZE has never had a problem with removing triggers. Shell level, memresize had a problem (removed the trigger) and was fixed in 5.1.14 and 4.1.37 (and of course all 5.2 releases). Wally Terhune Manager - U2 Advanced Technical Support - IBM Data Management Solutions 303.294.4866 - wally.terhun...
by admin
Fri Oct 19, 2001 3:38 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: UV ODBC
Replies: 5
Views: 882

From: "Klein Doyen T" To: Sent: Friday, October 19, 2001 9:18 AM Subject: RE: UV ODBC > ....fingers point to ODBC, but no one can prove anything, so take it > as just a > word of caution and with a grain of salt (where in the world did that > expression come from?). In olden times, salt was thought ...
by admin
Fri Oct 19, 2001 3:35 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: copying U2 databases
Replies: 16
Views: 1758

All this talk of UD triggers has got me wondering about Universe triggers. At one time UV only supported triggers for Tableized files. Is this still true? Jerry Cantwell Wally Terhune wrote: >>From memory, I believe we fixed that resize/trigger problem quite some >>time > ago. What version of UniDat...
by admin
Fri Oct 19, 2001 3:32 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: UV ODBC
Replies: 5
Views: 882

19/10/2001 12:43:20, Aleksejs Lucko wrote: >Hi ! > >We are trying to use ODBC to UniVerse. >Does anyone have any experience with it? Is it stable, fast ? And what >kind of fun should we expect with it ? Any information will be helpful! >Thank you. > >Regards, > Alexey Luchko. > > Fast : No. Partly b...