Evan and others,

We have had a long-standing policy of not using UDCs in job streams.  Our
feeling is that the UDC could be changed without the knowledge of the
application manager and to the detriment of the job stream.

If you put the proper file equation(s) in your job stream (FILE QSCHEMAC=
is probably all you need), then run QUIZ or QTP with either FILE QUIZ/QTP
USE= or RUN QUIZ/QTP and then USE the source or EXECUTE a compiled form,
you will control everything yourself and you will stay out of trouble.  The
PowerHouse UDCs have become very complex and may be suited to ad-hoc stuff,
but not, in my opinion and in the shop for which I am responsible, to
production.

There is a further problem of moving from one PowerHouse version to
another.  It cannot be done all at once, for all applications, especially
if you use compiled code.  Our jobs all contain RUN
*QUIZ/*QTP.CURRENT.COGNOS and then we control which version to use by logon
UDC file equations: FILE QUIZ.CURRENT.COGNOS=QUIZ.version.COGNOS.  The
system UDC has a file equation FILE QUIZ.CURRENT.COGNOS=QUIZ.CURRENT.COGNOS
so that the RUN statement will never fail.  (No I do not think that use of
UDCs for this is inconsistent with my first paragraph.  I control the
system or account UDC, but do not have that same influence on PHNMUDC or
whatever the name may be changed to in the next release.)

We use compiled QUIZ and QTP always, not so much for some efficiency (it's
still interpreted code, after all) but as an assurance that the syntax is
correct prior to the "midnight run".

Leonard Berkowitz
RIA Group (Warren, Gorham & Lamont)
617-292-8349 (TZ = EST5EDT)




______________________________ Reply Separator _________________________________
Subject: Powerhouse question
Author:  "Rudderow; Evan" <[log in to unmask]> at
Internet-Exchange
Date:    10/02/96 7:00 PM


Hi all,

Every one in a while we have a problem with jobs using Powerhouse,
specifically they encounter some kind of severe error -- like a full data
set -- which ought to cause the remainder of the job to flush.  Of course
the UDCs for QUICK, QUIZ, QTP, etc. as distributed by Cognos have a CONTINUE
statement just before the RUN statement, so the jobs don't flush.

Have any of you modified the Cognos UDCs to remove the CONTINUE statements?
 Did doing so break anything?

TIA

 -- Evan