Using INFORMATION in UPDATE procedure

[Jesse, Rich]

Hi,

Thanks for the suggestions!  Did and done and, to my amazement, working. 

I really didn't think the UPDATE would do a whole lot here, since this Quick
screen has no real output.  It has no primary file and just one reference
file.  All it's intended to do (note the careful use of words) is accept
four fields, call an Oracle SQL function, and report the status.  My
original intent was to have the Quick screen run a Quiz report to do the
reporting, but I couldn't figure out a way to pass back a status without
writing two shell scripts (one dynamic, created from the other), a Quiz
report, and a QTP.  It was just simpler, faster, with less to break in a
single Oracle SQL function.  Sorry, folks...  :(

Thanks again!  :)

Rich Jesse                          System/Database Administrator
Rich.Jesse@qtiworld.com             QTI -- Sussex, WI USA


> -----Original Message-----
> From: Kirk, Dean [mailto:Dean.Kirk@COGNOS.com]
> Sent: Tuesday, August 08, 2000 03:33
> To: PowerHouse Lists 2 (E-mail)
> Subject: RE: Using INFORMATION in UPDATE procedure
> 
> 
> I strongly agree with this - try and leave the update 
> procedure alone -
> default procedures and changing them and all that!! ;-D
> 
> -----Original Message-----
> From: Kesterson, Roger [mailto:Roger.Kesterson@ryobiaz.com]
> Sent: 07 August 2000 23:34
> To: powerh-l@sphere.swau.edu
> Subject: RE: Using INFORMATION in UPDATE procedure
> 
> 
> Depending on the message, perhaps POSTUPDATE would be a 
> better place.  No
> cautions about using it there.
> 
> > -----Original Message-----
> > From: Jesse, Rich [mailto:Rich.Jesse@qtiworld.com]
> > Sent: Monday, August 07, 2000 3:25 PM
> > To: powerh-l@sphere.swau.edu
> > Subject: Using INFORMATION in UPDATE procedure
> > 
> > 
> > Hi,
> > 
> > I wanted to spit out a custom message at the end of my 
> UPDATE in QUICK
> > v8.13d1 on HP/UX 10.20 (the Java training isn't done yet...). 
> >  So, I use the
> > INFORMATION verb.
> > 
> > However, in the .PDF docs, it states "Warning: Use caution 
> > when using the
> > INFORMATION verb in BACKOUT and UPDATE procedures.".  Other 
> > than carefully
> > typing it in and experimenting with the NOW clause, what 
> exactly am I
> > supposed to use caution against?  A search on 
> > support.cognos.com didn't hit
> > any matches.
> > 
> > Anyone?
> > 
> > Rich Jesse                          System/Database Administrator
> > Rich.Jesse@qtiworld.com             QTI -- Sussex, WI USA


-----------------------------------------------------------------------

This message has been scanned for viruses with Trend Micro's Interscan VirusWall.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.