GEN DB question

 5 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
BrianM
Advanced Member
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
    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
      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
        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
          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
            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.