How do I read genlib tables?

 6 Replies
 0 Subscribed to this topic
 18 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
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
Sure:
myVar=$(rngdbdump -cnt gen jobstep -f params | cut -c 1034-1048)
Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
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!