JDE with Robot/Schedule

Hi All, Our new E1 interface to Robot seems to have created an issue where previous EDI react jobs are not finishing in the OS and so Robot Schedule continues to think they are still running. After looking at the job log for the hung job I noticed it only created a data queue in…



Answer Question   |  March 7, 2013  4:00 PM
iSeries, JDE
asked by:
11,410 pts.

Creating a PDF from a TIFF file!

I have a TIFF file in IFS directory and I want to crate a PDF from that TIFF file without any overlay (simple PDF). Please let me know if there is any way to create PDF without using any third party tools. Help is appreciated. I know we have some APIS and command provided with…



Answer Question   |  March 7, 2013  6:49 AM
AS/400, PDF
asked by:
420 pts.

ASCENTER scheduling question

Can a job be scheduled thru as/center to run on the 3rd BUSINESS day of the month and not just on the 3rd day of the month. If so, how?



Answer Question   |  March 6, 2013  4:26 PM
AS/400, AS/400 job scheduler
asked by:
11,410 pts.

Retriving the source code

Can we retrieve the source code of an RPGLE object? If yes, please let me the procedure for it. Thanks in advance ravua



Answer Question   |  March 6, 2013  8:30 AM
AS/400, AS/400 commands, RPGLE
asked by:
11,410 pts.

WebSphere in AS/400 or in Windows? Which is better?

I have project to upgrade in JDE 9.1, running using Citrix server and the database is sitting in AS/400 Server (V6.1). Some of the vendors recommend to use Windows Server for the HTML server and some to use open system. I’m wondering if the performance of the WebSphere in AS/400 is ok or not and what…



Answer Question   |  March 7, 2013  12:57 AM
AS/400, WebSphere, Windows Server
10 pts.

AS/400 Printer output

Is there a way to monitor the total number of reports being printed on an AS/400 with dates, user, pages, etc?



Answer Question   |  March 5, 2013  6:52 PM
AS/400
asked by:
20 pts.

Display the scheduler on iSeries system

How can I remove access to WRKJOBSCDE,CHGJOBSCDE, ADDJOBSCDE and leave a user with access to a browse command?



Answer Question   |  March 5, 2013  4:24 PM
AS/400, iSeries, iSeries Access
asked by:
15 pts.

DEWQ status jobs!

How can we kill the jobs those are in DEWQ status? Is there any system parameter in AS/400 using that we can kill those statuses jobs after a specific time frame automatically?



Answer Question   |  March 5, 2013  12:10 PM
AS/400, AS/400 jobs
asked by:
11,410 pts.

How to write a CL program if SQL query is giving some record

Hi, How can a CL program can be written based on some SQL query which gives some records. If SQL query is giving some records as output then using SNDEMLMSG command, how can that CL program be written? SNDEMLMSG command will send an email to specific user based on SQL query’s output if any thing…



Answer Question   |  March 4, 2013  2:08 PM
CL programs, SQL Query
asked by:
11,410 pts.

Replace failed disk

Hi guys, need your help once more. I need to replace a failed disk (RAID 5). I’m not shore how to do it, should I use navigator or DST? Need to stop RAID first? I already have the document with the steps to rebuild data on the new disk, just don’t know what to do…



Answer Question   |  March 1, 2013  1:16 PM
iSeries, RAID
asked by:
11,410 pts.

Twinax to LAN

Hi there experts, in need of your help once more. I have an old 800, which has been turned off a long time ago. Now, I can´t get to operations console because, I believe, the console configured is Twinax. How can I force the system to LAN console? Thank you very much.



Answer Question   |  March 1, 2013  1:04 PM
iSeries, LAN, twinax
asked by:
11,410 pts.

Using 2 different display sizes in a display file

I am trying to create a display file in which the subfile uses display size 27 132 and a window uses the display size of 24 80. I thought I could declare them both in the dspsiz as DSPSIZ(27 132 *DS4 – 24 80 *DS3) and use dspmod(*ds4) after the SFLPAG command and DSPMOD(*ds3) on…



Answer Question   |  March 1, 2013  2:24 AM
AS/400, RPG, RPGLE
asked by:
11,410 pts.

Constant variable in SQL cursor

select  gthamcode as hamcode, gtnumber as item, ‘G’ from testlib/gtinl01 where (gtnumber between 08000000000000 and 08999999999999) union all select modkey as hamcode, modndcnum as item, ‘M’ from testlib/hammodel where (modndcnum between 08000000000 and 08999999999)   This works with interactive SQL but I need to use this in an COBOL embbeded SQL cursor. The ’M’ and  ’G’ are constants…



Answer Question   |  February 28, 2013  7:23 PM
AS/400, SQL Cursors
asked by:
11,410 pts.

Synon related: Searching calling program in Synon (PRTFIL).

How can be search external program (outside Synon) which is calling print file function (PRTFIL). Actually, I know to search all function which are calling print file by the option 91 or take U at subfile selector or 95 at object usage screen but that approach can only work to identify internal function. Do you…



Answer Question   |  February 28, 2013  12:36 PM
AS/400 Synon, Synon
asked by:
11,410 pts.

Reading XML file from RPGLE program by using XML-INTO opcode

How can I move data from XML to Data structure if data is more than 9999 in XML? The problem is I can declare the data structure with array max size 9999 where as using XML-INTO (ex: XML-INTO OrderList %XML(‘/home/orderlist.xml’) : ‘ doc=file case=any’) ). I can load first 9999 set of data but then…



Answer Question   |  March 1, 2013  9:53 AM
AS/400, RPGLE, XML
asked by:
170 pts.

Creating physical files

What command would I use to create a physical file?



Answer Question   |  February 28, 2013  9:36 PM
AS/400, Physical File
asked by:
20 pts.

Printing from AS/400 to Canon iR3235

Hi, I am having problems printing from AS/400 running v5r4 to a Canon iR3235. Prints seem to be coming off out of order. But only happening half way through each batch of around 100 prints. The first half is fine, but then all comes off wrong. IBM have recommended setting up printer over LPR and using…



Answer Question   |  February 27, 2013  3:36 PM
AS/400, Canon
asked by:
5 pts.

Block access of Operational ASSIST Menu

Hi ! How can I block the users for the use of Operational Assistance Menu(Esc Key)?



Answer Question   |  February 27, 2013  6:03 AM
AS/400, AS/400 Menus
asked by:
11,410 pts.

About EVAL-CORR opcode

Could any one let me know what is the use of this EVAL-CORR opcode with a sample program



Answer Question   |  February 27, 2013  4:27 AM
AS/400, EVAL-CORR
asked by:
11,410 pts.

AS/400 – User Profile

Hi; What is the name of the file that stores the value for the “Password verification not valid” field on the User Profile. I created the User Profile file using the DSPUSRPRF command but it shows only a value. I need this information for auditing purpose. Thanks, Ruth.



Answer Question   |  February 26, 2013  4:27 PM
AS/400, AS/400 user profiles
asked by:
11,410 pts.