Search found 7201 matches

by admin
Fri Oct 19, 2001 8:55 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Loading textfile
Replies: 3
Views: 478

Set the "incomplete columns" rules in the Sequential File stage - scroll right in the Columns grid. Use Help for full information. Put an output constraint on the following Transformer stage so that the header and trailer records are not processed. These techniques are taught in the "Programming wit...
by admin
Fri Oct 19, 2001 8:50 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Loading textfile
Replies: 3
Views: 478

Dirk, In the column definition of your input file, define the extra columns (when comparing last row with rest of the data rows) as Nullable and in the "Incomplete Column" section, fill them in as "Replace". This way, your DS job would not abort. regards, At 10:38 AM 10/19/2001 +0200, Dirk Moolman w...
by admin
Fri Oct 19, 2001 8:38 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Loading textfile
Replies: 3
Views: 478

Loading textfile

I have a job loading a text file. The first line is just a heading, which is easy to handle. My problem is, the last line is a trailer record that should not be loaded. In the one job the trailer record has the same number of columns as the detail records, so I can test for the record and just skip ...
by admin
Fri Oct 19, 2001 8:34 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Is anyone out there using NLS?
Replies: 1
Views: 536

Is anyone out there using NLS?

This is a topic for an orphaned message.
by admin
Fri Oct 19, 2001 8:34 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Is anyone out there using NLS?
Replies: 1
Views: 536

Bill, General problems you will have if you use UniObject and UVODBC (neiter are not working) On server parts I have some problem with condition SELECT with russian letters on file with nls.file.map PC866 codepage and incorrect result uniseq() function I use Win2000 uv 9.6 I recomend to convert all ...
by admin
Fri Oct 19, 2001 7:14 am
Forum: Archive of DataStage Users@Oliver.com
Topic: File Merge: multirows --> single row
Replies: 0
Views: 826

File Merge: multirows --> single row

Im trying to merge multiple rows of a source file into a single row in a target file. eg. AAAA 0001 X AAAA 0002 Y BBBB 0003 X CCCC 0004 X CCCC 0005 Y becomes: AAAA 0001 0002 BBBB 0003 CCCC 0004 0005 Target file spec: source.col1(join col) || source.col2(if col3 = X, always exists) || source.col2(if ...
by admin
Fri Oct 19, 2001 7:03 am
Forum: Archive of DataStage Users@Oliver.com
Topic: UniObjects Source Control Policy
Replies: 4
Views: 811

We use Microsoft Visual SourceSafe for all of our source code control. It has good integration with VB, and can be used in development teams quite happily. It also seems to be quite robust and does the job well. You can setup SourceSafe so that it either supports multiple simultaneous check-outs of ...
by admin
Fri Oct 19, 2001 6:50 am
Forum: Archive of DataStage Users@Oliver.com
Topic: UniObjects Source Control Policy
Replies: 4
Views: 811

UniObjects Source Control Policy

Before we start coding with VB6 I need to put in place a source control policy as the traditional methods dont suit. Does anyone have some rules and / or tools on how they control their source libraries, both test and production. Any advice on this would be most helpful. Thank you.

Regards,
Hans
by admin
Fri Oct 19, 2001 4:59 am
Forum: Archive of DataStage Users@Oliver.com
Topic: NLS Performance
Replies: 3
Views: 602

Actually, I have found one glitch. If you use READBLK, SEEK or WRITEBLK, and expect to read/move/write a number of bytes, beware that they actually process a number of characters. This is not as documented, but did break a couple of programs I use in the UniVerse Internals class. There is a workarou...
by admin
Fri Oct 19, 2001 4:57 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Fujitsu+IBM versus NEC+Microsoft
Replies: 4
Views: 686

Alliances are very common as a marketing mechanism in Japan. Its an entirely different commercial world than what those of you in "the West" are used to. For example there was an alliance between Ardent and Microsoft - Ive got a carry bag and tee shirt to prove it! Dont worry about it.
by admin
Fri Oct 19, 2001 3:52 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Fujitsu+IBM versus NEC+Microsoft
Replies: 4
Views: 686

Would Fujitsus corporate culture really allow this to work? If so, is information-technology supplier consolidation good for i.t. end-users, too, or only for i.t. stock-holders? -- Ben R. Edmund Klamann wrote: > Fujitsu confirms IBM alliance talks > > Thursday, October 18, 2001 at 18:30 JST > > (Reu...
by admin
Fri Oct 19, 2001 2:09 am
Forum: Archive of DataStage Users@Oliver.com
Topic: NLS Performance
Replies: 3
Views: 602

As always Ray your knowledge is amazing. Craig -----Original Message----- From: Ray Wurlod [mailto:ray.wurlod@Informix.Com] Sent: Friday, 19 October 2001 11:29 To: u2-users@oliver.com Subject: UV: NLS Performance >Has anyone had any horrific problems? Works well as the engine for DataStage throughou...
by admin
Fri Oct 19, 2001 1:48 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Aborts
Replies: 5
Views: 1103

At the risk of stating the obvious, isnt the job number 115 as shown in the error message? -----Original Message----- From: Ray Wurlod [mailto:ray.wurlod@Informix.Com] Sent: Friday, October 19, 2001 9:04 AM To: datastage-users@oliver.com Subject: RE: Aborts Find out the job number (lets say 42 for a...
by admin
Fri Oct 19, 2001 1:29 am
Forum: Archive of DataStage Users@Oliver.com
Topic: NLS Performance
Replies: 3
Views: 602

>Has anyone had any horrific problems? Works well as the engine for DataStage throughout Asia. Havent heard of any horrific problems, except where there were a couple of characters incorrectly mapped (in one case because Micro$oft didnt follow a standard they claimed to follow). >Do we need to regre...
by admin
Fri Oct 19, 2001 1:02 am
Forum: Archive of DataStage Users@Oliver.com
Topic: Six months from today.
Replies: 2
Views: 476

Six months from today.

This is a topic for an orphaned message.