[sqr-users] Training question

["White . Denise" <DWhite@drc.com>]

Hi Laura,

You might want to check out the Library for this user group:
http://www.sqrug.org/ftp/  There are some utilities there that might be
of help, although I haven't tried any of them.  Maybe someone else here
has, and can comment on them.  There is one that will supposedly
reformat your code (and, from the examples we have seen, that is badly
needed!).  There is another that will generate documentation on the flow
and a cross-reference for the code.  I can tell you that the first thing
I do when I have to work with legacy code is to make a pass through it,
reformatting it into a style that is easier for me to work with.  The
code you have shown us is a mess - no standard indentations, multiple
lines of code on the same line, etc.  Possibly some of these utilities
can help you understand the code you have to work with.

On my PeopleSoft user group some years back, a group of us came up with
a set of coding standards for SQR.  They are here:
http://groups.yahoo.com/group/peoplesoft-fans/files/SQR/  If you are not
a member, you will probably have to create a Yahoo id and join the
group.  The standards are in SQR_style.zip.  This will help you write
code that is easier to maintain.  There are also some utilities that
might be useful, similar to in the SQRUG.  The SQR Tree utility is
there, which I know has been popular, although I have never used it
myself.

I have the Landres book, and it can be helpful, especially if you are
using SQR with PeopleSoft.  I use the standard SQR reference more,
however, as now that I can access it on the computer, it is more
convenient.  I just put a shortcut on my desktop to it.  If you are not
sure where it is, it should be at bin\sqr\ORA\BINW\cmdhlp.hlp on your
PS_HOME (file server).

Good luck,

Denise M. White
EBS Programmer/Analyst III
Dynamics Research Corporation
----------------------------------------------------------------------

Message: 1
Date: Mon, 24 Jul 2006 12:01:24 -0400
From: "Laura Mayer" <lmayer@gw.housing.umass.edu>
Subject: [sqr-users] Training question
To: <sqr-users@sqrug.org>
Message-ID: <s4c4b6a9.000@gw.housing.umass.edu>
Content-Type: text/plain; charset=US-ASCII

Does anyone know where I would be able to find some kind of training in
SQR coding? I feel like I'm drowning here. I've been working on this one
report for almost a month and am still not finished. 

I've only been able to find one book written on it and no tutorials out
there. 

I've looked online and can't seem to find any resources at all.

Thanks for any thoughts. 

Laura

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