Can I override the record format name in a CLLE to be used in an RPGLE or can I qualify the record format name with a field value?
Hello All, I ran into a roadblock writing a new purge process for my company. Here’s the situation: I have 3 files that hold EDI Data that I need to purge: FILEA – Record Format FILEAR FILEB – Record Format FILEBR FILEC – Record Format FILECR All of the above files have the same record [...]
Answer Question
| February 21, 2013 11:48 PM
AS/400, CLLE, OVRDBF, RPGLE
Hello All, I ran into a roadblock writing a new purge process for my company. Here’s the situation: I have 3 files that hold EDI Data that I need to purge: FILEA – Record Format FILEAR FILEB – Record Format FILEBR FILEC – Record Format FILECR All of the above files have the same record [...]
Answer Question
| February 21, 2013 11:48 PM
AS/400, CLLE, OVRDBF, RPGLE
WRKPRB deleted logs
In our system the WRKPRB message will last for 30 days. Now I want to see the deleted WRKPRB logs. Is there anyway to find that logs?
Answer Question
| February 20, 2013 12:14 PM
AS/400, AS/400 administration, WRKPRB
In our system the WRKPRB message will last for 30 days. Now I want to see the deleted WRKPRB logs. Is there anyway to find that logs?
Answer Question
| February 20, 2013 12:14 PM
AS/400, AS/400 administration, WRKPRB
RPG date calculations
I need to add 28 days from the system date and output it into a file in the format mmddyyyy. I can not use free RPG or RPGLE. Could you help, please?
Answer Question
| February 20, 2013 8:45 PM
RPG, RPG Programs
I need to add 28 days from the system date and output it into a file in the format mmddyyyy. I can not use free RPG or RPGLE. Could you help, please?
Answer Question
| February 20, 2013 8:45 PM
RPG, RPG Programs
Parameter Passing: RPGLE to CMD to RPGLE
Hello, I have an RPGLE program that I am using to call a command with 1 parameter. The parameter is a container number, 11 positions alphanumeric. I want to be able to run my RPGLE program, execute the command via QCMDEXC and receive/process that parameter within the same RPGLE. Is this possible? How can I [...]
Answer Question
| February 19, 2013 2:51 PM
AS/400, CMD, RPG, RPGLE
Hello, I have an RPGLE program that I am using to call a command with 1 parameter. The parameter is a container number, 11 positions alphanumeric. I want to be able to run my RPGLE program, execute the command via QCMDEXC and receive/process that parameter within the same RPGLE. Is this possible? How can I [...]
Answer Question
| February 19, 2013 2:51 PM
AS/400, CMD, RPG, RPGLE
SQL message with no records selected
I have two user profiles, one will show data and the other does not when I do a simple Select * from myfile. I get a message, ‘Syntax check found no errors.’ I am *SECOFR on both profiles, library lists appear to be the same. Ideas anyone? Thanks in advance, Nick
Answer Question
| February 18, 2013 8:39 PM
AS/400, SQL message
I have two user profiles, one will show data and the other does not when I do a simple Select * from myfile. I get a message, ‘Syntax check found no errors.’ I am *SECOFR on both profiles, library lists appear to be the same. Ideas anyone? Thanks in advance, Nick
Answer Question
| February 18, 2013 8:39 PM
AS/400, SQL message
Three way replication on MIMIX
Hi, I have a question; we are planning to move our PR and DR to different location from existing one. Now on current location we have V5R4 and we are moving on V6R1 on new location where will have different network segment. We can’t keep down PR for more than 5-6 hrs. max. So what [...]
Answer Question
| February 18, 2013 8:20 PM
AS/400 v6r1, MIMIX
Hi, I have a question; we are planning to move our PR and DR to different location from existing one. Now on current location we have V5R4 and we are moving on V6R1 on new location where will have different network segment. We can’t keep down PR for more than 5-6 hrs. max. So what [...]
Answer Question
| February 18, 2013 8:20 PM
AS/400 v6r1, MIMIX
Execute from a source member list
I saw a colleague run something, and I know he built the user defined option (F16) “EX” in the WRKxxxPDM display, I don’t know the CMD/CL routine or Syntax for the source file/type. Thanks in advance! Dan
Answer Question
| February 18, 2013 12:58 PM
CL Program, CMD, syntax
I saw a colleague run something, and I know he built the user defined option (F16) “EX” in the WRKxxxPDM display, I don’t know the CMD/CL routine or Syntax for the source file/type. Thanks in advance! Dan
Answer Question
| February 18, 2013 12:58 PM
CL Program, CMD, syntax
PRT01 is in MSGW
When I check for the WRKCFGSTS, I am seeing this status: PRT01 * IPDS Offline or not yet available. Unable to vary on…
Answer Question
| February 18, 2013 12:55 PM
AS/400, AS/400 administration, WRKCFGSTS
When I check for the WRKCFGSTS, I am seeing this status: PRT01 * IPDS Offline or not yet available. Unable to vary on…
Answer Question
| February 18, 2013 12:55 PM
AS/400, AS/400 administration, WRKCFGSTS
BI product
We are using KBM software for our ERP system. We have a mandate to build a data warehouse so we can use a good BI tool to extract data. We would like to run this on our AS400. Does anyone have suggestions as to a good product for us to investigate?
Answer Question
| February 18, 2013 7:31 PM
AS/400, Business Intelligence, Data warehouse
We are using KBM software for our ERP system. We have a mandate to build a data warehouse so we can use a good BI tool to extract data. We would like to run this on our AS400. Does anyone have suggestions as to a good product for us to investigate?
Answer Question
| February 18, 2013 7:31 PM
AS/400, Business Intelligence, Data warehouse
LANSA: Calling a subroutine from def_break command
I have a function (I did not write it) that is calling a subroutine from def_break command and one field that is defined on the def_break command is not being cleared when break occurs. The last value of this field just repeats on the next break line. I ran this function under a debug and [...]
Answer Question
| February 18, 2013 7:14 PM
AS/400, LANSA
I have a function (I did not write it) that is calling a subroutine from def_break command and one field that is defined on the def_break command is not being cleared when break occurs. The last value of this field just repeats on the next break line. I ran this function under a debug and [...]
Answer Question
| February 18, 2013 7:14 PM
AS/400, LANSA
An OUTQ has been deleted from our system, unable to find even using dspjrne
We have an OUTQ which got deleted yesterday, however we tried checking thru DSPJRNE and other means as LOGs, however it doesn’t show up. The only thing which comes in the log is when the writer has ended. The obj deletion is not coming up.
Answer Question
| February 15, 2013 3:27 PM
AS/400, OUTQ
We have an OUTQ which got deleted yesterday, however we tried checking thru DSPJRNE and other means as LOGs, however it doesn’t show up. The only thing which comes in the log is when the writer has ended. The obj deletion is not coming up.
Answer Question
| February 15, 2013 3:27 PM
AS/400, OUTQ
FTP related
We have send a file to a particular location can we see the content what we have sent, since they are saying that file they received is not in correct format? (users are saying header and footer was missed,getting some error) but could see header and footer was there from our end to the file [...]
Answer Question
| February 15, 2013 9:58 AM
AS/400, AS/400 commands
We have send a file to a particular location can we see the content what we have sent, since they are saying that file they received is not in correct format? (users are saying header and footer was missed,getting some error) but could see header and footer was there from our end to the file [...]
Answer Question
| February 15, 2013 9:58 AM
AS/400, AS/400 commands
Running a script
I have a compliance requirement to convert all FTP jobs to SFTP. However SFTP does not work on Windows 2008 server the same way it works in Unix or AS400. In windows 2008 server, when you send a file via SFTP, it can only place it on local hard drive of that server. Currently, our [...]
Answer Question
| February 15, 2013 6:20 AM
AS/400, AS/400 administration, SFTP
I have a compliance requirement to convert all FTP jobs to SFTP. However SFTP does not work on Windows 2008 server the same way it works in Unix or AS400. In windows 2008 server, when you send a file via SFTP, it can only place it on local hard drive of that server. Currently, our [...]
Answer Question
| February 15, 2013 6:20 AM
AS/400, AS/400 administration, SFTP
RPGLE trigger tables AS/400
Hi, Does RPGLE triggers can be added to the tables? I created a Table and RPGLE Trigger. But I am getting error saying ‘Receiver too small to hold the result’. But the same code is accepting the physical files. Do I need to set any attributes while creating the RPGLE triggers or tables? Please suggest [...]
Answer Question
| February 15, 2013 5:13 AM
AS/400, RPGLE
Hi, Does RPGLE triggers can be added to the tables? I created a Table and RPGLE Trigger. But I am getting error saying ‘Receiver too small to hold the result’. But the same code is accepting the physical files. Do I need to set any attributes while creating the RPGLE triggers or tables? Please suggest [...]
Answer Question
| February 15, 2013 5:13 AM
AS/400, RPGLE
Debugging a Batch Job
Hi, I was debugging a COBOL/400 batch job. I am proceeding as per the below steps: 1. SBMJOB … HOLD(*YES) 2. STRSRVJOB JOB(jobnbr/user/jobnam) 3. STRDBG When source is displayed, press F12 4. RLSJOB JOB(jobnbr/user/jobnam) When Start Serviced Job display appears, press F10 5. When command entry display is shown, DSPMODSRC When source is displayed, set [...]
Answer Question
| February 15, 2013 2:44 AM
AS/400, COBOL/400 Debugging
Hi, I was debugging a COBOL/400 batch job. I am proceeding as per the below steps: 1. SBMJOB … HOLD(*YES) 2. STRSRVJOB JOB(jobnbr/user/jobnam) 3. STRDBG When source is displayed, press F12 4. RLSJOB JOB(jobnbr/user/jobnam) When Start Serviced Job display appears, press F10 5. When command entry display is shown, DSPMODSRC When source is displayed, set [...]
Answer Question
| February 15, 2013 2:44 AM
AS/400, COBOL/400 Debugging
SQLRPGLE
Please help. I am trying to execute the below code but the update doesn’t seems to be happening. DDATS E DS EXTNAME(PF1) C/EXEC SQL C+ DECLARE TESTC CURSOR FOR SELECT * FROM PF1 ORDER BY NUMBER C+ FOR UPDATE OF STATUS C/END-EXEC *OPEN the CURSOR C/EXEC SQL C+ OPEN TESTC C/END-EXEC C/EXEC SQL C+ FETCH [...]
Answer Question
| February 15, 2013 2:04 AM
AS/400, SQLRPGLE
Please help. I am trying to execute the below code but the update doesn’t seems to be happening. DDATS E DS EXTNAME(PF1) C/EXEC SQL C+ DECLARE TESTC CURSOR FOR SELECT * FROM PF1 ORDER BY NUMBER C+ FOR UPDATE OF STATUS C/END-EXEC *OPEN the CURSOR C/EXEC SQL C+ OPEN TESTC C/END-EXEC C/EXEC SQL C+ FETCH [...]
Answer Question
| February 15, 2013 2:04 AM
AS/400, SQLRPGLE
Example of Self-Join Logical File?
Does anybody have an example of Self-Join Logical File code?
Answer Question
| February 14, 2013 10:50 AM
AS/400, DB2 database
Does anybody have an example of Self-Join Logical File code?
Answer Question
| February 14, 2013 10:50 AM
AS/400, DB2 database
Connection String for AS/400
Hi all. Here I’m using iSeries Server. I just want to connect VB.NET with AS/400 database. Simply I want to retrieve some data from a PF on VB.NET. Anybody can you tell me what is the connection string should be used? If you have any simple sample code in VB.NET please post here… Surey
Answer Question
| February 14, 2013 8:29 AM
AS/400, AS/400 database, VB .NET
Hi all. Here I’m using iSeries Server. I just want to connect VB.NET with AS/400 database. Simply I want to retrieve some data from a PF on VB.NET. Anybody can you tell me what is the connection string should be used? If you have any simple sample code in VB.NET please post here… Surey
Answer Question
| February 14, 2013 8:29 AM
AS/400, AS/400 database, VB .NET
Uploading PTF file from local PC to AS/400
Hi, I do not have access to iSeries Navigtor to make this transfer. I need some ways to transfer a PTF from local PC to AS/400.
Answer Question
| February 13, 2013 4:21 PM
AS/400, iSeries Navigator, PTF
Hi, I do not have access to iSeries Navigtor to make this transfer. I need some ways to transfer a PTF from local PC to AS/400.
Answer Question
| February 13, 2013 4:21 PM
AS/400, iSeries Navigator, PTF
Program is expecting a file not used in this call
I have 2 different environments using 2 different library lists. A user takes an option from a menu and a CL program is called with overrides to a database file and then an interactive RPG program is called. The user then exits this program and then goes to the other environment (different libraries) and takes [...]
Answer Question
| February 13, 2013 3:45 PM
CL Program, CPF4101, RPG Program
I have 2 different environments using 2 different library lists. A user takes an option from a menu and a CL program is called with overrides to a database file and then an interactive RPG program is called. The user then exits this program and then goes to the other environment (different libraries) and takes [...]
Answer Question
| February 13, 2013 3:45 PM
CL Program, CPF4101, RPG Program
