open() API on V6R1
For some reason, my RPGLE program can’t create an xml stream file on the new Power 6 (V6R1). I’ve tried using %trim(filename) and defining the file name as “varying” length. It works just fine on V5R4. I’d appreciate any ideas or suggestions.
Answer Question
| March 31, 2012 9:41 PM
AS/400, iSeries, Power6, QC2LE, RPGLE, V6R1
For some reason, my RPGLE program can’t create an xml stream file on the new Power 6 (V6R1). I’ve tried using %trim(filename) and defining the file name as “varying” length. It works just fine on V5R4. I’d appreciate any ideas or suggestions.
Answer Question
| March 31, 2012 9:41 PM
AS/400, iSeries, Power6, QC2LE, RPGLE, V6R1
Problem in updating a IFS file content..
Hi , i have a text file in IFS which have some data. Now after reading i want to replace all occurance of xyz with abc and update the ifs file .Everything is working fine except updation . The problem is with pointer setting , everytime the data is appended in file rather than replacing [...]
Answer Question
| March 31, 2012 3:41 PM
AS/400 file specification, IFS, IFS Commands, RPGLE
Hi , i have a text file in IFS which have some data. Now after reading i want to replace all occurance of xyz with abc and update the ifs file .Everything is working fine except updation . The problem is with pointer setting , everytime the data is appended in file rather than replacing [...]
Answer Question
| March 31, 2012 3:41 PM
AS/400 file specification, IFS, IFS Commands, RPGLE
Best way to allow web app to change ship-to address
Current pgm in RPGLE CGI works OK. I’d like to add option for user to change the existing ship-to address. I have the new “EDIT” button working in the existing display (of current ship-to) section of the html. I’m stuck on how to make the functionality work. Advice is always welcome, but an example would [...]
Answer Question
| March 31, 2012 4:22 PM
CGI, CGIDEV2, RPGLE, Web applications
Current pgm in RPGLE CGI works OK. I’d like to add option for user to change the existing ship-to address. I have the new “EDIT” button working in the existing display (of current ship-to) section of the html. I’m stuck on how to make the functionality work. Advice is always welcome, but an example would [...]
Answer Question
| March 31, 2012 4:22 PM
CGI, CGIDEV2, RPGLE, Web applications
MQ Read Message of 2 MG of as400
I need your help about it. I need read a queue of 2 MG in platform AS/400. The varables to receive the message exceeds 65535, the maximum allowable AS/400. I have worked with pointers but I an error 2004. Error reading buffer. The buffer has already been extended to the length of the expected variable. Thanks a lot
Answer Question
| March 31, 2012 5:40 PM
AS/400 administration, AS/400 queue, RPGLE
I need your help about it. I need read a queue of 2 MG in platform AS/400. The varables to receive the message exceeds 65535, the maximum allowable AS/400. I have worked with pointers but I an error 2004. Error reading buffer. The buffer has already been extended to the length of the expected variable. Thanks a lot
Answer Question
| March 31, 2012 5:40 PM
AS/400 administration, AS/400 queue, RPGLE
Subfile load all & expandable
Hi , i have some confusion beween load all & expandable subfile, for example in case of load all Pf has 100 records sfksiz=20 and sflpag =10 but if i am writing more then 20 records , but it should allow only 20 records in load all subfile because sflsiz=20 but its allowing to [...]
Answer Question
| March 31, 2012 1:12 PM
AS/400, AS/400 Subfiles, DDS, RPGLE, Subfiles
Hi , i have some confusion beween load all & expandable subfile, for example in case of load all Pf has 100 records sfksiz=20 and sflpag =10 but if i am writing more then 20 records , but it should allow only 20 records in load all subfile because sflsiz=20 but its allowing to [...]
Answer Question
| March 31, 2012 1:12 PM
AS/400, AS/400 Subfiles, DDS, RPGLE, Subfiles
Update Data SQL Server From AS400
Hi, some help me. I want to write data to SQL Server from AS400 in RPGLE. Some have code for make this. Thanks for advance.
Answer Question
| March 31, 2012 5:16 PM
AS/400 SQL, RPGLE, SQL Database, SQL Server
Hi, some help me. I want to write data to SQL Server from AS400 in RPGLE. Some have code for make this. Thanks for advance.
Answer Question
| March 31, 2012 5:16 PM
AS/400 SQL, RPGLE, SQL Database, SQL Server
Initiating a job when an as/400 database is updated
How can a job be initiated whenever a as/400 database is updated. We currently have a job that runs every hour even when there is no data to process. When there is data, it is processed then the database is cleared. Is there a way to trigger the job to run only whenever the database is populated?
Answer Question
| March 31, 2012 9:56 PM
AS/400 database, AS/400 jobs, iSeries, RPGLE
How can a job be initiated whenever a as/400 database is updated. We currently have a job that runs every hour even when there is no data to process. When there is data, it is processed then the database is cleared. Is there a way to trigger the job to run only whenever the database is populated?
Answer Question
| March 31, 2012 9:56 PM
AS/400 database, AS/400 jobs, iSeries, RPGLE
Dynamic Select
What is the purpose of DYNSLT (Dynamic Select) keyword?Why do we use Dynamic Select.?
Answer Question
| March 31, 2012 9:10 PM
AS/400, Dynamic Select in ABAP, DYNSLT, RPGLE
What is the purpose of DYNSLT (Dynamic Select) keyword?Why do we use Dynamic Select.?
Answer Question
| March 31, 2012 9:10 PM
AS/400, Dynamic Select in ABAP, DYNSLT, RPGLE
physicalfile records updation in subfile
i have created one subfile and records are also dsplayed ,but i want modify one record three times but i want second time modification record value ,so how to acess that record value? please give me example program and subfile desion.
Answer Question
| July 9, 2011 1:34 PM
AS/400, Physical File, RPGLE, Subfile
i have created one subfile and records are also dsplayed ,but i want modify one record three times but i want second time modification record value ,so how to acess that record value? please give me example program and subfile desion.
Answer Question
| July 9, 2011 1:34 PM
AS/400, Physical File, RPGLE, Subfile
RPGLE Getting around recursive calls
With proceedures I read that recursive calls are allowed. No time to get into proceedures. clp calls, pgm1. pgm1 add function displays scrn2, then calls pgm2, pgm2 calls pgm3, pgm3 calls pgm4. pgm1 update function calls pgm4. Issue is that pgm4 can call pgm1, pgm2, pgm3, pgm5, pgm6. On the call to pgm1 a recursive [...]
Answer Question
| June 24, 2011 6:12 PM
AS/400 Procedure Pointer, AS400 RPGLE, CLP, RPGLE
With proceedures I read that recursive calls are allowed. No time to get into proceedures. clp calls, pgm1. pgm1 add function displays scrn2, then calls pgm2, pgm2 calls pgm3, pgm3 calls pgm4. pgm1 update function calls pgm4. Issue is that pgm4 can call pgm1, pgm2, pgm3, pgm5, pgm6. On the call to pgm1 a recursive [...]
Answer Question
| June 24, 2011 6:12 PM
AS/400 Procedure Pointer, AS400 RPGLE, CLP, RPGLE
DBF in AS/400 – last record written
Hi , There is file which has 6 fields and the first four as its key. Is there any way to figure out which is the last record written into it. Thanks
Answer Question
| June 22, 2011 3:58 PM
AS/400, AS/400 Database File, Database Files, RPG, RPGLE
Hi , There is file which has 6 fields and the first four as its key. Is there any way to figure out which is the last record written into it. Thanks
Answer Question
| June 22, 2011 3:58 PM
AS/400, AS/400 Database File, Database Files, RPG, RPGLE
RPGLE Embedded SQL Not null
RPGLE Embedded SQL is getting a SQL0305 (SQLcid-305, sqlstate 22002) when fetching the next record from a view. This is pointing to null values encountered. /free exec sql fetch next from C1 into :wtclaims ; /end-free Wtclaims is an Externally Described Data structure. There could be null values in any field in the ds over [...]
Answer Question
| June 24, 2011 3:33 PM
AS/400, Embedded SQL, RPGLE, SQL
RPGLE Embedded SQL is getting a SQL0305 (SQLcid-305, sqlstate 22002) when fetching the next record from a view. This is pointing to null values encountered. /free exec sql fetch next from C1 into :wtclaims ; /end-free Wtclaims is an Externally Described Data structure. There could be null values in any field in the ds over [...]
Answer Question
| June 24, 2011 3:33 PM
AS/400, Embedded SQL, RPGLE, SQL
How to use API’s?
I’m trying to use the regular expressions API’s REGCOMP(), REGEXEC(), and REGFREE(). My text says handle them like a procedure, article seems missing info. Error examples are Prototyped call can’t be used in an expression because it doesn’t return a value, Types/Attributes of parm don’t match the prototype, Parameter can’t be passed by reference, etc. [...]
Answer Question
| June 20, 2011 6:46 PM
API, REGCOMP, REGEXEC, REGFREE, RPGLE
I’m trying to use the regular expressions API’s REGCOMP(), REGEXEC(), and REGFREE(). My text says handle them like a procedure, article seems missing info. Error examples are Prototyped call can’t be used in an expression because it doesn’t return a value, Types/Attributes of parm don’t match the prototype, Parameter can’t be passed by reference, etc. [...]
Answer Question
| June 20, 2011 6:46 PM
API, REGCOMP, REGEXEC, REGFREE, RPGLE
Default Font Name in AS/400
Hi All, Can Anyone tell me that which Font we use in As400, i mean default font nmae for As400. Thanks
Answer Question
| June 9, 2011 9:04 AM
AS/400, AS/400 fonts, AS/400 printing, CLLE, RPGLE
Hi All, Can Anyone tell me that which Font we use in As400, i mean default font nmae for As400. Thanks
Answer Question
| June 9, 2011 9:04 AM
AS/400, AS/400 fonts, AS/400 printing, CLLE, RPGLE
Disconnect from SSL Web session using RPGLE/CGI
I have searched high and low and cannot find a way to send a disconnect to the iSeries server using RPGLE/CGI. I have a secure application that works just fine. The initial login page will display and all is well. However, I would like to add a “LOGOUT” button to the web pages and have [...]
Answer Question
| May 31, 2011 8:43 PM
CGI, RPGLE, SSL, SSL bridging, V5R4
I have searched high and low and cannot find a way to send a disconnect to the iSeries server using RPGLE/CGI. I have a secure application that works just fine. The initial login page will display and all is well. However, I would like to add a “LOGOUT” button to the web pages and have [...]
Answer Question
| May 31, 2011 8:43 PM
CGI, RPGLE, SSL, SSL bridging, V5R4
Unicode on AS/400 RPGLE
We are upgrading to 9.0 JD Edwards where the unicode tables have CCSID = 13488; I still need them to work with legacy files, CCSID = 37. How can I get these 2 types of tables to interact within RPGLE (V6R1M0).
Answer Question
| May 20, 2011 8:23 PM
AS/400, CCSID, JDE, RPGLE, Unicode
We are upgrading to 9.0 JD Edwards where the unicode tables have CCSID = 13488; I still need them to work with legacy files, CCSID = 37. How can I get these 2 types of tables to interact within RPGLE (V6R1M0).
Answer Question
| May 20, 2011 8:23 PM
AS/400, CCSID, JDE, RPGLE, Unicode
CPF5032 member already locked to this job
I have a program written in RPGLE which calls numerous other programs. These programs all share similar files. In my main program, when trying to read a particular file, I get error CPF5032 even though I unlock the file right before I do the setll reade. As a result, I figured the lock must be [...]
Answer Question
| February 21, 2012 6:39 PM
*INLR, CPF5032, RPG, RPG ILE, RPG IV, RPG Programs, RPGILE, RPGLE, V5R4
I have a program written in RPGLE which calls numerous other programs. These programs all share similar files. In my main program, when trying to read a particular file, I get error CPF5032 even though I unlock the file right before I do the setll reade. As a result, I figured the lock must be [...]
Answer Question
| February 21, 2012 6:39 PM
*INLR, CPF5032, RPG, RPG ILE, RPG IV, RPG Programs, RPGILE, RPGLE, V5R4
Source name and location for RPGLE
I want to find out the source name and location for all objects within a library – The source types are RPGLE and CLLE. Kindof like we use the DSPOBJD for RPG sources. Thanks.
Answer Question
| May 2, 2011 8:38 AM
CLLE, DSPOBJD, RPG Source, RPGLE, Source Code Analysis
I want to find out the source name and location for all objects within a library – The source types are RPGLE and CLLE. Kindof like we use the DSPOBJD for RPG sources. Thanks.
Answer Question
| May 2, 2011 8:38 AM
CLLE, DSPOBJD, RPG Source, RPGLE, Source Code Analysis
Replace ” with ” in AS/400 string
Hi i have a string and want to replace all occurance of ” with “.Please let me know how can i accomplish this .
Answer Question
| May 2, 2011 6:18 PM
AS/400, As/400 Object, RPGLE, String name
Hi i have a string and want to replace all occurance of ” with “.Please let me know how can i accomplish this .
Answer Question
| May 2, 2011 6:18 PM
AS/400, As/400 Object, RPGLE, String name
Two window AS/400 subfiles problem
I have a DSPF with 2 subfiles defined as subfile windows. I need to display both of them.. I have got it to work with a full screen but no the wondow subfile. I get a error reading the first subfile. If I switch them around I get one then the other after I hit [...]
Answer Question
| April 1, 2011 3:02 PM
AS/400 Subfiles, AS400 RPGLE, DSPF, RPGLE
I have a DSPF with 2 subfiles defined as subfile windows. I need to display both of them.. I have got it to work with a full screen but no the wondow subfile. I get a error reading the first subfile. If I switch them around I get one then the other after I hit [...]
Answer Question
| April 1, 2011 3:02 PM
AS/400 Subfiles, AS400 RPGLE, DSPF, RPGLE
