Re: [sqr-users] How can I tell which SQC is causing the error?

["Varsha Das" <vdas@mail.ucf.edu>]

You could also use -debug xyz and see if that works. If it's a
peoplesoft delivered SQC then you may find debug statements that list
the procedure / SQC that is being used.

Varsha.

>>> donm@ontko.com 3/16/2006 3:41:23 PM >>>
If you're on unix/linux you could do something like...

  grep -n '!=' *.sqc |grep ':1105:'

That would be the easiest way.

HTH,
Don

john.tucker@oracle.com wrote:
> I'm looking at an error log for an SQR that I just finished writing,
and it reminded me of a question that I've often had, but have never
found an answer to.  Partly, that's just because I'm not sure how to ask
Google...
>
> My error log says:
>
> Error on line 2796:
>       (SQR 5102) Out of Break commands; Use -Mfile to increase
BREAKS.
>
> Error on line 1105:
>      (SQR 4048) Function or operator '!=' must be a string or date
argument.
>
>
> I know where the first error is coming from, and how to solve it, but
I don't know where the second error is coming from.  I didn't use != in
any of the code I wrote, so I'm assuming at this point that it comes
from an SQC that I'm including but didn't write personally (I'm working
with an Oracle database on a PeopleSoft implementation).
>
> So my question to you all is this: is there a way to find out which
sqc has the line 1105 that's having an SQR 4048 error?
>
> -John T.
>
>
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org 
> http://www.sqrug.org/mailman/listinfo/sqr-users 
>
>   


-- 
-----------------------------------------------------------------------
Donald Mellen  | Ray Ontko & Co. - Richmond, IN - http://www.ontko.com/

donm@ontko.com |  "In the beginning, there was nothing, which
exploded"


_______________________________________________
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