A file is opened in a program in input mode and he turned the parameter ‘file addition’ to ‘A’. My doubt is, is it possible to add a record to the file thru the program when the file is opened in input mode?
Answer Question | March 15, 2013 4:00 AM
AS/400, AS/400 Records
Is it possible to add a new field in an existing PF without deleting the records that are present in it?
Answer Question | March 14, 2013 12:59 PM
Physical Files, RPG
Hi, One of my client like to integrate the external domain with internal web server. For example aaa.com [external domain] points towards internal web server aaa.local. Can someone guide me to achieve this in the minimal time frame? Thanks, Ajay
Answer Question | March 14, 2013 10:48 PM
External domain, Web Server
I have users that are uploading data to the AS/400 (V6R1) using the Excel Add-in. One user gets a log on pop up window each time she initiates the data transfer. Others in her same group do not. Where would I go to turn this off? She is logged on an AS/400 session and it [...]
Answer Question | March 13, 2013 7:29 PM
AS/400, IBM Client Access, iSeries Navigator, Microsoft Excel
Hello I am trying find a way to change the Customer Friendly Description in the SKU (SKN) DESC.
Answer Question | March 13, 2013 9:21 AM
AS/400, AS/400 database
Suppose I have a PF named ‘Member’ and I have added a new member ‘Mbr1′ to this pf. How can I add values to the second member(Mbr1)?
Answer Question | March 12, 2013 1:05 PM
RPG, RPG Program
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
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
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
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
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
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
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
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
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
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
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
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
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
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