SQL insert error in php
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
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
Getting DB2 data into SQL 2008 database
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
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
Disk percentage
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
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
About EVALR Opcode
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
AS/400, RPGLE
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
AS/400, RPGLE
AS/400
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 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
Recovering objects without object detail
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
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
RPG – Roll your own level breaks
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
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
ALCOBJ on a Data area
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
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
About AS/400
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
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
CLP Programming
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
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
File Status 90 during open
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
AS/400, COBOL
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
AS/400, COBOL
PTF on AS/400 not getting installed and applied
While applying PTF’s SI38079 AND SI38080 for V7R1, it keeps coming back as not installed.
Answer Question
| March 15, 2013 4:19 PM
AS/400, PTF
While applying PTF’s SI38079 AND SI38080 for V7R1, it keeps coming back as not installed.
Answer Question
| March 15, 2013 4:19 PM
AS/400, PTF
List of users who are members of a group profile
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
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
About library list in AS/400
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
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
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
