Search the web
Sign In
New User? Sign Up
toaddb2beta
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Real people. Real stories. See how Yahoo! Groups impacts members worldwide.

Best of Y! Groups

   Check them out and nominate your group.
Click here for the latest updates on Groups Message search

Messages

  Messages Help
Advanced
Importwizard   Topic List   < Prev Topic  |  Next Topic >
Reply < Prev Message  | 

Heyas,

After importing roughtly 80k rows, the "Read Rows" and "Imported Rows" Information in the wizard result window differs:


Find attached the DDL, the import script and the import file.

HTH :)

Marc

SET SCHEMA = 'STAT';

CREATE TABLE "STAT"."CADIS_BELOG_VDID" (
  "SDGNR"        VARCHAR(35)        NOT NULL,
  "SDGDATUM"        DATE        NOT NULL,
  "C_ADID"        VARCHAR(10)        NOT NULL,
  "C_VDID"        VARCHAR(10)        NOT NULL,
  "C_EDID"        VARCHAR(10),
  "C_VLDKZ"        INTEGER,
  "C_IMPORT"        VARCHAR(1),
  "Z_EDID"        VARCHAR(10)
)
  IN "USERSPACE1";

ALTER TABLE "STAT"."CADIS_BELOG_VDID"
  DATA CAPTURE NONE
  LOCKSIZE ROW
  APPEND OFF
  NOT VOLATILE;





IDS Logistik GmbH
Marc Rink
- Software Development Manager -
Saaläckerstrasse 8
63801 Kleinostheim

Tel: +49(6027)40903-13
Fax: +49(6027)40903-9013
MOB: +49(170)9672528

Internet:    
http://www.ids-logistik.de
E-Mail:      marc_rink@...

Sitz der Gesellschaft: Kleinostheim
Amtsgericht Aschaffenburg - HRB 10253
Geschäftsführer: Dr. Michael Bargl
Vorsitzender des Beirates: Mathias Krage

------------------------------------------------------------
"Computer games don't affect kids. I mean if Pac-Man affected us as kids, we'd all be running around in darkened rooms, munching magic pills and listening to repetitive electronic music."
--Kristian Wilson, Nintendo 1989.


2 of 2 File(s)

Tue Nov 24, 2009 12:49 pm

docjones999
Offline Offline
Send Email Send Email

< Prev Message  | 
Expand Messages Author Sort by Date

Heyas, After importing roughtly 80k rows, the "Read Rows" and "Imported Rows" Information in the wizard result window differs: Find attached the DDL, the...
marc_rink@...
docjones999
Offline Send Email
Nov 24, 2009
12:51 pm

Marc, How many rows actually get imported into the table? I'm not sure if the "Imported Row" count is wrong or if Import is rejecting most of the rows. If...
kenryan20072000
Offline Send Email
Nov 24, 2009
2:52 pm

Hi Ken, All rows have been imported. It seems that just the counter is wrong. regards Marc IDS Logistik GmbH Marc Rink - Software Development Manager - ...
marc_rink@...
docjones999
Offline Send Email
Nov 24, 2009
2:56 pm

Marc, I am able to recreate this issue. I have entered cr68999 to track this issue. Thank you for reporting this. Ken Ryan Toad for DB2 Development Quest...
kenryan20072000
Offline Send Email
Nov 24, 2009
3:28 pm

Marc, I am able to recreate this issue. I have entered cr68999 to track this issue. Thank you for reporting this. Ken Ryan Toad for DB2 Development Quest...
kenryan20072000
Offline Send Email
Nov 24, 2009
3:29 pm
Advanced

Copyright © 2010 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help