On 4:50pm, Fabrizio Napolitano wrote: > Hi Gregory , > > You don't use partitioning but it is a DB2 EEE server? > > if it is to load non partitioned table you should connect to the node > where the table reside and then issue the load with the "modified by > noheader" option Yes, It was my fault, I did not read "LOAD" page in the doc carefully, even it is so big. It works perfect.
One more question - I want to load 4.500.000 rows from a file without data for identity column... But identity is integer only. I could not create an identity with bigint. And I could not find in the doc how to use nextval for <sequence> in the "create table" statement. May be there is a description on ibm site (url?), but a search showed nothing usefull, DB2V7,2 included docs does not have even "create sequence" described. What I have tried it is "generated as (nextval for <seq>"; "generated as (values nextval for <seq>)" but still do not understand how to use a sequence (guess I should use it since it is possible to use bigint in "create sequence") Thank you to who answered and red! Gregory G. V. --------------- Any opinions in this posting are my own and not those of my present or previous employers. According Isham Research's Devil's IT Dictionary mainframe is: "an obsolete device still used by thousands of obsolete companies serving billions of obsolete customers and making huge obsolete profits for their obsolete shareholders. And this year's run twice as fast as last year's." - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
