PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 12/09/2016 2:13 PM by  John Henley
Has anyone successfully parsed out job parameters from the GEN(LAW).JOBSTEP table?
 7 Replies
Sort:
You are not authorized to post a reply.
Page 1 of 212 > >>
Author Messages
b.svr
Programmer Analyst II
Private
New Member
(8 points)
New Member
Posts:4


Send Message:

--
12/08/2016 3:21 PM

    It seems like this is one jumbled text field that isn't very readable. Has anyone come up with a good way to parse this out for something more readable?

     

    Thank you,

    Karen Sheridan
    Private
    Private
    Veteran Member
    (325 points)
    Veteran Member
    Posts:123


    Send Message:

    --
    12/08/2016 3:26 PM
    Depending on what you are trying to do, have you looked at the output from jobdump?
    John Henley
    Private
    Private
    Senior Member
    (9692 points)
    Senior Member
    Posts:3248


    Send Message:

    --
    12/08/2016 3:38 PM
    Can you describe more about what you're trying to accomplish?, and what tools (i.e. are you trying to use SQL to parse?)?
    Thanks for using the LawsonGuru.com forums!
    John
    Todd Mitchell
    Senior IT Specialist
    Gordon Food Service
    Veteran Member
    (185 points)
    Veteran Member
    Posts:79


    Send Message:

    --
    12/09/2016 6:16 AM

    I have used both sql and perl to access and update the job parameters.

    b.svr
    Programmer Analyst II
    Private
    New Member
    (8 points)
    New Member
    Posts:4


    Send Message:

    --
    12/09/2016 10:06 AM
    We are attempting to create a readable report that reports detailed information from the table.

    I'm using SQL for this purpose. The job information up to the parameters are fine -- this field is just one big text blob. We are trying to make it more readable and usable.

    For example, if we wanted to report on a multi step requisition import job we would like the following information to be able to be reported on:
    based on
    Job Name, Program, Parameter
    IMPORTJOB,RQ500, Import File: File.txt
    IMPORTJOB, PO100, Buyer: SS
    IMPORTJOB, PO100, Combine PO Lines: N
    IMPORTJOB, PO100, Release Purchase Orders: Y
    etc.

    Is this something that could be accomplished by only using SQL?
    You are not authorized to post a reply.
    Page 1 of 212 > >>