DELIVERY FAILURE: host mail.idugdb2-l.org[207.36.18.105] said: 551 Message relaying to

Steve Westfall

DELIVERY FAILURE: host mail.idugdb2-l.org[207.36.18.105] said: 551 Message relaying to
This is the Postfix program at host smtp1.atl.equifax.com.

I'm sorry to have to inform you that the message returned
below could not be delivered to one or more destinations.

For further assistance, please send mail to <postmaster>

If you do so, please include this problem report. You can
delete your own text from the message returned below.

The Postfix program

<[login to unmask email]>: host mail.idugdb2-l.org[207.36.18.105] said: 551 Message
relaying to this domain disabled (in reply to RCPT TO command)


Reporting-MTA: dns; smtp1.atl.equifax.com
Arrival-Date: Fri, 9 Jan 2004 16:48:35 -0500 (EST)

Final-Recipient: rfc822; [login to unmask email]
Action: failed
Status: 5.0.0
Diagnostic-Code: X-Postfix; host mail.idugdb2-l.org[207.36.18.105] said: 551
Message relaying to this domain disabled (in reply to RCPT TO command)

----- Message from [login to unmask email] on Fri, 9 Jan 2004 15:47:58 -0600
-----

To: [login to unmask email]

Subject: SQL Question: dividing data into equally
sized segments






Here's a question for you SQL gurus. I couldn't find this in the archives.
(We're on DB2 UDB V7.2 on AIX, by the way.)

For analysis and reporting purposes, I need to find out how to use SQL to divide
any given set of rows into equal sized subsets based on the sorted numeric key
values? For example, I might want to segment the total set of rows into
quartiles (4 equal sized groups), deciles (ten equal sized groups), etc.

Is there an SQL solution for doing this (aside from the brute-force method of
getting the total number of rows and then opening a cursor with the data ordered
by the key column and fetching my way through all rows to get the value of the
key at the appropriate points)?

I know that some RDBMS vendors have proprietary functions that facilitate this,
but I need a generic solution that could be used on RDBMSs of different vendors
(DB2, Oracle, SQL Server, etc.), because the application we are developing will
be used with DB2, Oracle, and other RDBMSs.

Thanks in advance.

Steve Westfall
Equifax, Inc.
Lombard, Illinois


This message contains information from Equifax Inc. which may be confidential and
privileged. If you are not an intended recipient, please refrain from any
disclosure, copying, distribution or use of this information and note that such
actions are prohibited. If you have received this transmission in error, please
notify by e-mail [login to unmask email]

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NOMAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm