HPL unload with a query filter

Posted in 2012

Topics: Migration, Import/Export & Data Conversion

NEIL TRUBY — Fri, 30 Nov 2012 20:55:43 — source: IIUG Forums & Mailing Lists

How can I alter this: onpladm create job $JOB_NAME -d $ARRAY_NAME -D $DATABASE -t $TABLE -fa -n so that I also only select he rows from $TABLE, say customer, where customer_id < 100000 Thanks Mr Lazy

↪ replying to NEIL TRUBY

Paul Watson — Fri, 30 Nov 2012 21:00:50 — source: IIUG Forums & Mailing Lists

Look in the manual Thanks Mr Lazy Answer -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of NEIL TRUBY Sent: Friday, November 30, 2012 2:56 PM To: ids@iiug.org Subject: HPL unload with a query filter [28986] How can I alter this: onpladm create job $JOB_NAME -d $ARRAY_NAME -D $DATABASE -t $TABLE -fa -n so that I also only select he rows from $TABLE, say customer, where customer_id < 100000 Thanks Mr Lazy **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Paul Watson

NEIL TRUBY — Fri, 30 Nov 2012 21:04:40 — source: IIUG Forums & Mailing Lists

I'm already two-thirds of the way into a cheeky little Shiraz-Viognier, and I can't make head nor tail of it.

↪ replying to NEIL TRUBY

Paul Watson — Fri, 30 Nov 2012 21:13:14 — source: IIUG Forums & Mailing Lists

Try http://presentations.oninit.com/public/2007IDUG/K07.pdf Cheers Paul -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of NEIL TRUBY Sent: Friday, November 30, 2012 3:05 PM To: ids@iiug.org Subject: Re: RE: HPL unload with a query filter [28989] I'm already two-thirds of the way into a cheeky little Shiraz-Viognier, and I can't make head nor tail of it. **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.