Text Editors
To help with PeopleSoft development, you'll need a good text editor.
The common file types you'll need to work with include:
- PeopleCode (*.pcode is a common file extension used)
- SQRs and SQCs (*.sqr and *.sqc
- COBOLs and DMS (*.cbl and *.dms
You'll also need something to view things like:
- SQL scripts (*.sql)
- DMS scripts (*.dms)
- Log files (*.log)
- TraceSQL (.tracesql)
- Other output files
Some of the good text editors out there that support syntax highlighting for PeopleCode/SQR/COBOL include:
- PSPad (free)
- NotePad++ (free/open source)
- UltraEdit (commercial)
- TextPad (commercial)
- jEdit (free/open source)
- Crimson Editor (free)
There are also commerical programs for working with SQRs such as:
Once you've picked a text editor, use the following links to get it set up right for working with PeopleCode/SQR/COBOL:
PSPad
- PeopleSoft Wiki for PSPad PeopleCode and SQR syntax highlighting
- Supports COBOL syntax out of the box
NotePad++
- Grey Sparling for PeopleCode and SQR syntax highlighting
- NotePad++ site for COBOL syntax highlighting
- WorkingScripts for PeopleCode and SQR syntax highlighting
- Stock Enterprises for Running SQRs from NotePad++
UltraEdit
- Supports COBOL out of the box.
- UltraEdit Site for PeopleCode and SQR syntax files
- ERP Associates for Running SQRs from UltraEdit
TextPad
- Textpad Site for PeopleCode and SQR syntax files
- Textpad Site for COBOL syntax file
jEdit
- Supports SQR syntax out of the box
- Jim's PeopleSoft Journal for how to use jEdit and syntax files
Crimson Editor
- Supports SQR and COBOL syntax out of the box
- Not aware of any syntax files for PeopleCode?