Re: ON-BREAK questions

[Krisjanis Gale <Krisjanis.Gale@NY.FRB.ORG>]

actually, i think you'll find
"SQR in PeopleSoft and Other Applications"
a VERY VERY good book.

i wasn't trained either.
i basically sat me arse down for a few days
and made some silly programs that did silly queries on the DB.
and then i got that book and i pretty much got
to know everything SQR can/cannot do in about a week.

(kris)janis p. gale
hrsd - federal reserve bank of new york
x8163

>>> Jennifer Wagner 301-827-5467 FAX 301-594-6463 <WAGNERJ@CDER.FDA.GOV> Monday, August 16, 1999 7:31:56 AM >>>
It's not like we've ever been trained.  They only have the users manual.
 They've been doing this for years and started training me.  They
weren't "trained" either.

BTW, we've ordered a copy of that SQR for Peoplesoft and other Apps, so
hopefully that will help us.

I'm basically learning by reading old SQR programs.  Not the greatest
way.  Does anyone know of other options for learning SQR?  Classes or
anything?  I've looked on the net, but can't find any classes offered in
it.

jenny



>That's pretty scary if the folks training you do that.  Perhaps you
need to find better trainers!!
>
>-----Original Message-----
>From: Jennifer Wagner 301-827-5467 FAX 301-594-6463
>[mailto:WAGNERJ@CDER.FDA.GOV] 
>Sent: Friday, 13 August 1999 10:51 PM
>To: Multiple recipients of list SQR-USERS
>Subject: Re: ON-BREAK questions
>Sensitivity: Confidential
>
>
>Hey, I'm still learning!  That is what the folks training me always do
>first...add distinct.  So, I assumed it was the thing to do.
>
>
>>Adding distinct without considering why is definately NOT a good rule
>of thumb!!
>>More often than not it indicates a problem with your query if you are
>getting duplicate rows where not expected.
>>
>>-----Original Message-----
>>From: Jennifer Wagner 301-827-5467 FAX 301-594-6463
>>[mailto:WAGNERJ@CDER.FDA.GOV] 
>>Sent: Friday, 13 August 1999 1:20 AM
>>To: Multiple recipients of list SQR-USERS
>>Subject: Re: ON-BREAK questions
>>Sensitivity: Confidential
>>
>>
>>Off the top of my head, the first thing I always do is add "distinct".
>>That's probably not it, but it's a good rule of thumb.  :)
>>
>>>Good morning, SQRUG!
>>>
>>>I inherited an SQR to which I had to add a date variable.  The output
>>is listing the date twice, and I'm sure it has something to do with
>>ON-BREAK.
>>>
>>>Here's what I have:
>>>
>>>begin-select
>>>Z_PROC_WE_DT        &Z_PROC_WE_DT2 () ON-BREAK Level=1
>>!This is the line I added
>>>Z_OFFICE_NBR        &NBR2       () ON-BREAK   Level=2 Print = Never
>>After = Print-Payroll
>>>Z_OFFICE_NBR        &OFFICE2
>>>Z_PR_PROC_STATUS    &STATUS2
>>>COUNT(*)            &COUNT2
>>>FROM [$PS_TABLE]
>>[$dyn_where]
>>>[$dyn_where_dt]
!I
>>added this dynamic statement
>>>GROUP BY  Z_OFFICE_NBR, Z_PR_PROC_STATUS, Z_PROC_WE_DT
>>>end-select
>>>
>>>The report output:
>>>
>>>WE Date      Office       Ignore           Ready         Error
>>Completed     Total
>>>
>>                 26-DEC-1997
>>>26-DEC-1997   C0021            0               0             0
>>     1          120-FEB-1998
>>>20-FEB-1998   C0024            0               0             0
>>     1          106-MAR-1998
>>>06-MAR-1998   M0222            0               0             0
>>     2          228-NOV-1997
>>>28-NOV-1997   M8017            0               0             0
>>     1          122-AUG-1997
>>>22-AUG-1997   S0029            0               0             0
>>     2          226-DEC-1997
>>>26-DEC-1997   S0029            0               0             0
>>     2          2
>>>
>>>              Table Totals     0               0             0
>>     9          9
>>>
>>>Why am I getting the dates twice? and why is the first occurence of
>the
>>date pushing into the total column? is this a problem with my ON-BREAK
>>logic, or column spacing, or.........?
>>>
>>>Thanks Much In Advance.
>>>
>>>~~ JEJ ~~   ;{)
>>>
>>>__________________________________________
>>>$14.95 a month Unlimited Internet Access.
>>>Get your first month for $1.00.
>>>http://www.surfree.com/promo