Trimming trailing Zeros
I have a numeric field of 25,9 in a file. I have a program which calculate this value. I want to appear this field in file without trailing zeros. If the value is 2,935.995000000 I want it to write to file as 2,935.995. How is this possible?
Answer Question
| October 25, 2012 5:22 AM
AS/400
I have a numeric field of 25,9 in a file. I have a program which calculate this value. I want to appear this field in file without trailing zeros. If the value is 2,935.995000000 I want it to write to file as 2,935.995. How is this possible?
Answer Question
| October 25, 2012 5:22 AM
AS/400
Add In function in Excel 2010 to download file from iSeries v7.1 exceeding limit, is there something we need to do to up the limit of records from 64K
We are running a Data File Transfer from the iSeries to Excel 2010, using the Add In off of Excel for File Transfer From iSeries. We can only download 64K records. How can we get this size limit to be larger? Our iSeries is at V7.1 and our client Access is at V6 and/or V7 [...]
Answer Question
| October 24, 2012 2:56 PM
iSeries AS/400, Microsoft Excel 2010
We are running a Data File Transfer from the iSeries to Excel 2010, using the Add In off of Excel for File Transfer From iSeries. We can only download 64K records. How can we get this size limit to be larger? Our iSeries is at V7.1 and our client Access is at V6 and/or V7 [...]
Answer Question
| October 24, 2012 2:56 PM
iSeries AS/400, Microsoft Excel 2010
Query400 report generation
I’m using query400 tool and using output type as printer files.. I want to generate a report format of transactions like this.. date act# amount date1 act no1 total act no2 total act no3 total date1 act no1 total act no2 total Final Total example transaction is like date act# amount 23/10/12 100 200 23/10/12 [...]
Answer Question
| October 24, 2012 9:01 AM
AS/400 Query
I’m using query400 tool and using output type as printer files.. I want to generate a report format of transactions like this.. date act# amount date1 act no1 total act no2 total act no3 total date1 act no1 total act no2 total Final Total example transaction is like date act# amount 23/10/12 100 200 23/10/12 [...]
Answer Question
| October 24, 2012 9:01 AM
AS/400 Query
Fixing the decimal data errors.
In the commands CRTBNDRPG & CRTRPGMOD we have the parameter FIXNBR to fix Decimal data errors. Do we have such provision for ILE COBOL?
Answer Question
| October 24, 2012 2:48 AM
AS/400, ILE COBOL, ILE RPG
In the commands CRTBNDRPG & CRTRPGMOD we have the parameter FIXNBR to fix Decimal data errors. Do we have such provision for ILE COBOL?
Answer Question
| October 24, 2012 2:48 AM
AS/400, ILE COBOL, ILE RPG
Xerox WC 7535 print from iSeries and passing security code XSNMPDRV
We have a client that would like to print to a Xerox WC and they have it setup to accept a security code. We have created a printer device using the IBMSNMPDRV but it rejects the process since it did not receive the security code. Has anyone done a configuration using the XSNMPDRV and configuring [...]
Answer Question
| October 23, 2012 10:06 PM
AS/400, iSeries, V7R1, Xerox XTOOLS, XSNMPDRV
We have a client that would like to print to a Xerox WC and they have it setup to accept a security code. We have created a printer device using the IBMSNMPDRV but it rejects the process since it did not receive the security code. Has anyone done a configuration using the XSNMPDRV and configuring [...]
Answer Question
| October 23, 2012 10:06 PM
AS/400, iSeries, V7R1, Xerox XTOOLS, XSNMPDRV
F22 step into in STRDBG not working
Using STRDBG, I use to be able to hit f22 to step into a program or procedure but now nothing happens when I hit the key. Is there a setting that enables this?
Answer Question
| October 24, 2012 4:36 PM
AS/400 debugging
Using STRDBG, I use to be able to hit f22 to step into a program or procedure but now nothing happens when I hit the key. Is there a setting that enables this?
Answer Question
| October 24, 2012 4:36 PM
AS/400 debugging
How to display more than 1 error message in a message subfile
I currently have a screen that display an error 1 at a time in a message subfile. User can roll up or down to display the next error. I want to be able to display all errors in message subfile in 1 full screen when user hits a function key. Since the message subfile (sflpag=1) [...]
Answer Question
| October 24, 2012 4:33 PM
AS/400 - DDS, AS/400 applications
I currently have a screen that display an error 1 at a time in a message subfile. User can roll up or down to display the next error. I want to be able to display all errors in message subfile in 1 full screen when user hits a function key. Since the message subfile (sflpag=1) [...]
Answer Question
| October 24, 2012 4:33 PM
AS/400 - DDS, AS/400 applications
DB2/400
Why do I need logical file in DB2/400?
Answer Question
| October 23, 2012 3:18 PM
AS/400 DB2, AS/400 logical file
Why do I need logical file in DB2/400?
Answer Question
| October 23, 2012 3:18 PM
AS/400 DB2, AS/400 logical file
Accessing STRSQL
Can granting access to limit capabilities *partial or *no will give user the access to STRSQL?
Answer Question
| October 23, 2012 9:36 AM
AS/400, STRSQL
Can granting access to limit capabilities *partial or *no will give user the access to STRSQL?
Answer Question
| October 23, 2012 9:36 AM
AS/400, STRSQL
Modify the result after a division with multiples of 10
I have an expression like this Total = Quantity/10**decimal. If I have value 000080906140000 in quantity and decimal has 6, my result is 0000000080906.13. But I want it as 0000000080906.14. Is it possible?
Answer Question
| October 23, 2012 8:53 AM
AS/400
I have an expression like this Total = Quantity/10**decimal. If I have value 000080906140000 in quantity and decimal has 6, my result is 0000000080906.13. But I want it as 0000000080906.14. Is it possible?
Answer Question
| October 23, 2012 8:53 AM
AS/400
Compare creation date of file to system date
Hi, I need help in figuring out the begaining of my CL program. I would like for the CL to act accordinly. Check a file creation date and compare that date to the system date, then if a match (do something), if not a match (send message and end job). Thank you
Answer Question
| October 23, 2012 6:48 AM
AS/400, CL
Hi, I need help in figuring out the begaining of my CL program. I would like for the CL to act accordinly. Check a file creation date and compare that date to the system date, then if a match (do something), if not a match (send message and end job). Thank you
Answer Question
| October 23, 2012 6:48 AM
AS/400, CL
Performance improvement CPYTOIMPF
Hi, I am using CPYTOIMPF command in my CL program to convert a database file to .CSV file. database file contains 3 million records and CPYTOIMPF command is taking 48 minutes to complete. Can some body kindly suggest me is there a way to improve the performance of the program. Thanks in advance. CV
Answer Question
| October 23, 2012 5:47 AM
.CSV files, AS/400, CPYTOIMPF
Hi, I am using CPYTOIMPF command in my CL program to convert a database file to .CSV file. database file contains 3 million records and CPYTOIMPF command is taking 48 minutes to complete. Can some body kindly suggest me is there a way to improve the performance of the program. Thanks in advance. CV
Answer Question
| October 23, 2012 5:47 AM
.CSV files, AS/400, CPYTOIMPF
Strengthen QSECURITY level 30
Hi, Any tips and tricks on how could i strengthen QSECURITY 30 to patch the loophole in this level (without going to QSECURITY 40)? Thank you
Answer Question
| October 23, 2012 4:08 AM
iSeries, iSeries 820, iSeries Access
Hi, Any tips and tricks on how could i strengthen QSECURITY 30 to patch the loophole in this level (without going to QSECURITY 40)? Thank you
Answer Question
| October 23, 2012 4:08 AM
iSeries, iSeries 820, iSeries Access
Blank line Input capable page at a time subfile
Hi – I am a bit rusty subfile-wise and was hoping to find an example of a page at a time subfile that provides position to and blank line input capability on the user’s request to add records to the file. I’m particularly curious about the paging concerns involved. What can I say…It’s been a [...]
Answer Question
| October 22, 2012 6:05 PM
AS/400, AS/400 Subfiles, AS400 RPGLE
Hi – I am a bit rusty subfile-wise and was hoping to find an example of a page at a time subfile that provides position to and blank line input capability on the user’s request to add records to the file. I’m particularly curious about the paging concerns involved. What can I say…It’s been a [...]
Answer Question
| October 22, 2012 6:05 PM
AS/400, AS/400 Subfiles, AS400 RPGLE
Special Authorities
You have a group profile (ABC) with special authorities of *ALLOBJ. You have a group of users with user class *PGMR with special authorities of *JOBCTL and *SPLCTL. They also have limited capabilities set to *NO and they are part of the Group Profile ABC. With command line access and having *ALLOBJ at the group profile [...]
Answer Question
| October 22, 2012 5:32 PM
*ALLOBJ, iSeries
You have a group profile (ABC) with special authorities of *ALLOBJ. You have a group of users with user class *PGMR with special authorities of *JOBCTL and *SPLCTL. They also have limited capabilities set to *NO and they are part of the Group Profile ABC. With command line access and having *ALLOBJ at the group profile [...]
Answer Question
| October 22, 2012 5:32 PM
*ALLOBJ, iSeries
MKS implementer issue
We use the product MKS implementer to manage our implemention of file and program changes from a test environment to production. Whenever we make a file structure change to the physical file, such as increasing a field size in our test environment and then implement the change, the logicals associated with that physical file do [...]
Answer Question
| October 22, 2012 1:46 PM
AS/400 3rd party tools
We use the product MKS implementer to manage our implemention of file and program changes from a test environment to production. Whenever we make a file structure change to the physical file, such as increasing a field size in our test environment and then implement the change, the logicals associated with that physical file do [...]
Answer Question
| October 22, 2012 1:46 PM
AS/400 3rd party tools
Printer files in AS400
Hi.. In our AS400 server many printer files are there. when we use WRKACTJOB to see the status, some printer files(QSPL)are always in RUN status and its taking too much CPU %. what will be the problem ?
Answer Question
| October 22, 2012 5:54 AM
AS400 printing jobs, status
Hi.. In our AS400 server many printer files are there. when we use WRKACTJOB to see the status, some printer files(QSPL)are always in RUN status and its taking too much CPU %. what will be the problem ?
Answer Question
| October 22, 2012 5:54 AM
AS400 printing jobs, status
How to create a Spool file
I queried on a file it gives me hundreds of records. Is it possible to create a spool file with these record? If yes then please tell me how?
Answer Question
| October 22, 2012 11:39 AM
AS/400 Spool Files, AS400 Command
I queried on a file it gives me hundreds of records. Is it possible to create a spool file with these record? If yes then please tell me how?
Answer Question
| October 22, 2012 11:39 AM
AS/400 Spool Files, AS400 Command
result of CHAIN with a bad key
Rather than proving it out myself, it’s so much easier to ask if anyone has run into this before. While researching a bug, I found a program that chains to a file using a 3-field key list. BUT – the 2nd and 3rd fields are “wrong” (defined as alpha in the key list but numeric [...]
Answer Question
| October 19, 2012 7:08 PM
CHAIN
Rather than proving it out myself, it’s so much easier to ask if anyone has run into this before. While researching a bug, I found a program that chains to a file using a 3-field key list. BUT – the 2nd and 3rd fields are “wrong” (defined as alpha in the key list but numeric [...]
Answer Question
| October 19, 2012 7:08 PM
CHAIN
Message file within message subfile
I have created a message file and now i want to link my message file to the DDS. Please suggest any way….
Answer Question
| October 19, 2012 12:25 PM
AS/400 Subfiles
I have created a message file and now i want to link my message file to the DDS. Please suggest any way….
Answer Question
| October 19, 2012 12:25 PM
AS/400 Subfiles
