Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Enterprise Resource Planning & Manufacturing
Lawson S3 Procurement
RQ300 update
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
NonnieBear1776
Past 24 Hours:
0
Prev. 24 Hours:
1
Overall:
5162
People Online:
Visitors:
229
Members:
0
Total:
229
Online Now:
New Topics
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1348
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson S3 Procurement
RQ300 update
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
ccBrian
New Member
Posts: 2
3/20/2013 9:43 PM
Does anyone know how Lawson labels the Creation Date Cutoff & Transaction Date Cutoff for the RQ300 jobs?
I need to update the job runtime with a Perl script and am doubting that I can just search for "Creation Date Cutoff" & "Transaction Date Cutoff"
Both Lawson and Perl are very very new to me, so forgive me if this question is redundant or rudimentary.
Any help is appreciated.
Thank you!
Greg Moeller
Veteran Member
Posts: 1498
3/21/2013 8:28 PM
I'm NOT an expert, but I can help you with a little of this.
Pull up RQ300 in Portal. Position your cursor in the field that you want to know about.
Hit Ctrl-Shift-O and the name of the field will be displayed in the status bar ... (lower left normally)
Usually, it has the 3-letter abbreviation for the table and then the field name... Your case does not.
I do that, and find the creation date cutoff field is called CREATION-DATE, but it doesn't indicate which table it is using.
The trans date cutoff is called TRANS-DATE, but again doesn't indicate which table it is using.
Milo Tsukroff
Veteran Member
Posts: 47
4/1/2013 2:10 PM
Greg:
[Warning: Technical stuff]
Ctrl-Shift-O lets you see the field definition from the .scr file, in this case RQ300.scr. A 3-character prefix is usually part of the field definition, but is done as a matter of convenience and convention, because it's not actually mapped. The actual mapping is done by COBOL procedural code inside the PD. In the case of RQ300, you would have to track down the usage of the fields CREATION-DATE and TRANS-DATE within RQ300PD to see what files they are associated with. Reading COBOL - I actually like it but most people would sooner [
gross analogy deleted
]
You are not authorized to post a reply.