How can I make sure all new and changed objects are being backed up when using the SAVCHGOBJ command?
Our current backup procedures include a full system save once a week (SAT) and two daily save change object processes (M-F). Yesterday a new library added on Monday was deleted by accident. When trying to restore it from one of the daily tape backups which was done using the SAVCHGOBJ command it was discovered that [...]
Answer Question
| June 14, 2013 2:39 PM
AS/400, AS/400 backup, SAVCHGOBJ
Our current backup procedures include a full system save once a week (SAT) and two daily save change object processes (M-F). Yesterday a new library added on Monday was deleted by accident. When trying to restore it from one of the daily tape backups which was done using the SAVCHGOBJ command it was discovered that [...]
Answer Question
| June 14, 2013 2:39 PM
AS/400, AS/400 backup, SAVCHGOBJ
QMQRY!
How can we run multiple select/update query via a single QMQRY?
Answer Question
| June 14, 2013 11:11 AM
AS/400, AS/400 Query, QMQRY
How can we run multiple select/update query via a single QMQRY?
Answer Question
| June 14, 2013 11:11 AM
AS/400, AS/400 Query, QMQRY
Why did the system crash?
Forgive me if this is hard to read but editor looks messed up again (tried using all 3 browsers). At a loss here. We had a user working remotely through a VPN last night. Around 19:00 last night they lost the connection running a query and did not try logging back on. At 19:17 I [...]
Answer Question
| June 13, 2013 7:17 PM
AS/400, PTF
Forgive me if this is hard to read but editor looks messed up again (tried using all 3 browsers). At a loss here. We had a user working remotely through a VPN last night. Around 19:00 last night they lost the connection running a query and did not try logging back on. At 19:17 I [...]
Answer Question
| June 13, 2013 7:17 PM
AS/400, PTF
AS/400 backup
We built a new system with 3 LPARs with IBM i 7.1 . We setup the BRMS & using image catalog ,we created the virtual volume and scheduled the backups. Backups are performing perfect in virtual volumes also we can make a dupe tape using the physical media. My question is we have data of [...]
Answer Question
| June 13, 2013 1:33 PM
AS/400 Administrator, AS/400 backup, AS/400 BRMS
We built a new system with 3 LPARs with IBM i 7.1 . We setup the BRMS & using image catalog ,we created the virtual volume and scheduled the backups. Backups are performing perfect in virtual volumes also we can make a dupe tape using the physical media. My question is we have data of [...]
Answer Question
| June 13, 2013 1:33 PM
AS/400 Administrator, AS/400 backup, AS/400 BRMS
How can I find the backup detials when I don’t have BRMS
I have system which had backup recently. I am unaware of the job name also we don’t have BRMS on the system, is there any possibility that I can find the job name or work with logs?
Answer Question
| June 13, 2013 7:18 AM
AS/400, AS/400 administration, AS/400 Administrator
I have system which had backup recently. I am unaware of the job name also we don’t have BRMS on the system, is there any possibility that I can find the job name or work with logs?
Answer Question
| June 13, 2013 7:18 AM
AS/400, AS/400 administration, AS/400 Administrator
AS/400
yes, i am looking to start new it company.I am planing to work on AS/400 platform and related projects in my new company.For this,I am looking to purchase small as/400 server. For this question,Please give me some details like as/400 server(small one)cost,other details.
Answer Question
| June 12, 2013 2:10 PM
AS/400, AS/400 administration, AS/400 Server
yes, i am looking to start new it company.I am planing to work on AS/400 platform and related projects in my new company.For this,I am looking to purchase small as/400 server. For this question,Please give me some details like as/400 server(small one)cost,other details.
Answer Question
| June 12, 2013 2:10 PM
AS/400, AS/400 administration, AS/400 Server
How to clear credit balance off a purchase ledger account?
How do you clear credit balances off a purchase ledger account in BPCS AS/400 version 8.3, we have tried to clear off as a negative payment and through other ways but apparently BPCS won’t allow a minus payment to go through so if there is a negative balance on an account and the account is [...]
Answer Question
| June 11, 2013 2:54 PM
BPCS, BPCS 8.3
How do you clear credit balances off a purchase ledger account in BPCS AS/400 version 8.3, we have tried to clear off as a negative payment and through other ways but apparently BPCS won’t allow a minus payment to go through so if there is a negative balance on an account and the account is [...]
Answer Question
| June 11, 2013 2:54 PM
BPCS, BPCS 8.3
AS/400 server built
How to built AS/400 Box & Basic requirements needed? Hardware and software etc.
Answer Question
| June 11, 2013 12:07 PM
AS/400, AS/400 Server
How to built AS/400 Box & Basic requirements needed? Hardware and software etc.
Answer Question
| June 11, 2013 12:07 PM
AS/400, AS/400 Server
Server lifting
Some of the new DC servers we just got in are quite heavy, and loading them into the rack is becoming a pain, literally. I’ve seen some lifts online, but they all seem to be general warehouse lifts. Anyone know of something better?
Answer Question
| June 11, 2013 12:00 PM
DC Server, Server
Some of the new DC servers we just got in are quite heavy, and loading them into the rack is becoming a pain, literally. I’ve seen some lifts online, but they all seem to be general warehouse lifts. Anyone know of something better?
Answer Question
| June 11, 2013 12:00 PM
DC Server, Server
Compile Program for previous system level
Hi, My system is on IBM i V7R1. I have a SQL procedure on AS/400 created using “CREATE PROCEDURE” command on SQL400 command prompt. By default resultant Program object is created with CLE attribute & for System Level V7R1M0. I want to compile this program for System Level V6R1M1. How to do this as source [...]
Answer Question
| June 10, 2013 2:00 PM
AS/400 and SQL, IBM i, SQL procedure
Hi, My system is on IBM i V7R1. I have a SQL procedure on AS/400 created using “CREATE PROCEDURE” command on SQL400 command prompt. By default resultant Program object is created with CLE attribute & for System Level V7R1M0. I want to compile this program for System Level V6R1M1. How to do this as source [...]
Answer Question
| June 10, 2013 2:00 PM
AS/400 and SQL, IBM i, SQL procedure
Test of running programs
Before starting RPG program (PROGA) I need to check if the other given programs are running (for instance PROGB and PROGC). (PROGB, PROGC could be start in interactive or batch jobs by different users.) Can you let me know how to do it ? Thanks a lot.
Answer Question
| June 7, 2013 2:56 PM
AS/400 jobs
Before starting RPG program (PROGA) I need to check if the other given programs are running (for instance PROGB and PROGC). (PROGB, PROGC could be start in interactive or batch jobs by different users.) Can you let me know how to do it ? Thanks a lot.
Answer Question
| June 7, 2013 2:56 PM
AS/400 jobs
SQLRPGLE
Variable not found when calling a SQLRPGLE program with parameters in CL program CALL PGM(LIBXYZ/TESTRPG1) PARM(&LIBNAM &FILNAM) here LIBNAM AD FILNAM are passed with VALUES to the SQLRPGLE program and at sql statemet ie. insert INTO LIB/FILl( LIB is having the value and FILL is not getting value, throwing as variable not found.
Answer Question
| June 7, 2013 12:52 PM
AS400 - Embedded SQL, CL Program, SQLRPGLE
Variable not found when calling a SQLRPGLE program with parameters in CL program CALL PGM(LIBXYZ/TESTRPG1) PARM(&LIBNAM &FILNAM) here LIBNAM AD FILNAM are passed with VALUES to the SQLRPGLE program and at sql statemet ie. insert INTO LIB/FILl( LIB is having the value and FILL is not getting value, throwing as variable not found.
Answer Question
| June 7, 2013 12:52 PM
AS400 - Embedded SQL, CL Program, SQLRPGLE
About files
I have a physical file and a logical file, on that physical file in a library and now I want to copy the object of that physical and logical file to another library. I copied the object of the physical file to another library which happened good but when I am copying the object of [...]
Answer Question
| June 7, 2013 9:57 AM
AS/400, Logical File, Physical File
I have a physical file and a logical file, on that physical file in a library and now I want to copy the object of that physical and logical file to another library. I copied the object of the physical file to another library which happened good but when I am copying the object of [...]
Answer Question
| June 7, 2013 9:57 AM
AS/400, Logical File, Physical File
AS/400 – SQL
I am reading a record in SQL with No Lock and its getting displayed in Screen. Based on the user input, I will/won’t update the record. I want to check the record lock before performing the update statement. I don’t want to check the SQL code after performing the update statement. What I want is: [...]
Answer Question
| June 7, 2013 4:07 AM
AS/400, SQL, SQL statement
I am reading a record in SQL with No Lock and its getting displayed in Screen. Based on the user input, I will/won’t update the record. I want to check the record lock before performing the update statement. I don’t want to check the SQL code after performing the update statement. What I want is: [...]
Answer Question
| June 7, 2013 4:07 AM
AS/400, SQL, SQL statement
How do I configure AS/400 remote user printers
I have a remote user. She is printing on a our local printer here (main office). How can I have her print at her local printer in their office? All other users are printing OK. All user profiles are the same, OUTQ and PRTDEV = *WRKSTN
Answer Question
| June 7, 2013 10:54 PM
AS/400, AS/400 printing
I have a remote user. She is printing on a our local printer here (main office). How can I have her print at her local printer in their office? All other users are printing OK. All user profiles are the same, OUTQ and PRTDEV = *WRKSTN
Answer Question
| June 7, 2013 10:54 PM
AS/400, AS/400 printing
PCSERR001:Error opening up basic_ascii.pdt
When opening up an AS/400 session I am getting this message. Any ideas or fixes for the issue?
Answer Question
| June 6, 2013 3:10 PM
AS/400, AS/400 error messages, AS/400 sessions
When opening up an AS/400 session I am getting this message. Any ideas or fixes for the issue?
Answer Question
| June 6, 2013 3:10 PM
AS/400, AS/400 error messages, AS/400 sessions
Spool data truncated in PDF
Hi, I have a spool created, when I try to print the spool directly, it gets truncated. If I try to download the file from sp01, it is complete in text format but in PDF format data is truncated. I checked for printer settings, it is set to maximum width. Can anyone please suggest something?
Answer Question
| June 6, 2013 4:12 AM
AS/400, AS/400 Spool Files, PDF
Hi, I have a spool created, when I try to print the spool directly, it gets truncated. If I try to download the file from sp01, it is complete in text format but in PDF format data is truncated. I checked for printer settings, it is set to maximum width. Can anyone please suggest something?
Answer Question
| June 6, 2013 4:12 AM
AS/400, AS/400 Spool Files, PDF
AS/400 job not found with SBMJOB command
I have submitted job using command SBMJOB in RPG Program though QCMDEXC. But sometimes it’s not working after submitted. SBMJOB CMD (call pgm (xyz) parm (&a &b)) Apart from above CMD, I need to specify anything else? Please advice.
Answer Question
| June 6, 2013 3:43 AM
AS/400, AS/400 jobs, SBMJOB
I have submitted job using command SBMJOB in RPG Program though QCMDEXC. But sometimes it’s not working after submitted. SBMJOB CMD (call pgm (xyz) parm (&a &b)) Apart from above CMD, I need to specify anything else? Please advice.
Answer Question
| June 6, 2013 3:43 AM
AS/400, AS/400 jobs, SBMJOB
How to set-off many indicators at the same time?
How to set-off many indicators at the same time in RPG-III? There is a situation wherein I need to set-off 7 to 8 indicators at a time (simultaneously). planning to use MOVEA ’00000000′ *INXX; XX being the starting indicator. but it’s asking for the ARRAY. I know to declare a normal array. but how do [...]
Answer Question
| June 5, 2013 7:16 AM
AS/400, RPG
How to set-off many indicators at the same time in RPG-III? There is a situation wherein I need to set-off 7 to 8 indicators at a time (simultaneously). planning to use MOVEA ’00000000′ *INXX; XX being the starting indicator. but it’s asking for the ARRAY. I know to declare a normal array. but how do [...]
Answer Question
| June 5, 2013 7:16 AM
AS/400, RPG
Service program compilation error
How to resolve message ID CPD5D03: “Definition supplied multiple times for symbol..”
Answer Question
| June 5, 2013 3:47 AM
AS/400, RPG Program
How to resolve message ID CPD5D03: “Definition supplied multiple times for symbol..”
Answer Question
| June 5, 2013 3:47 AM
AS/400, RPG Program
