Oninit cdi / Archive
Talk to an expert →

"Cannot perform express mode load on table with ps

Posted in 2009

Topics: Platform-Specific Issues

POONAM — — source: IIUG Forums & Mailing Lists

Hi all i m using Informix 10 FC7 on HP-UX I m trying to load data in table using HPL,but whenever i run the dataload job it gives me the following error "Cannot perform express mode load on table with pseudo rowid" i have tried loading the data in deluxe mode using following command but it didnt work. onpload -j jobname -flcis this the rite command for loading the data in deluxe mode. can anyone help me out with rite command... Thanx poonam

↪ replying to POONAM
VIKAS — — source: IIUG Forums & Mailing Lists

Hi Poonam, Untill the guru's help you with a specific solution to your problem, Here is an good article on HPL: http://www.ibmdatabasemag.com/blog/main/archives/2008/05/the_informix_hi.html http://www.ibmdatabasemag.com/blog/main/archives/2008/06/the_informix_hi_1.html http://www.ibmdatabasemag.com/blog/main/archives/2008/07/the_informix_hi_2.html Hope this helps ! Regards, Vikas ------------------------------------------------------------------- Hi all i m using Informix 10 FC7 on HP-UX I m trying to load data in table using HPL,but whenever i run the dataload job it gives me the following error "Cannot perform express mode load on table with pseudo rowid" i have tried loading the data in deluxe mode using following command but it didnt work. onpload -j jobname -flcis this the rite command for loading the data in deluxe mode. can anyone help me out with rite command... Thanx poonam

↪ replying to POONAM
Fernando — — source: IIUG Forums & Mailing Lists

On Tue, Feb 24, 2009 at 9:45 AM, POONAM TANDEL <poonam_tandel28@yahoo.co.in>wrote: > Hi all > i m using Informix 10 FC7 on HP-UX > > I m trying to load data in table using HPL,but whenever i run the dataload > job > it gives me the following > error > "Cannot perform express mode load on table with pseudo rowid" I suppose that the table is fragmented and has ROWIDs (ALTER TABLE ... ADD ROWIDS) This isn't supported by High Performance Loader in express mode. > > i have tried loading the data in deluxe mode using following command but it > didnt work. > onpload -j jobname -flc> is this the rite command for loading the data in deluxe mode. > can anyone help me out with rite command... This looks like the correct command... what was the error? Regards, -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --000e0cd3404e6ef3940463a95c15