|
The UltraEdit text editor has some great features that make SQR development much more efficient. You can run the SQR's that you're editing directly from UltraEdit, you can add in the SQR Help file for context-sensitive help, and the Open from/Save To FTP helps you keep your UNIX code in sync with the file server version. Here's how it works:
Making SQR run from UltraEdit First, determine your SQR command line. It should be in this format:
<PS_HOME>\bin\sqr\ORA\binw\sqrw.exe <SQR_NAME> <DBUSERID>/<DBPWD>@<DBNAME> -zif<PS_HOME>\sqr\pssqr.ini -i<PS_HOME>\<PathToCustomSQRDirectory>;<PS_HOME>\sqr -oc:\temp\sqr.log -debugf
Where
<PS_HOME> is your high-level PeopleSoft Home directory
<SQR_NAME> is the full path to your SQR program
<DBUSERID> is the user ID you log on to the database with
<DBPWD> is the password you log on to the database with
<DBNAME> is the database name.
<PathToCustomSQRDirectory> is the path to the directory where we have custom and customized SQR's.
Command Line Flags:
The -i flag specifies which paths to search for include files. We want it to search the custom directory first, then the vanilla directory.
The -o path in this case specifies where to put SQR output messages from DISPLAY or SHOW statements. I usually put it in C:\Temp, but you can call it whatever you like.
The -debug directive allows debug messages to execute. DebugF usually means to execute program flow statements in most delivered SQR's, but you could use debug with any letter or letter combination.
The command line I use is:
C:\Apps\FDMO89\bin\sqr\ORA\binw\sqrw.exe C:\Apps\FDMO89\User\SQR\mycool.sqr bmartin/mysecretpwd@FDMO89 -zifC:\Apps\FDMO89\sqr\pssqr.ini -iC:\Apps\FDMO89\user\sqr;C:\Apps\FDMO89\sqr -oc:\temp\sqr.log -debugf
You can test your command line by running it in a command prompt. Try it before continuing.
Next, configure SQR in UltraEdit's Tools configuration so that you can launch SQR from UltraEdit to run the SQR you have open.
Click on Advanced > Tool Configuration
Use the command line you built in the first step, except replace <SQR_NAME> with %F to tell SQR to dynamically use the file you're editing. For example, I would use: C:\Apps\FDMO89\bin\sqr\ORA\binw\sqrw.exe %F bmartin/mysecretpwd@FDMO89 -zifC:\Apps\FDMO89\sqr\pssqr.ini -iC:\Apps\FDMO89\user\sqr;C:\Apps\FDMO89\sqr -oc:\temp\sqr.log -debugf
The working directory can be anything. I generally set it to C:\Temp.
I set the menu item name according to the environment I'm running in. For example: SQR FDMO89.
Click the Insert button.
Configuring SQR Context Sensitive HelpGo to Help > Add Help Files.
Help file should be your PS_HOME directory followed by \bin\sqr\ORA\BINW\cmdhlp.hlp
Menu item name should be SQR Help
Click the Insert button.
Now you can select the text of any SQR command, click Help > SQR Help, and see the help documentation for that command.
Using UltraEdit's FTP Commands Finally, set up your UNIX account so you can open and save files on UNIX:
Click File > FTP > Open from FTP
The FTP Open dialog box will appear. Click the Accounts button on the top right.
Click the New Account button.
Give your new account a name. I usually name it with the server name and the user name I'll log on to. For example: psdevbatch-bmartin.
Domain or IP Address would be the server name - i.e. psdevbatch.erpassociates.com.
Click the Close button, answer Yes to keep changes to existing account.
Now you can select your account in the drop-down list and click Browse Site. This will let you browse the UNIX system, and open and save files.
Comments () |
 |
|
|
|
 |
