Search found 7201 matches
- 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...
- 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...
- 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 ...
- 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.
- 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 ...
- 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 ...
- 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 ...
- 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
Regards,
Hans
- 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...
- Fri Oct 19, 2001 4:57 am
- Forum: Archive of DataStage Users@Oliver.com
- Topic: Fujitsu+IBM versus NEC+Microsoft
- Replies: 4
- Views: 686
- 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...
- 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...
- 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...
- 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...
- 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.