GEN DB question

 5 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
BrianM
Advanced Member Send Private Message
Posts: 41
Advanced Member

Merry Christmas everyone!  When adding a step to a job in jobdef there is a heading in the step definition called "Form ID".  I know that in that column you can put a Lawson program name or a user defined token which may simply call a script. 

I'm trying to write a query against the GEN DB that will display all of those script calls so they can be analyzed (specifically the directory paths where the script calls are mad).  For example, say I have defined a job and under Step 1 I enter a token that I have defined which is nothing more than a unix script.  If I press the F6 key, then "A" for Step Parameters, I see a screen that says "Add Form ID Command Parameters".  The entry there would be something like "/lawson/law/scripts/printchecks.ksh". For the life of me I cannot find which table in the GEN DB that information ("/lawson/law/scripts/printchecks.ksh") is kept.  Does anyone happen to know?  Thanks!

BTM
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
Brian: I do not believe that you will find that information anywhere in the database. From all of my digging around, the only place that information exists is in the PD files.
$LAWDIR/lprod/icsrc/GH105PD for example contains the lines
MOVE "/lawson/apps/lprod/script/IC527.ksh" TO
WS-CONVERT-SCRIPT.
CALL "SYSTEM" USING WS-CONVERT-SCRIPT.

That's the only place I have reference to that Unix script.
Greg Moeller
Veteran Member Send Private Message
Posts: 1498
Veteran Member
Unless...... You can find it in the EXECUTABLE table under the R_COMMAND column.. If you have your tokens set up that way.
BrianM
Advanced Member Send Private Message
Posts: 41
Advanced Member
Thanks for responding Greg!  Any idea where I'd find that information for a custom token? The example you give looks like it may be for a script call out of a program.  I sincerely appreciate you're "digging around".  Thanks
BTM
BrianM
Advanced Member Send Private Message
Posts: 41
Advanced Member
Aha!  The executable table is exactly what I was looking for.  Thank you so very much for your help!   Merry Christmas!
BTM
This_Guy
Veteran Member Send Private Message
Posts: 93
Veteran Member
You might try dumping/looking at the GEN, EXECUTABLE table. I have some ksh references to custom user tokens, and that's where mine are stored.