Copying records
Hi, I need to copy file with records from one server to another server. For example, File1 from server1 has 1000records. I need to bring this to server2.

Answer Question   |  March 12, 2013  11:19 AM
AS/400, AS/400 Records

Lost my SQL log
SQL statements from a session (first session) have been lost because I opened a second SQL session and saved this when exiting AFTER exiting my first session. So, when I STRSQL, I only see the statements from my second session, those from the first session are gone. Can I somehow retrieve the statements from my [...]

Answer Question   |  March 12, 2013  9:23 AM
SQL Sessions, SQL statement

Communication link failure. A time-out occurred trying to connect to the iSeries Setup
I have a Linux ODBC that pushes data to the AS/400. When I am trying to connect my ODBC Linux connection, it fails and logs the following error message: [rduser@ebsdbprod ~]$ isql -v misysdb erp0101 [08S01][unixODBC][IBM][iSeries Access ODBC Driver]Communication link failure. comm rc=10060 – CWBCO1048 – A time-out occurred trying to connect to the iSeries [...]

Answer Question   |  March 12, 2013  8:59 AM
AS/400, Linux, ODBC

About programming in AS/400
I have a field in a file which is of alphanumeric type with a length of 15 and I’m going to store a string in that which is of 11 length and the string will be ‘CAS00TST01A’. Now I want to extract the letter which is at 11th position i:e ‘A’ and i want to [...]

Answer Question   |  March 11, 2013  4:15 AM
AS/400, AS/400 programming

WRKQRY Call LOADITMCL
When I run a WRKQRY for ITEMSQRY after I’m done query completes fine. I use Call LOADITMCL to load the WRKQRY but when I run call LOADITMCL application error. cee9901 unmonitored by LOADITMCL at statement 0000000600, instruction x’000. This does work in our production side but in test it doesn’t. I need it to be [...]

Answer Question   |  March 11, 2013  3:25 PM
AS/400, WRKQRY

Block Crystal Reports from iSeries access
We have a user who wants to use Crystal Reports to access data on an MS SQL server. She also has access to view limited data on the iSeries using an iSeries application with built-in security. How can we prevent her from accessing data on the iSeries using Crystal Reports. Is there a service we [...]

Answer Question   |  March 11, 2013  12:37 AM
Crystal Reports, iSeries

Write PF using RPGLE
HI … I tried to add a rec in my PF (sample1).. but my PGM run successfully .. but the rec haven’t added in my PF …. I shared my PGM here sample1 uf a e k disk usropn open sample1 eval empname=’Sathis’ eval empno=13 eval addr=’ramnad’ write rec close sample1 eval *inlr=*on Please help [...]

Answer Question   |  March 8, 2013  6:48 AM
RPGLE, RPGLE Program

Length of the entered value
Hi group, How to get the length of the entered value using WRKQRY? I am querying a file, the name field is defined as 15 characters. I need to get all those records whose name is greater than 10 Characters. Could anyone please help me how to write a query? Regards, M

Answer Question   |  March 8, 2013  3:37 AM
AS/400, AS/400 Query

Client Access
I have a Ricoh sp3500n connected to a PC running Client Access for AS/400. Font is wrong. How do I change it. I’ve tried change printer models in the AS/400 device description.

Answer Question   |  March 8, 2013  3:15 AM
AS/400, AS/400 Client Access

AS/400…How to batch purchase order entry from an EDI transmission
How can purchase orders received from an EDI transmission be ‘bulk entered’ from a CSV or Excel file into the AS/400?

Answer Question   |  March 8, 2013  10:05 PM
AS/400, EDI, EDI Transactions

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

AS/400 as career option
Please guide me “Is AS/400 the right option for career”. Can we get a job on this platform in 2013. I am currently in PUNE(INDIA).

Answer Question   |  March 7, 2013  9:17 AM
AS/400, AS/400 careers

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

Does anybody use FORMPLUS/400…kindly help me
I have a problem with FORMPLUS/400 tool. the OUTQ’s often stuck and I used to release it with using FPMAIN option 10. I used to reset the OUTQ’s using 7(end) and start with(6). But some times it won’t work. The OUTQ needs to reset every time to print the forms. I don’t have any documentation [...]

Answer Question   |  March 7, 2013  12:22 AM
AS/400, AS/400 print errors

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

AS/400 professional looking for job in USA
Hi All I have 5 yrs of exp in AS/400(RPG/400 & Cobol/400) & I’m looking for a job in USA as soon I’ll be getting married & don’t wany go on dependent Visa & be at home. I have an option of doing MS but after working for 5 yrs MS seems to be whole new start. [...]

Answer Question   |  March 6, 2013  12:14 PM
AS/400, AS/400 careers

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

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 6, 2013  12:56 AM
AS/400, WebSphere, Windows Server

Client Access, wide display
How do set AS/400 Client Access to display 128 positions on the screen? I have seen it before but I can’t find the setting.

Answer Question   |  March 5, 2013  7:17 PM
AS/400, Client Access

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