Networking
Control messages between the Hosts are exchanged through IMPs, which causes the unnecessary delay. Suggest an alternative to minimize the delay?

Answer Question   |  October 26, 2012  4:42 AM
IMP, Network
asked by:
10 pts.

Session Limit – Cannot Ping AS/400 Server
Why can some users ping the AS/400 and some cannot? Does this have anything to do with reaching a session limit?

Answer Question   |  October 25, 2012  2:50 PM
AS/400, AS/400 Server
asked by:
5 pts.

runrmtcmd
Getting an error like this when i attempt to run RUNRMTCMD…. RUNRMTCMD CMD(‘CHKOBJ OBJ(TASK/ESTPGM1R) OBJTYPE(*PGM)’) RMTLOCNAME(XXXXXX U *SNA) RMTUSER(XXXXXXX) Remote system rejected attempt to start program for conversation A.

Answer Question   |  October 25, 2012  11:38 AM
AS/400 commands, RUNRMTCMD
asked by:
15 pts.

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
asked by:
2,030 pts.

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
asked by:
80 pts.

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
asked by:
155 pts.

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
asked by:
340 pts.

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
asked by:
1,145 pts.

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
asked by:
40 pts.

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
asked by:
40 pts.

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
asked by:
50 pts.

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
asked by:
145 pts.

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
asked by:
2,030 pts.

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
asked by:
205 pts.

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
asked by:
40 pts.

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
asked by:
215 pts.

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
asked by:
15 pts.

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
asked by:
5 pts.

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
asked by:
180 pts.

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
asked by:
1,745 pts.