I thought this might be handy tool to use. I had created for my use. I thought someone else might need it too.
This tools pickups any file and spits out "formatted" SQL (tables that begin with PS_ only) from it. I use it to run through my trace files and pick up the sql.
There are better tools out there, but this one is FREE! Cant beat that ah! I hope to make improvements as time permits. Feel free to pass it on.
| Attachment | Size |
|---|---|
| parser.jar | 4.89 KB |
| Title | Under | Posted on |
|---|---|---|
| how to create application status in peoplesoft campus solutions 8.9 version | PeopleSoft Functional | 05/17/2012 - 4:09am |
| horizantal text in charts | PeopleSoft Technical | 05/10/2012 - 4:57am |
| no current buffer context error | PeopleSoft Technical | 05/10/2012 - 1:19am |
| Integration Broker : Operating Instance/Pub Contracts/Sub Contracts | PeopleSoft Technical | 04/24/2012 - 11:05am |
Comments
Thanks rameshkrish, really appropriate sharing what you have with the us. I will have to try this at work next week. Please keep them coming :)
Note: I have updated the file to have the .jar extension. This will make it easier on users. Thanks again!
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog
How do I use this? :(
Its a runnable jar file. You need to have java runtime installed on your machine. Anyone else having similar issues ?
Just 1 question? in what scenario we can use.. what is the usage?
Cheers
Nitin
It helps you read your trace file "SQL" better. Thats all it does.
thanks you very much!
Post new comment