About AS/400
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
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
Add a new field in PF
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
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
External domain Vs Internal web server
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
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
User prompted for AS/400 log on when using Excel Add-in to upload data.
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
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
AS/400 / CF DESC
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
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
Adding values to second member of PF
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
