On 27 Oct 2006 07:09:41 -0700, in bit.listserv.ibm-main you wrote:
>
>Clark
>
>See below for answers to your issues.
>
>
>Robert Galambos
>
>Compuware Senior Technical Specialist
>IBM Certified Solutions Expert -
>DB2 UDB for OS/390 Database Administration
>[EMAIL PROTECTED]
>
>> some snippage
>.....
>
><I have just started at a new client in the application development and
maintenance area and at the moment am in a mood of outrage at two of the
vendors we love to hate.>
>
>SORRY TO HEAR THAT. IS THERE A REASON THAT YOU/WE 'LOVE TO HATE'
COMPUWARE?
This comment in one sense was hyperbole based in part on perceived
objectionable billing practices and escalation of costs on a system
upgrade. It was more based on reading of various postings here than
personal experience.
>
> <<My greatest ire at the moment is aimed at Compuware and File-aid. I
have a multi-format record file so I am using the XREF capability to get
formatted listings and compares. The description for the detail doesn't
have 4 filler bytes at the end (the detail description is actually the
description of the DB2 table entry, not the flat file detail with record
code in front). Listing is fine with the complaint about the missing 4
bytes. However the [EMAIL PROTECTED] designers of the compare function decided
to
default to hex listing of the record on a mismatch with not way out of
this that I can find. I can see listing the last 4 bytes in hex but why
are they so brain dead as to print the entire record? >>
>
>SORRY YOU FEEL THAT WAY. IN ANY TIME A VENDOR, NOT ONLY COMPUWARE, TRY TO
ENHANCE THEIR PRODUCTS, DEVELOPERS, PRODUCT MANAGEMENT ETC. GAGE THE NEEDS
OF MARKET PLACE/CURRENT CLIENTS IN TERMS WHAT CAPABILITIES ARE
NEEDED/WANTED/ENHANCED WITHIN THE TOOL/PRODUCT. LET ME ASSURE YOU, WE
DON'T JUST PATCH SOMETHING TOGETHER JUST BECAUSE IT LOOKS 'NICE'.
>
><I want to use production descriptions, not something I cobble together.<
>
>WELL ACTUALLY YOU CAN CHOICE NOT TO PRINT THE WHOLE RECORD. ONE ONLY HAS
TO TYPE 'Y' ON THE FIRST PANEL OF THE COMPARE FUNCTION ON THE 'PRINT
OPTIONS'. YOU THEN WILL BE SHOWN TWO ADDITIONAL PANELS, WITH ONE OF THEM
GIVING THE USER TO ABILITY TO DETERMINE WHICH RECORDS TO PRINT (MATCH,
INSERTED, ETC.) AS WELL AS WHAT TO PRINT (FIELDS COMPARED, FIELDS DIFFER
ETC.) THIS SHOULD ANSWER YOUR QUESTION I BELIEVE. THERE ARE OTHER OPTIONS
AVAILABLE AS WELL FOR PRINTING.
I have limited the choices and still get the same result:
E729- COBOL LAYOUT TOO SHORT TO FORMAT ENTIRE RECORD
E612-RECORD PRINTED IN HEX FORMAT DUE TO ABOVE ERROR
The compare control records generated by FILE-AID are:
*
* COMPARE OPTIONS
0000 COMPARE_MODE=FORMATTED
0000 COMPARE_TYPE=1-TO-1
0000 RECORDS_TO_COMPARE=ALL
0000 DIFFERENCES_TO_COMPARE=ALL
0000 USE_DATA_SOLUTIONS_CHANGE_CRITERIA=NO
0000 DATA_SOLUTIONS_MAXIMUM_INVALID_FIELDS=ALL
*
* PRINT OPTIONS
0000 PRINT_FORMAT=FORMATTED
0000 MAX_DIFFERENCES_TO_REPORT=ALL
0000 RECORD_TYPES_TO_PRINT=CHANGED,DELETED,INSERTED
0000 FORMATTED_REPORT_STYLE=COMPARED
0000 COMPARED_FIELDS_PRINT_OPTION=CHANGED
0000 FIELD_STATISTICS_REPORT=YES
*
* OUTPUT OPTIONS
* NOT SPECIFIED
*
* SYNC/KEY OPTIONS
* NOT SPECIFIED
*
* COMPARE FIELDS SET 0001
0001 OLD_LAYOUT_MEMBER=RTCSDIST,
LAYOUT_NAME=DCLPMTDIST,
REFER_TO_XREF_BASE=001
0001 FIELD0002:OLD_NAME=GENERATED-FILLER,OLD_POSITION=00001
0001 FIELD0003:OLD_NAME=ORIG-SYSTEM-ID,OLD_POSITION=00002
0001 FIELD0004:OLD_NAME=DIST-SN-ACCT-NO,OLD_POSITION=00006
0001 FIELD0005:OLD_NAME=DIST-SN-ACCT-IND,OLD_POSITION=00030
0001 FIELD0006:OLD_NAME=TARGET-SYSTEM-ID,OLD_POSITION=00031
0001 FIELD0007:OLD_NAME=DIST-BATCH-NO,OLD_POSITION=00035
0001 FIELD0008:OLD_NAME=DATE-TM-RECV,OLD_POSITION=00043
0001 FIELD0009:OLD_NAME=DATE-TM-UPDT,OLD_POSITION=00069,
PRINT_ONLY
0001 FIELD0010:OLD_NAME=DATE-TM-DIST,OLD_POSITION=00095,
PRINT_ONLY
0001 FIELD0011:OLD_NAME=OVERLAP-PYMT,OLD_POSITION=00121
0001 FIELD0012:OLD_NAME=USER-MOD,OLD_POSITION=00122
0001 FIELD0013:OLD_NAME=PYMT-AMOUNT,OLD_POSITION=00129
0001 FIELD0014:OLD_NAME=PYMT-DETAIL,OLD_POSITION=00134
0001 FIELD0015:OLD_NAME=PYMT-PROC-DT,OLD_POSITION=00154
0001 FIELD0016:OLD_NAME=PYMT-RECV-DT,OLD_POSITION=00164
0001 FIELD0017:OLD_NAME=PYMT-TRAN-NO,OLD_POSITION=00174
0001 FIELD0018:OLD_NAME=INIT-SN-ACCT-NO,OLD_POSITION=00188
0001 FIELD0019:OLD_NAME=CHECK-DIGT,OLD_POSITION=00212
0001 FIELD0020:OLD_NAME=INIT-BATCH-DT,OLD_POSITION=00214
0001 FIELD0021:OLD_NAME=INIT-BATCH-NO,OLD_POSITION=00224
0001 FIELD0022:OLD_NAME=INIT-SN-ACCT-IND,OLD_POSITION=00232
0001 FIELD0023:OLD_NAME=INIT-SYSTEM-ID,OLD_POSITION=00233
*
* COMPARE FIELDS SET 0002
0002 OLD_LAYOUT_MEMBER=RPCSDIST,
LAYOUT_NAME=BATCH-HEADER,
REFER_TO_XREF_BASE=002
0002 FIELD0002:OLD_NAME=GENERATED-FILLER,OLD_POSITION=00001
0002 FIELD0004:OLD_NAME=HEADER-DATE,OLD_POSITION=00002
0002 FIELD0005:OLD_NAME=HEADER-TIME,OLD_POSITION=00010,
PRINT_ONLY
0002 FIELD0006:OLD_NAME=HEADER-ORIG-SYS,OLD_POSITION=00016
0002 FIELD0007:OLD_NAME=HEADER-BATCH-ID,OLD_POSITION=00028
0002 FIELD0008:OLD_NAME=HEADER-BATCH-COUNT,OLD_POSITION=00036
0002 FIELD0009:OLD_NAME=HEADER-BATCH-AMT,OLD_POSITION=00045
0002 FIELD0010:OLD_NAME=FILLER,OLD_POSITION=00054
*
* COMPARE FIELDS SET 0003
0003 OLD_LAYOUT_MEMBER=RPCSDIST,
LAYOUT_NAME=ERROR-MSG,
REFER_TO_XREF_BASE=003
0003 FIELD0002:OLD_NAME=GENERATED-FILLER,OLD_POSITION=00001
0003 FIELD0004:OLD_NAME=ERROR-TEXT,OLD_POSITION=00002
What is especially enraging is that this same XREF works fine for just
browsing the files in question. The action taken for error E729 is in my
rarely humble opinion flat out wrong. There is enough information to give
a formatted display of all but 4 bytes. If there is a need to display
those 4 bytes, then display them in hexadecimal.
>
><...snip
>
>In the case of file-aid it is at current release (8.9) and unless
something is unusual Endevor is also current.
>
>Of course unlike IBM, you have to log in to look at their manuals.<
>
>TRUE. BUT IF THE COMPANY YOU WORK FOR HAS PAID MAINTENANCE, YOU NEED ONLY
GET A USERID (AND ITS FREE) AND THE MANUALS OF ALL THE COMPUWARE PRODUCTS
THAT ARE LICENSED AT YOUR ORGANIZATION ARE FREE TO BE D/L (AS WELL AS
REPORTING QUESTION, LIKE YOURS, TO THE HOTLINE, AS WELL AS TIPS, PATCHES
ETC.)
I will get around to finding out if manuals are on line here. If they
are, it isn't known to the people I am working with. This may be more of
a question of how does an organization document a large and complex
environment in such a way as to be meaningful to a newcomer.
>
>I AM SORRY YOU FEEL SO SLIGHTED HERE. I KNOW THAT COMPUWARE (AS WELL AS
MYSELF) HAVE TRIED TO ADDRESS THESE TYPE OF ISSUES AS QUICK AS WE CAN.
THINGS THAT WE HAVE DONE INCLUDE, AS PART OF THE MAINTENANCE, IS TO HAVE A
SUPPORT WEBSITE (FRONTLINE.COMPUWARE.COM) WHERE QUESTIONS CAN BE SUBMITTED
AND ANSWERED. WE HAVE A 800 NUMBER HOTLINE(+1-800-538-7822) IN NORTH
AMERICA (AS WELL AS OTHERS AROUND THE WORLD). WE HAVE, SPOTLIGHT SESSIONS
ON THE WEB THAT HIGHLIGHT A CERTAIN CAPABILITY WITHIN ONE OF THE PRODUCTS
(TO FIND OUT MORE GO THE FRONTLINE.COMPUWARE.COM TO REGISTER, OR D/L
PREVIOUS SESSIONS) ETC. ETC.
>
>IF YOU HAVE ANY OTHER QUESTIONS/COMPLAINTS FEEL FREE IN RESPONDING TO ME
>
>Clark Morris cfmpublic at ns.sympatico.ca
>
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
