HPL unload with a query filter

Posted in 2012

Summary

Neil Truby asked how to add a row filter (customer_id < 100000) to an HPL unload job created with onpladm create job. Paul Watson first said to look in the manual, then, after Neil said he could not make sense of it, pointed him to an IDUG 2007 presentation PDF. No direct command was given.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

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.