Search this forum:
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 6 of 6 << < 23456
 Last Post
3 Replies and 12088 Views Database / Tables  12088  3 Started by  Deleted User Hi, I need to capture the following data for all the employees a. Federal Marital Status b. Federal exemption c. Fedral Allowances d. State Marital Status e. State Exemption f. State Allowances g. Local Marital Status h. Local Exemption i. Local Allowances j. Federal Exemption Status We are using Lawson 9.0. Can anybody let me know from which database/tables these fields are defined. Thanks in Advance
3 12088
by  John HenleyJump to last post
10/10/2007 10:46 AM
3 Replies and 9948 Views LSF9 TDS etc  9948  3 Started by  Greg Moeller All: Recently we have moved to LSF9 from 803 env. Back in the 803 env I had developed a report in Crystal to get the user id's and group membership from LOGAN and added the supervisor code from the HRSUPER table. Now that LOGAN is no longer able to provide this information, I was wondering if there was a recommended way to get this information from TDS where it exists now Is there an ODBC connection, or native Oracle connection available to connect to TDS and if so, woul...
3 9948
by  John HenleyJump to last post
10/02/2007 3:14 PM
3 Replies and 11232 Views Add URL Button to Form  11232  3 Started by  L G Hi I would like to know if it is possible to add a button to a form like HR11 The functionality is similar to the one we use to launch other forms On click of the button it should open the URL (dynamic adding parameters like employee and company ) in IE Is this possible in LID using MF-COBOL The URL is not needed to be stored in the database Just that the URL will be built dynamically from within HR11 and on click of the button it will need to launch the built URL in IE ...
3 11232
by  L GJump to last post
10/02/2007 2:36 PM
1 Replies and 10638 Views Object Id - link between tables  10638  1 Started by  Deleted User GSC advised us to remove a row in pay rate hist table due to a bug. I noticed that this row had an object id with corresponding records in hrhistory and persacthst. Wouldn't I need to remove the corresponding rows in those other 2 tables also If yes, what could have happened if I did not remove them
1 10638
by  John HenleyJump to last post
08/30/2007 9:10 PM
6 Replies and 13003 Views SQL for finding counts of employees reporting under supervisor  13003  6 Started by  Shasidhar Vemireddy I am trying to develop a SQL logic that will fetch the counts of employees direct and indirect under supervisor across all levels in a company.I have hot wall with the PL/SQL logic. Can anyone tell me if such a logic was developed and how it was developed
6 13003
by  Shasidhar VemireddyJump to last post
08/20/2007 1:37 PM
6 Replies and 10726 Views Page Transfer Inconsistency  10726  6 Started by  jangins101 Hey, I'm having an issue with transferring pages. In using a Name Search (ZIAB) screen to find an applicant number, I transfer to another page (ZI31) using a speecific applicant, and (since it's a customized page), I only see the supplemental data, and the Lawson data fields are empty. After that, if I try to do any Inquiry on any applicant on the screen, I get a status bar message saying 'Value not in list:N,Y,X,1,2,3,4,5'. Any ideas on what that means or how to fix it (It also happens on Next...
6 10726
by  jangins101Jump to last post
08/20/2007 9:45 AM
11 Replies and 12849 Views Paint Program with page Up page down  12849  11 Started by  L G Could someone explain to me how to paint a program which has functionality similar to HR10 page up and page down to fetch records Even the relevant code sample in HR10 would suffice Thanks
11 12849
by  Sam SimpsonJump to last post
08/10/2007 10:35 AM
0 Replies and 10114 Views Default Advanced Search in RSS  10114  0 Started by  Todd I am looking to default our users to the 'advanced search' rather than the normal 'search' within RSS. Our users seem to expect the normal search to function more like the 'Word Finder' option under the advanced search. I tried changing the code within itemSearch.htm and itemSearch.js, but have not had any luck other than getting the advanced search to show up on the left side, but 'search' is defaulted. Thanks
0 10114
07/31/2007 11:58 AM
1 Replies and 11434 Views FIND-NEXT in 8.1.0  11434  1 Started by  Venkatarajamani Raman We are upgrading from Lawson 7.2.4 to 8.1.0. We have a custom on line program with 'N'ext, 'P'revious,'I'nquire, 'A'dd, 'C'hange and 'D'elete buttons. While clicking on 'N'ext button, the following error appears 'tsFindNxtDBRec error is File position not valid for nxt prv find 114 ' I have checked up the table and the index is there. I have checked up the table for records. There are 3 records available. Can someone help
1 11434
by  John HenleyJump to last post
07/06/2007 5:26 PM
1 Replies and 11938 Views Transaction Service Calls  11938  1 Started by  Deleted User Hi all - We just upgraded to LSF9 (9002) on HP-UX with 803 apps. Prior to the upgrade, we had Remote IOS installed on a Windows server, and made AGS calls to a form on the app server. Well, AGS has been replaced, and I have the URL down to make the transaction call successfully. However, we have to manually interact with the web login screen for authentication. Does anyone know how to bypass that or pass the credentials in the URL Thanks a ton in advance, Nicole
1 11938
by  John HenleyJump to last post
06/28/2007 4:46 PM
3 Replies and 10755 Views Scripts within cobol  10755  3 Started by  Sam Simpson We are in the process of testing 803 in an AIX environment. We are having a lot of issues but one particular cobol program that has been working in solaris it seems does not work in AIX. Here's the situation: We have a cobol program that has a call to a simple ksh script as the last statement. The cobol routines is working fine except the called script is not working at all(this is a simple rename and move). However, when you call the script thru LID it is working as it should. Is ther...
3 10755
by  John HenleyJump to last post
06/13/2007 5:15 PM
7 Replies and 13174 Views Create CSV from custom report  13174  7 Started by  Karl Kemp Has anyone ever ran into an issue similar to this, and if so what did you do I have created 2 or 3 'custom' reports. They run fine and generate the desired output. However, when I try to genereate <send to> a CSV file from the PRTMGR in LID, the CSV File selection is not 'selectable'. I'm thinking there might be a parameter within the report form that has to be set This action works fine in the standard Lawson apps, so it must be something that I have omitted. ...
7 13174
by  Karl KempJump to last post
06/01/2007 10:41 AM
3 Replies and 11366 Views 4GL, Fixed Length Record with Trailing spaces  11366  3 Started by  pvhmc Writing out a data file using 4GL. Each line in my file is fixed width of 750 characters. But the last populated field is at character 650. The remaining fields are populated with spaces. When I define the workfile to be TAPE, the line of my file ends at 650 (last non-space character). I need the file to place the carriage return-line feed at 750. Is there a pure 4GL way to accomplish this. (I am not going to be able to script this out on Unix after the fact.) I know I could make t...
3 11366
by  Sam SimpsonJump to last post
04/26/2007 3:24 PM
2 Replies and 10533 Views SQL server command to remove 2 from column  10533  2 Started by  Deleted User I tried update lawson.PRMONITOR set LP140_RUN_FLG = null but it does not allow nulls...we need to get prmonitor reset to take the 2 out of the column any ideas I was not about to do the pgmdef changes that gsc requested since I do not have c access.
2 10533
by  Deleted UserJump to last post
04/24/2007 4:42 PM
1 Replies and 10502 Views Running a Lawson Utility from a BAT File  10502  1 Started by  Deleted User Any ideas on how to run a Lawson utility from a windows batch file Thanks
1 10502
by  John HenleyJump to last post
04/11/2007 9:44 AM
1 Replies and 10618 Views PR160 Checks and Receipts layout  10618  1 Started by  Deleted User Is there any documentation available for the layout of checks and receipts printed by PR160
1 10618
by  John HenleyJump to last post
03/31/2007 4:59 PM
3 Replies and 10934 Views PR300 - edit out 18 month restriction  10934  3 Started by  Deleted User We need to purge recent payroll history used for our pre-go-live parallel testing and learned that the PR300 will only let you purge items over 18 months old. We were told that we could comment out this code. Does anyone have knowledge of how to do this and/or pros and cons of doing this (or things to be aware of). I'm not a COBOL programmer but can following basic instructions if anyone would be so kind as to assist. We are hoping to get rid of the test 's on our data so ...
3 10934
by  John HenleyJump to last post
03/30/2007 3:53 PM
1 Replies and 11199 Views On AGS call servlet error  11199  1 Started by  Asim I am not Lawson expert. But I am integrating Lawson process via AGS call. I am having following problem when I am posting following AGS call on servlet: Requested XML structure: <xml version='1.0' encoding='UTF-8'> <XXQII.1 xmlns:xsi=''> <XQII.1> <_PDL>BETA</_PDL> <_TKN>XQII.1</_TKN> <_OUT>XML</_OUT> <_TDS>IGNORE</_TDS> ...
1 11199
by  John HenleyJump to last post
03/22/2007 3:45 PM
4 Replies and 10968 Views Send email from Lawson Unix app to Outlook  10968  4 Started by  Karl Kemp Anyone ever put code in a Unix Cobol app to send an email notification to Outlook or Groupwise It seems like in a previous life I did this in a custom Lawson app, but now I can't find my notes on it. Any ideas
4 10968
by  Sam SimpsonJump to last post
03/19/2007 2:03 PM
1 Replies and 13579 Views Cobol EXAMINE statement  13579  1 Started by  Karl Kemp Has anyone ever used the Micro Focus COBOL Examine statement within Lawson I have used this in non-Lawson apps with success, but can't seem to get it to work in Lawson. Maybe you have other ideas. Here is what I am needing to do. I'm reading a file with records such as the following rec 1 = /lawson/work: rec 2 = /lawson/obj: I'm needing to determine where the ':' character is on each individual record. Thus I was going to use the EXAMINE TALLY...
1 13579
by  John HenleyJump to last post
03/15/2007 12:06 PM
4 Replies and 14054 Views iSeries RPG Lawson API calls  14054  4 Started by  Deleted User I've heard rumors of a conversion utility that will convert a Lawson Cobol program to a Lawson RPG program. Can anyone confirm or dispell this rumor I've heard it referred to as delmid. Does anyone have information or a link on what the names are for an RPG API routine and the corresponding Cobol API paragraph are within the Lawson environment Thanks in advance
4 14054
by  Scott KruegerJump to last post
02/21/2007 1:16 PM
7 Replies and 12693 Views AGS call via HTML  12693  7 Started by  Deleted User Hi, I'm working on a custom HTML page which extracts Invoices to be released for a Vendor Class based on user's login info. I get as far as DME query displaying all the unreleased Invoices. Upon selecting the desired Invoice, the following AGS call gets created but doesn't post. function AGSCall(vAuthCode, vVendor, vInvoice) { var o = new ActiveXObject('Microsoft.XMLHTTP'); var s = 'http://Servername:port/servlet/Router/Transaction/Erp_PDL=PDLname' ...
7 12693
by  John HenleyJump to last post
01/23/2007 4:12 PM
1 Replies and 10887 Views Tool to find out ladb changes?  10887  1 Started by  PV Rajan Hi: Over the past many years, we have been making some minor changes to lawson tables (7.2.4). Is there a tool to find out the differences we have made so far Thanks in advance!
1 10887
by  John HenleyJump to last post
12/15/2006 6:00 AM
0 Replies and 10733 Views Lawson Job Number  10733  0 Started by  Deleted User Job numbers used by Lawson as seen in files like QUEUEDJOB has 10 characters. It seems to be the combination of IBM job number followed by a sequence number. What is the significance of this sequence number and how is it generated
0 10733
12/08/2006 3:46 PM
2 Replies and 11605 Views Is there a way to call a Lawson batch program from another?  11605  2 Started by  Sam Simpson Almost related to this question, is there a way to call a Lawson batch program from another cobol program(custom). I tried INVOKE but this is only for online programs. I never have tried this before so my appreciation for any help.
2 11605
by  Sam SimpsonJump to last post
12/05/2006 1:20 PM
3 Replies and 11874 Views Access to PMTOUT  11874  3 Started by  Sam Simpson We are app 8.0.2x (unixlsolaris). In 7.0x and 8.0.3 PMTOUT is located in /<productLine>/work/PMTOUT/ but in 8.0.2x it is located in the root directory of work. This gives me a dilemna because the root directory of work is supposed to be for temporary files. I'm writing a cobol program to redo PMTOUT before check printing and the only way I can access this flat file is to call .ksh script(within cobol) to move the file to a different directory before opening it. Is there a way of dire...
3 11874
by  John HenleyJump to last post
12/05/2006 8:08 AM
0 Replies and 10886 Views Calling batch program interactively  10886  0 Started by  Deleted User I need to call a Lawson batch program PR530 interactively from a non-lawson program. I had initialized the lawson environment within the program and called the program with the entry parameters EENTRYCNTRL and EENTRYSCREEN populated. But the program ends abnormally on the UINITBATCH procedure with pointer not referenced error. What could be the reason for this
0 10886
12/04/2006 2:21 PM
1 Replies and 11303 Views Adding new system code  11303  1 Started by  Karl Kemp I'm trying to create a new SYSTEM CODE which we will then build our 'in house' applications under I got the new code created via GL01.4, and I can see it in the SYSTEMCODE table. I can also query it back up via GL01.4. However, when I go to PGMDEF to begin creating my new apps under this new System Code, I don't see it in the System Code drop-down list. I'm wondering if there is a security set-up someplace. I looked throughout LAUA but didn't see anything.
1 11303
by  John HenleyJump to last post
12/01/2006 2:15 PM
0 Replies and 11031 Views WinFax Pro Alternative?  11031  0 Started by  Roger French Looking at any alternatives to WinFax Pro with Fax Integrator. WFPro v10 isn't really supported by Symantec and Fax Integrator isn't certified with any other product which leaves us in a bit of a bind. We're looking at a product by Esker as a pooled-fax application. Has anyone built an interface between Lawson (fax integrator) and another supported fax application using API's or otherwise Thank you in advance, Roger French Houston,TX. Apps: 8.0.3....
0 11031
11/06/2006 8:11 AM
1 Replies and 10718 Views Format Issues  10718  1 Started by  Shasidhar Vemireddy I have a column that needs to be populated it is CHAR(17), i need to populate this fied with the EMPLOYEE number which is numeric (size 9). so when i try to move the value directly into the CHAR field the end result is something like this '000002456 '..however i want soemthing like this '2465 '.I tried various formatting options including lawson API's with no good result.Does anyone have a suggestion
1 10718
by  John HenleyJump to last post
10/23/2006 6:08 PM
8 Replies and 12711 Views .NET Web Authentication  12711  8 Started by  Deleted User I have a .NET web application that currently uses windows authentication. This grabs the current user off the machine. In some cases however it would be better for us to use Lawson's authentication. Basically the person logged into the machine may be logged into Lawson as a different user. Has anyone done this Thanks --JayR
8 12711
by  John HenleyJump to last post
08/11/2006 12:52 PM
1 Replies and 11549 Views How to access Lawson Job output from a Java program  11549  1 Started by  Deleted User Greetings, I am trying to determine the best way to access output from a Lawson Jobdef. It is a multistep job and I want a way that a Java program by having key information about the job user id , job name can automatically read the output files from the latest directory output for that job and process them to a .zip file for transport. Is there a series of system DB tables that contain the actual job output directory user id ,run number etc. for all platforms. I was thinking the ...
1 11549
by  John HenleyJump to last post
07/24/2006 10:18 AM
3 Replies and 12508 Views Getting a result from a CALL SYSTEM  12508  3 Started by  Leon Feder I know how to call a system command from a COBOL program (Thanks, your article is great) but how can I use the results I would like to get the result code and also look at the redirected output of the command.
3 12508
by  Leon FederJump to last post
06/22/2006 2:19 PM
3 Replies and 11638 Views Changing field sizes in apvenmast  11638  3 Started by  Deleted User How big a deal is it to change field sizes in apvenmast for addr1,2,3,4 from 30 to 40 and city from 18 to 19 I have used dbdef to setup some custom views and tables before(SQL server). I also assume I would need to recompile everything.
3 11638
by  John HenleyJump to last post
05/22/2006 5:11 PM
2 Replies and 12039 Views Batch program for FTP  12039  2 Started by  Deleted User We do not have unix command line access so we are struck with users using winptxfr program between Lawson and windows. Some use wsftp but I would like to write a program which invokes unix ftp commands. Does anyone have a readymade program which can I can use Thanks
2 12039
by  Phillip FellerJump to last post
04/27/2006 10:47 PM
0 Replies and 10984 Views IBM Rational Clear Case with Lawson  10984  0 Started by  John Henley I'm looking for any organizations who have used Clear Case for managing their Lawson customizations.
0 10984
04/24/2006 4:20 PM
3 Replies and 11289 Views A batch program replicating PR23 edit checks  11289  3 Started by  Deleted User We hav been asked by the users to create a batch program which should delete all records in EMPDISTMAST table (updated by PR23), takes an input file from another system and do the same edit checks as PR23 and then populate the table. In their words, it should invoke the same AGS/DME calls that PR23 uses. What is the fastest way to do that Note: I will be learning Lawson programming as I do that. Thanks
3 11289
by  John HenleyJump to last post
04/14/2006 9:23 PM
To join the discussion you need to register first. (Registration is free!) If you are already a registered user please login to join the discussion.
Page 6 of 6 << < 23456

RSS Feed Available