How do I read genlib tables?

 6 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
Donna Wirt
Basic Member
Posts: 17
Basic Member
    I'm trying to read the genlib/JOBSTEP table to get a parameter value to use in a custom lawson program and a shell script.  Any help is greatly appreciated.  Thanks.
    Greg Moeller
    Veteran Member
    Posts: 1498
    Veteran Member
      I use rngdbdump command... Set your lawson environment variables in your script or just include this line...
      eval `/usr/bin/cvx -b lawprod`

      Where lawprod is your Lawson enviornment name..

      Then, to get the field names:
      rngdbdump -ct gen jobstep | head -1

      Then to extract the field, you don't need headers, so use the n switch
      rngdbdump -cnt gen jobstep -f jobname description -v jobname=your_value

      This will extract just the jobname and description fields from the jobstep table where jobname=your_value
      Greg Moeller
      Veteran Member
      Posts: 1498
      Veteran Member
        Or better yet: Assign something to a variable like this:
        myVar=$(rngdbdump -cnt gen queuedjob -f status -v jobname=${JOB}|grep "${DATE}")
        Donna Wirt
        Basic Member
        Posts: 17
        Basic Member
          Is there a way using rngdbdump to say I want the value in the PARAMS field starting in position 1034 for 15 positions?
          Greg Moeller
          Veteran Member
          Posts: 1498
          Veteran Member
            Sure:
            myVar=$(rngdbdump -cnt gen jobstep -f params | cut -c 1034-1048)
            Greg Moeller
            Veteran Member
            Posts: 1498
            Veteran Member
              I should have had your jobname in the command somewhere...
              myVar=$(rngdbdump -cnt gen jobstep -f params | grep YourJob | cut -c 1034-1048)
              Donna Wirt
              Basic Member
              Posts: 17
              Basic Member
                Greg, thank you for all of the great suggestions!  Big help!