I would like to run a report on AS/400 to indentify which DB2 tables to reorg.
Hi, New to iSeries. I need to identify which tables need to be reorged. From manual I see that if I do a DSPFD FILE(xxx/*ALL) TYPE(MBRLIST). I get a report where the Total deleted records are more than 10% of the total records I should reorg. Is there a report similar from DB2 side a [...]
Answer Question
| March 23, 2012 9:54 AM
DB2, iSeries, OS/400
Hi, New to iSeries. I need to identify which tables need to be reorged. From manual I see that if I do a DSPFD FILE(xxx/*ALL) TYPE(MBRLIST). I get a report where the Total deleted records are more than 10% of the total records I should reorg. Is there a report similar from DB2 side a [...]
Answer Question
| March 23, 2012 9:54 AM
DB2, iSeries, OS/400
AS400 Trigger – Old and New Fields
I am trying to create a log file for my physical files that shows me: the file name, the program making the change, the date of change, the name of the updated field, the old value, and the new value for that field. From what I’ve seen triggers only give you the RECORD old and [...]
Answer Question
| March 23, 2012 12:23 AM
AS/400, AS/400 triggers, Log files
I am trying to create a log file for my physical files that shows me: the file name, the program making the change, the date of change, the name of the updated field, the old value, and the new value for that field. From what I’ve seen triggers only give you the RECORD old and [...]
Answer Question
| March 23, 2012 12:23 AM
AS/400, AS/400 triggers, Log files
ISeries Navigator
Hi, I am a DB2 DBA coming from zSeries to iseries. I have iSeries Navigator , when I click on “Database task” “Map the database”nothing happens. Is there somewhere I can check for an error message or do I have to load an addon? Regards Wendy
Answer Question
| March 26, 2012 9:36 AM
iSeries Navigator, OS/400
Hi, I am a DB2 DBA coming from zSeries to iseries. I have iSeries Navigator , when I click on “Database task” “Map the database”nothing happens. Is there somewhere I can check for an error message or do I have to load an addon? Regards Wendy
Answer Question
| March 26, 2012 9:36 AM
iSeries Navigator, OS/400
as400 not working in windows 2008 server
my script is working in windows xp, but not in windows 2008 server. I just fetch the records from as400 through php. if i run that page means iy says the page is not available. if i disable the as400 odbc connection means it will run and say no connection but i enable the code [...]
Answer Question
| March 24, 2012 6:55 AM
AS/400, Microsoft Windows 2008, PHP
my script is working in windows xp, but not in windows 2008 server. I just fetch the records from as400 through php. if i run that page means iy says the page is not available. if i disable the as400 odbc connection means it will run and say no connection but i enable the code [...]
Answer Question
| March 24, 2012 6:55 AM
AS/400, Microsoft Windows 2008, PHP
Problem with Barcode for AS400
Hi Srs, Im an AS400 developer currently having problems with a Report that contains barcode generated via AS400. I’ve generated a barcode in RPG and is working fine in 7 of the 9 printers that the enterprise where I work has (The report prints fine) , the problem is that in those 2 remaining printers, the report is generating [...]
Answer Question
| March 22, 2012 4:44 PM
AS/400, AS/400 printers, AS400/RPG
Hi Srs, Im an AS400 developer currently having problems with a Report that contains barcode generated via AS400. I’ve generated a barcode in RPG and is working fine in 7 of the 9 printers that the enterprise where I work has (The report prints fine) , the problem is that in those 2 remaining printers, the report is generating [...]
Answer Question
| March 22, 2012 4:44 PM
AS/400, AS/400 printers, AS400/RPG
Overlay Printing Issue
I have one overlay that two programs use. When testing I have a very simple CL program with one OVRDBF and two program calls one of which I have commented out because I swithch calls when testing. In trying to print a voucher the main voucher program works fine, I then modify the CL by [...]
Answer Question
| March 22, 2012 3:40 PM
CL Program, iSeries Overlay Printing Issue
I have one overlay that two programs use. When testing I have a very simple CL program with one OVRDBF and two program calls one of which I have commented out because I swithch calls when testing. In trying to print a voucher the main voucher program works fine, I then modify the CL by [...]
Answer Question
| March 22, 2012 3:40 PM
CL Program, iSeries Overlay Printing Issue
AS 400 printer file shading of record format
How do I shade (excel style) a whole record format within a printerfile? The record format may appear many times on a page and of course on different lines. Should I create an overlay, if so, how do I create the overlay to print in variable positions? I am using RPG to produce the report [...]
Answer Question
| March 25, 2012 3:15 PM
AS/400, AS400/RPG
How do I shade (excel style) a whole record format within a printerfile? The record format may appear many times on a page and of course on different lines. Should I create an overlay, if so, how do I create the overlay to print in variable positions? I am using RPG to produce the report [...]
Answer Question
| March 25, 2012 3:15 PM
AS/400, AS400/RPG
AS400 Barcode
Hello, When I used apw(ADVANCE PRINT WRITER)to create a barcdoe in cdoe39 style,if the field have the blank on the end of the field,the right mark ‘*’ will be print output,but the mark ‘*’ is used to show the end of field in the code39 style. Would someone can tell me the reason and how [...]
Answer Question
| March 22, 2012 3:24 AM
AS/400, AS400 printing issue, OS/400 V5.4
Hello, When I used apw(ADVANCE PRINT WRITER)to create a barcdoe in cdoe39 style,if the field have the blank on the end of the field,the right mark ‘*’ will be print output,but the mark ‘*’ is used to show the end of field in the code39 style. Would someone can tell me the reason and how [...]
Answer Question
| March 22, 2012 3:24 AM
AS/400, AS400 printing issue, OS/400 V5.4
s36 files and environment is lost
i have program that work under s36 environmetn , … when user try to login it says user must login under s36 environment when i try anyl command related to s36 such as strs36 or strs36prc or what ever it reply ” file not found (file is not a part of qssp lib ) when [...]
Answer Question
| March 20, 2012 9:07 PM
i5/OS, iSeries partitioning
i have program that work under s36 environmetn , … when user try to login it says user must login under s36 environment when i try anyl command related to s36 such as strs36 or strs36prc or what ever it reply ” file not found (file is not a part of qssp lib ) when [...]
Answer Question
| March 20, 2012 9:07 PM
i5/OS, iSeries partitioning
CLRPFM
When PF is Kept opened in One session that is I have done runqry on a PF ,and in the other session , if I try to do CLRPFM , it is not allowing .So if i want to delete the records of the fie if it is kept opened , what can be done [...]
Answer Question
| March 19, 2012 12:35 PM
CLRPFM, PF file
When PF is Kept opened in One session that is I have done runqry on a PF ,and in the other session , if I try to do CLRPFM , it is not allowing .So if i want to delete the records of the fie if it is kept opened , what can be done [...]
Answer Question
| March 19, 2012 12:35 PM
CLRPFM, PF file
as/400 INFDS
by using INFDS i do not want to write duplicate record into PF what is the requirements for that?
Answer Question
| March 19, 2012 7:29 AM
AS400 Data Definitions, AS400 iseries, INFDS
by using INFDS i do not want to write duplicate record into PF what is the requirements for that?
Answer Question
| March 19, 2012 7:29 AM
AS400 Data Definitions, AS400 iseries, INFDS
how to copy tables between two libraries without repeat cpyf command using script?
I need to copy tables from library to another on the same iSeries v7.1, is there a script to copy multible tables without repeat cpyf command???
Answer Question
| March 20, 2012 8:17 PM
CPYF, iSeries v7.1
I need to copy tables from library to another on the same iSeries v7.1, is there a script to copy multible tables without repeat cpyf command???
Answer Question
| March 20, 2012 8:17 PM
CPYF, iSeries v7.1
Thenon SEE/Change Status *RSPW
Hi, not sure if many people use the Thenon SEE/Change tool… After sending changed software from test machine to production machine, the status of the transfer is showing as *RSPW instead *COMP . This is the first time this has happened… has anyone any ideas on this? All looks good on the production machine – [...]
Answer Question
| March 17, 2012 4:12 PM
AS/400, AS400 Thenon SEE/Change
Hi, not sure if many people use the Thenon SEE/Change tool… After sending changed software from test machine to production machine, the status of the transfer is showing as *RSPW instead *COMP . This is the first time this has happened… has anyone any ideas on this? All looks good on the production machine – [...]
Answer Question
| March 17, 2012 4:12 PM
AS/400, AS400 Thenon SEE/Change
CPYFRMIMP inserting quotation marks
I am trying to use CPYFRMIMPF to copy a tab delimited file to a physical file. The problem I have is that the file has commas (,) in the text and CPYFRMIMPF automatically inserts quotation marks around the text whenever there is a comma in the field. For example, if my tab delimited file has 2 [...]
Answer Question
| March 30, 2012 3:33 PM
AS400 iseries, CPYFRMIMPF, iseries v5r4
I am trying to use CPYFRMIMPF to copy a tab delimited file to a physical file. The problem I have is that the file has commas (,) in the text and CPYFRMIMPF automatically inserts quotation marks around the text whenever there is a comma in the field. For example, if my tab delimited file has 2 [...]
Answer Question
| March 30, 2012 3:33 PM
AS400 iseries, CPYFRMIMPF, iseries v5r4
Can I Declare a variable-length Array?
Is it possible to Declare a variable-length Array viz.. like we have in “VARLEN” in DDS?
Answer Question
| March 17, 2012 1:31 PM
AS/400, RPG/400, RPGILE
Is it possible to Declare a variable-length Array viz.. like we have in “VARLEN” in DDS?
Answer Question
| March 17, 2012 1:31 PM
AS/400, RPG/400, RPGILE
Printing Report in local printer
I want to check the font size of a report whether it is incorporated in A4 sheet or not? how to print report output from spool file( WRKSPLF) in as400 system to a local printer? How to configure printer to as 400 system? What are the parameters to be changed when printing from report spool file? [...]
Answer Question
| March 17, 2012 1:05 PM
AS/400, AS/400 Spool Files, WRKSPLF
I want to check the font size of a report whether it is incorporated in A4 sheet or not? how to print report output from spool file( WRKSPLF) in as400 system to a local printer? How to configure printer to as 400 system? What are the parameters to be changed when printing from report spool file? [...]
Answer Question
| March 17, 2012 1:05 PM
AS/400, AS/400 Spool Files, WRKSPLF
Restore files from old machine and migrated tape
Hi, I am having a hard time restoring data from migrated tapes to our current system. Tapes were migrated from series of media to our current media system; when we try to display (iSeries V5R3 on TS3500) we encounter error:
Answer Question
| March 21, 2012 5:53 AM
iSeries, OS/400 V5R3
Hi, I am having a hard time restoring data from migrated tapes to our current system. Tapes were migrated from series of media to our current media system; when we try to display (iSeries V5R3 on TS3500) we encounter error:
Answer Question
| March 21, 2012 5:53 AM
iSeries, OS/400 V5R3
AS400 Replace disk
Hello, I have an AS400 model 720 with historical data. 1 disk has the status SUSPENDED. I have tried to replace the disk with another disk (same type model). But disk is still failed. Can someone tell me step-by-step how to replace a disk? Thanks. Kansarax
Answer Question
| March 17, 2012 2:37 PM
AS/400, AS/400 disk
Hello, I have an AS400 model 720 with historical data. 1 disk has the status SUSPENDED. I have tried to replace the disk with another disk (same type model). But disk is still failed. Can someone tell me step-by-step how to replace a disk? Thanks. Kansarax
Answer Question
| March 17, 2012 2:37 PM
AS/400, AS/400 disk
CLRLIB QMPGDATA Problems
Good morning. My name is Eduardo San Nicolas and I have a problem of occupation in my iSeries (9406-550 in V5.4) I am not currently collecting performance data and to free up space I thought QMPGDATA delete the library. My question is if I run the command CLRLIB QMPGDATA can cause a problem in the [...]
Answer Question
| March 20, 2012 10:10 AM
iSeries 5.4, iSeries Commands, QMPGDATA
Good morning. My name is Eduardo San Nicolas and I have a problem of occupation in my iSeries (9406-550 in V5.4) I am not currently collecting performance data and to free up space I thought QMPGDATA delete the library. My question is if I run the command CLRLIB QMPGDATA can cause a problem in the [...]
Answer Question
| March 20, 2012 10:10 AM
iSeries 5.4, iSeries Commands, QMPGDATA
How to Retrieve Message File
Hi, i am posting new question for how to retrive message files when i given specific *lib or *all
Answer Question
| April 10, 2012 6:24 AM
RPGLE Program
Hi, i am posting new question for how to retrive message files when i given specific *lib or *all
Answer Question
| April 10, 2012 6:24 AM
RPGLE Program
