When my php executes the db2 insert, I get error 7008. Any ideas what I might try to get it working ? The PF is new with *all public authority and no trigger nor journal. I manually added 1 record via green-screen SQL with the same context as what is assembled in my php. Here’s [...]
Answer Question | March 19, 2013 9:20 PM
AS/400, DB2, PHP, SQL
We have a web service for placing orders and sending them to our iSeries. Basically front ending the EDI package on the iSeries. If the data is sent over without errors on the SQL insert to the DB2 databases the job runs. If there are run time errors during order processing the errors are logged [...]
Answer Question | March 20, 2013 7:59 PM
AS/400, DB2, iSeries, SQL 2008
If current ASP is 65% used from 10TB and if 1TB is removed from the rack how much ASP percentage would get increased? I said it is 75%. Can anyone improve this answer?
Answer Question | March 19, 2013 4:33 PM
AS/400, AS/400 ASP
Could anyone let me know what is an EVALR Opcode in AS/400? If possible, can anyone give me some sample code which is on EVALR Opcode?
Answer Question | March 19, 2013 9:16 AM
How can we remove the two years back data from our table? We don’t have any time stamp in a table. Please let me know the process to achieve it. Thanks, Ravula
Answer Question | March 19, 2013 7:48 AM
AS/400, AS/400 tables
How to get the saved object details from the backup tape, when the library which contains the objects is saved without object level details.
Answer Question | March 19, 2013 6:39 AM
BRMS, BRMS Backup
Has anyone every heard of ‘Roll your own Level Breaks’ in RPG? Can you enlighten me on how it works? I have to mimic a program that does this already with a different set of data. Here is a basic overview of the application. A selection screen allows you to select a date range, region, [...]
Answer Question | March 19, 2013 9:04 PM
AS/400, RPG, SQLRPGLE
Hi , I have one program which starts a job , I do ALCOBJ on a dataarea so that if the job is already running and someone tries to start the job again i can show the error that job is running ALCOBJ OBJ((&LIBLDTAQ/&DTAAA *DTAARA *EXCL)) WAIT(0) MONMSG MSGID(CPF1002) EXEC(DO) SNDPGMMSG MSG(‘Mikaodo Job Schedular is [...]
Answer Question | March 18, 2013 12:07 PM
Allocate Object, AS400 Command, Data Area
I have an object library and my source code is in object library and the files which are opened in output/update mode in the PGM are in my object library and the file which is opened in input mode is in another object library. Now I included two object libraries to my library list and [...]
Answer Question | March 18, 2013 11:50 AM
AS/400, AS/400 error messages
PGM DCLF FILE(AMITLIB/STUDPF) LOOP: RCVF RCDFMT(STUDRRC) MONMSG MSGID(CPF0864) EXEC(GOTO CMDLBL(END)) SNDUSRMSG MSG(&NAME) OPNQRYF FILE((AMITLIB/STUDPF)) QRYSLT(*ALL) GOTO CMDLBL(LOOP) END: ENDPGM it displays only the first data in the file. how to display all the records present in the file?
Answer Question | March 18, 2013 9:47 AM
CL programming, CLP
Hi, I have a logical file, which I am trying to open in I-O mode, but I get File status 90 File is existing on the system, The code was working fine previously (on development machine), but today I installed all the objects on another machine (Testing machine), and I am getting this file status, [...]
Answer Question | March 18, 2013 5:39 AM
While applying PTF’s SI38079 AND SI38080 for V7R1, it keeps coming back as not installed.
Answer Question | March 15, 2013 4:19 PM
How do I create report that show a list of users who are members of an AS/400 group profile?
Answer Question | March 15, 2013 4:01 PM
AS/400, AS/400 User Groups
Hi, there is a source library for me where I created a module and I binded it to a program with the command ‘CRTPGM’. Now I have created the object of that module in the object library. Now my question is how do I need to organize the library list when the things are as [...]
Answer Question | March 15, 2013 4:10 AM
AS/400, AS/400 Library
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