Receipt Confirmation - Accounts Receivable

David Booher

Receipt Confirmation - Accounts Receivable
Hello,

Thank you for reaching out to the Accounts Receivable department. This email is to acknowledge that we have received your request and will be reaching back out to you with further assistance as soon as possible. The AR mailbox is a HIGH volume department within our company, we kindly ask that you anticipate a delay in response. Rest assured, each request is of equal importance to us and will be answered in the order at which they are received.

• For Sales Requests you can expect a response in 1-2 business days

• For Invoice Adjustments & Credit Memo Requests you can expect a response in 3-5 business days.

• For Invoice Copies please provide AR with a PO, Quote, or Order number associated with the order when submitting the request. After the order has been approved and booked for processing, please allow 7-10 business days for an invoice to generate.

• For Vendor Registration Requests you can expect a response in 3-5 business days.



Regards,

Accounts Receivable team.


From: [login to unmask email]
Sent: 12/5/2018 5:25:08 AM -08:00
To: [login to unmask email]
Subject: [DB2-L] - RE: Db2 z/OS v12 - Object Comparison Tool automation
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.

The one dev team that does frequent object compares uses RC/Compare

Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
Humana Inc.
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266

From: Johan Sundborg <[login to unmask email]>
Sent: Wednesday, December 5, 2018 3:16 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: Db2 z/OS v12 - Object Comparison Tool automation


Hi Bharath,

REXX is great and absolutely a valid option when comparing Db2 objects and generating reports or input for a table, such as the one you describe.

We have something similar setup in a home made ISPF panel where you enter target/source (database) prefix and the environments to be compared. The job behind the panel then selects from catalog tables, unloads to file, compare files and creates a result file with the mis-matches. This helps us a lot in keeping certain environments in sync.

However, I don't think REXX have much of an advantage over regular batch when it comes to making these kinds of comparisons, creating delta, etc. it's probably more of a personal preference.

Regards
Johan Sundborg, Db2 DBA

In Reply to Bharath Nunepalli:

Johan,

I have developed my own OCT using REXX.

The input is the source and target databases (both can be present in same or different Db2 sub-systems) and the output is loaded into a Db2 table for future reference. The Db2 table holding the comparison details has the below columns.
SRC_DB
TGT_DB
TS_NAME
TS_MISS_IN_TGT
TS_TYPE_MISMATCH
TB_NAME
TB_MISS_IN_TGT
IX_NAME
IX_KEY_NAME
IX_MISS_IN_TGT
IX_KEY_MISMATCH
CL_NAME
CL_MISS_IN_TGT
CL_TYPE_MISMATCH
CL_LEN_MISMATCH
CL_SCL_MISMATCH
CL_NUL_MISMATCH
CL_SEQ_MISMATCH
ROW_ENTRY_TS



Bharath Nunepalli,
Senior DB2 DBA.

-----End Original Message-----

The information transmitted is intended only for the person or entity to which it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information in error,
please contact the sender and delete or destroy the material/information.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights laws and
do not discriminate on the basis of race, color, national origin, age, disability, sex,
sexual orientation, gender identity, or religion. Humana Inc. and its subsidiaries do not
exclude people or treat them differently because of race, color, national origin, age,
disability, sex, sexual orientation, gender identity, or religion.

English: ATTENTION: If you do not speak English, language assistance services, free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese):注意:如果您使用繁體中文,您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.

-----End Original Message-----