Database Issues - Trying to prove that something has to be done
Hello Everyone, I'm currently trying to prove a concept on why we should re-create our old existing PFs into SQL defined tables (Portability, performance, etc.). After taking a look at some files, I noticed an even larger problem that would ruin my chance of proving this concept. Unless some...
Hello Everyone, I'm currently trying to prove a concept on why we should re-create our old existing PFs into SQL defined tables (Portability, performance, etc.). After taking a look at some files, I noticed an even larger problem that would ruin my chance of proving this concept. Unless some...
iSeries V5R3 downloading to Excel 2008
Are there compatibility issues using File Transfer from iSeries V5R3 to download data to Excel 2008?
Are there compatibility issues using File Transfer from iSeries V5R3 to download data to Excel 2008?
Authority to joblogs
How can I permit the programmers access to joblogs of users with a higher security?
How can I permit the programmers access to joblogs of users with a higher security?
iSeries on the Web - some pages HTTP, some HTTPS?
Warning: newbie to web programming and all the security implications... We are developing a small shopping website to be hosted on our iSeries. We will be purchasing an SSL certificate. Only some of our pages need to be encrypted (https). Most of the pages do not contain sensitive info, so do...
Warning: newbie to web programming and all the security implications... We are developing a small shopping website to be hosted on our iSeries. We will be purchasing an SSL certificate. Only some of our pages need to be encrypted (https). Most of the pages do not contain sensitive info, so do...
AS/400 - Object BCHLOG not found error
Hi All, This is related to MAPICS - Iseries env. I am tryin to debug the job in match mode in a TEST environment. As soon as i release the job , the following message comes "Object BCHLOG not found in *LIBL" and the service job ends in error. When i debug the same job in the LIVE enviroment, I...
Hi All, This is related to MAPICS - Iseries env. I am tryin to debug the job in match mode in a TEST environment. As soon as i release the job , the following message comes "Object BCHLOG not found in *LIBL" and the service job ends in error. When i debug the same job in the LIVE enviroment, I...
Writing directly ot iSeries optical drive
We are creating a file that is being copyied to the IFS using the cpytoimpf command. This is working fine. But the problem is that the file is for a State agency that is requiring that the file be sent on a CD for security instead of emal which would be our normal process. Is it prossible to...
We are creating a file that is being copyied to the IFS using the cpytoimpf command. This is working fine. But the problem is that the file is for a State agency that is requiring that the file be sent on a CD for security instead of emal which would be our normal process. Is it prossible to...
Crib sheet for F keys in Synon screen designer?
Does anyone have/know where I can get a crib sheet or instructions I can skim through for the Synon screen designer tool? I had one, but seem to have lost it. I only use this very occasionally, so my memory can be a little patchy...
Does anyone have/know where I can get a crib sheet or instructions I can skim through for the Synon screen designer tool? I had one, but seem to have lost it. I only use this very occasionally, so my memory can be a little patchy...
Security for Synon library lists?
I am having some problems locking down the library lists available to my developers. I'm sure previously, if they attempted to change their library list, using the synon library lists previously setup, and they were not authorised to one of the libraries in that list, it would fail. For some reason...
I am having some problems locking down the library lists available to my developers. I'm sure previously, if they attempted to change their library list, using the synon library lists previously setup, and they were not authorised to one of the libraries in that list, it would fail. For some reason...
Upgrading ODBC driver for iSeries
Im running iSeries Access for Windows V5R3. My current iSeries ODBC for Windows driver is v10. I would like to upgrade it to v11. Does anyone know how to do this without updating iSeries Access for Windows client on my pc? I need to leave it at V5R3.
Im running iSeries Access for Windows V5R3. My current iSeries ODBC for Windows driver is v10. I would like to upgrade it to v11. Does anyone know how to do this without updating iSeries Access for Windows client on my pc? I need to leave it at V5R3.
QYKMIMPK Usage
Sorry if this shows up more than once, first time poster and I'm a tad confused about how to get my question to appear under a specific category. I'm trying to use the iSeries QYKMIMPK api to import a certificate into the *SYSTEM certificate store and encountering error CFPB006, which appears to...
Sorry if this shows up more than once, first time poster and I'm a tad confused about how to get my question to appear under a specific category. I'm trying to use the iSeries QYKMIMPK api to import a certificate into the *SYSTEM certificate store and encountering error CFPB006, which appears to...
Problem printing a spoolfile using OVRPRTF using parms FrontOvl & Devtype(*afpds)
This is in an iseries 400 environment. I am using an Ovrprtf in an Qrpglesrc pgm. Another programmer originally set this up: OVRPRTF FILE(SHPADVPT ) FRONTOVL(DMSPRDOBJ/SHPADV) DEVTYPE(*AFPDS) HOLD(*NO ) SECURE(*YES) COPIES(2) OUTQ(PTSHPADV1 ) When the pgm runs, the print file resides in my...
This is in an iseries 400 environment. I am using an Ovrprtf in an Qrpglesrc pgm. Another programmer originally set this up: OVRPRTF FILE(SHPADVPT ) FRONTOVL(DMSPRDOBJ/SHPADV) DEVTYPE(*AFPDS) HOLD(*NO ) SECURE(*YES) COPIES(2) OUTQ(PTSHPADV1 ) When the pgm runs, the print file resides in my...
How i can display or print my CL commands
I everybody, i need print or display all commands that i have inside in my CL programs sources in QCLSRC? it is possible and how? thanks everybody.
I everybody, i need print or display all commands that i have inside in my CL programs sources in QCLSRC? it is possible and how? thanks everybody.
Mercurial on iSeries?
I've got an i515, running V5R4, with no PASE at all. Is there any way for me to create some programs that would allow me to store/backup my programs on a mercurial server? Just curious if anything exists (for free) like this.
I've got an i515, running V5R4, with no PASE at all. Is there any way for me to create some programs that would allow me to store/backup my programs on a mercurial server? Just curious if anything exists (for free) like this.
Java on iSeries
Can anyone suggest me the link to learn Java on i-series? I am an experienced AS/400 programmer with knowledge on Java.
Can anyone suggest me the link to learn Java on i-series? I am an experienced AS/400 programmer with knowledge on Java.
convert Double Precision number (8F)
How would I convert a Double Precision number (that is 8F). I am using a random number generator that return the random number in this field define as 8F. I need to have the result be move to a 5 character field for printing on a label.
How would I convert a Double Precision number (that is 8F). I am using a random number generator that return the random number in this field define as 8F. I need to have the result be move to a 5 character field for printing on a label.
Non-display fields in physical file
i want to create a PF in which i want to declare fields as non display.Can u help me out
i want to create a PF in which i want to declare fields as non display.Can u help me out
RPG vs Java vs Others
Hi, With the possibilities of using all sorts of C and Java type functions now available in RPG and bearing in mind that (in my experience) Java is difficult to tune to perform reasonably on the i-Series is there any benefit for an RPG programmer to learn Java? Or would some other language be a...
Hi, With the possibilities of using all sorts of C and Java type functions now available in RPG and bearing in mind that (in my experience) Java is difficult to tune to perform reasonably on the i-Series is there any benefit for an RPG programmer to learn Java? Or would some other language be a...
How to open file in different modes in RPG?
Hi, There have been a lot of changes in RPG over the last few years and I've lost track of many of these changes, so I have a question about file opens in RPG :- Is it possible to open a file for either input only or update without using overrides (and preferably without multiple F-specs)? The...
Hi, There have been a lot of changes in RPG over the last few years and I've lost track of many of these changes, so I have a question about file opens in RPG :- Is it possible to open a file for either input only or update without using overrides (and preferably without multiple F-specs)? The...


