RE: [sqr-users] apology

[Bob Stone <bstone@fastenal.com>]

Soumya,

I agree with Peter.  Show and display both write to the SQR log file, so it
sounds like you just need to find the right log file (not to be confused
with the trace file).  Your debugging hints should be in there.

I also agree with him as far as this forum is concerned.  This shouldn't be
used for rather rudimentary questions.  It should be more complex problems
that an SQR manual probably wouldn't answer.  Or, having tried the manuals
extensively, someone asks a question that they cant find an answer to.
Maybe it's because they're looking for the wrong words in the manual,
there's an error they've never seen before, or it's just something not
covered.  Sometimes it's an entire logic-processing error (they're going
about a problem bass-ackwards).  That's what I see as the use for this
forum.  Nobody likes to spend the time explaining how to move a string to a
number, how to write to a file, or how unstring and to_char work.  Most
people spend a decent amount of time on a problem before turning to the
forum, out of respect for all the people who might take their time to answer
the questions/problems.  

If you're relatively new to SQR, I agree with 'the dragon', you should look
into getting a manual or SQR reference.  I have a few places I look
(including the archives of this sqr-user group) before actually sending out
an email.  

Thanks.

Bob Stone

-----Original Message-----
From: sqr-users-bounces+bstone=fastenal.com@sqrug.org
[mailto:sqr-users-bounces+bstone=fastenal.com@sqrug.org]On Behalf Of
PeterG Clark
Sent: Friday, February 25, 2005 6:42 AM
To: sqr-users@sqrug.org
Subject: Re: [sqr-users] apology


Soumya,

You seem to be confusing the "SQR" Log file (sqr.log) with a
"PeopleSoft" log file. The show and display commands write to the SQR
log file (which is the one and only "SQR log file"). If you wish to
write to a PeopleSoft log file(?) (are you referring to PSPRCSRQST?),
you would do so in the same way you would write to any other file/table
(Write or Insert).

I disagree with your comment about the need for this forum. Often one
encounters situations or questions that are not covered in a manual and
one then uses this forum to draw upon the experience of others in
resolving the situation or answering the question (why re-invent the
wheel?).

Everyone should at least attempt to use the manuals first. At least it
would give you the understanding that SQR and PeopleSoft are two
seperate and distinct software entities and that in the SQR world, "log
file" refers to "sqr.log" (which is used to log the outputs of Display
and Show commands).



>>> Soumya.Sankaran@blr.hexaware.com 2005/02/25 05:49:37 >>>
If we all were to use manuals we wouldnt need such a forum..

Anyways, I wanted to know how to write to an SQR log file not trace
file.

Show and display can of course be used to write to a trace file. Is it

possible to write onto the log file which the process scheduler uses? 

Just a tht.. 
 



"the dragon" <ceprn@hotmail.com> 
Sent by: sqr-users-bounces+soumya.sankaran=blr.hexaware.com@sqrug.org 
24-02-2005 08:43 PM
Please respond to
"This list is for discussion about the SQR database reporting  
language 
from Hyperion Solutions." <sqr-users@sqrug.org>


To
sqr-users@sqrug.org 
cc

Subject
[sqr-users] apology







All,

This morning I posted a suggestion which, due to the earliness of the 
morning, may be construed to be a bit harsher than I intended.  It
wasn't 
my 
intention to embarrass or put down anyone; I was just offering a 
suggestion, 
since sometimes it's faster to have a printed resource available rather

than 
having to wait for the group.

Pklease accept the apology.

peace,
clark 'the dragon' willis


PSA: Salary <> Slavery. If you earn a salary, your employer is renting

your 
services for 40 hours a week, not purchasing your soul. Your time is
the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

I work to live; I don't live to work.

"Time is the coin of your life. It is the only coin you have, and only
you 

can determine how it will be spent. Be careful lest you let other
people 
spend it for you."

Carl Sandburg
(1878 - 1967)



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users