Logical File
Hi, I have written two online programs.  The first one uses PRDATA-FILE.  The second one uses a logical file based on PRDATA-FILE.  When the screen of the first online program is displayed, the screen of the second online program does not display records.  Is this because PRDATA-FILE is locked by the first online program? How [...]

Answer Question   |  April 26, 2012  10:12 AM
AS/400 logical file, COBOL, iSeries 820

Query in SQL400
Hi, I want one query in SQL400, I will give small example? Suppose there are two tables,    TAb1                Tab2 1.CMP                 1.CMP 2.Item NO           2. Item NO 3.Status              3.Warehouse 4.Quantity           4.Costing type   Now I want the data from tab2 where warehouse = 502 , Costing type = ’2′   and status = ’20′ (tab1)  so, how to write the query?  [...]

Answer Question   |  April 20, 2012  6:37 AM
AS/400, SQL Query, SQL/400

Sending eMail from iSeries
I’ve Configured something on my AS400 to send email to receipients. ,Then i tried to send mail using SNDDST command ,getting “Send distribution completed successfully”message ,but the email is not going out. Usually once we send mail,It shuld also show its presence here.. WRKLNK ‘/QTCPTMM/MAIL’ If any has idea,Pls help me in finding clue to [...]

Answer Question   |  April 11, 2012  5:22 AM
AS/400 v6r1, AS400 iseries, SNDDST

Getting Apache REMOTE_USE variable (CGIDEV2)
My RPG on iSeries program doesn’t seem to get the REMOTE_USE variable when it is responding to a web call from a Reverse Proxy server (Apache/Linux/PHP). I am using getenv() function from CGIDEV2 library and it works perfectly when the call comes from within the LAN. If the call comes from the reverse proxy, function [...]

Answer Question   |  April 10, 2012  5:06 PM
iSeries RPG, iseries v5r4

Getting timed out in the AS400
How can I stop from getting time out in the AS400? I am monitoring the AS 400 work that is coming in all through the day and every so often I get time out if I don’t do any action on system. The AS 400 will log me out automatically because it thinks I am not using it any [...]

Answer Question   |  April 11, 2012  3:52 PM
AS/400, AS/400 login

Logical file Error.
i try to create Multiple-format Logical File but i getting compile time error. i have two PF dds is as follow.. A          R RDEPTMST                A            DEPTNAME      15        A            DID   [...]

Answer Question   |  April 17, 2012  6:20 AM
AS/400 DB2, Logical File

Query against User Profiles
I was trying to omit some of the user profiles,which generally starts with KMAN*,TMAN*,CMAN* from the list of all user profiles (DSPUSRPRF USRPRF(*ALL) TYPE(*BASIC) OUTPUT(*OUTFILE). I’m querying this against to a outfile,i was able to select the columns what i want,but i couln’t find option/feature to omit certain user profiles which start generally with common [...]

Answer Question   |  April 11, 2012  4:55 AM
AS400 -WRKQRY, iSeries V6R1

How to add a user
Can I copy a user prf and make a new user from that?

Answer Question   |  May 3, 2012  7:23 PM
AS/400-Users, WRKUSRPRF

iSeries Access *.OWS File
We are changing the iSeries IP address in company with 3000+ users connecting with different versions of iSeries Access for Windows. Most of these configurations were done with system IP rather than host name. Can all of these be changed with LAN Desk and if so how?

Answer Question   |  April 10, 2012  1:49 PM
iSeries Access, LAN Desk

RUNRMTCMD
I am trying to execute RUNRMTCMD command from CLP on one partition to another partition using *SNA method.  I can execute this CLP without any error when I specify my user id and password on remote user id and remote password parameters. When I try to execute the same CLP by specifying another user id [...]

Answer Question   |  April 10, 2012  7:37 AM
AS400 CLP, AS400 V6R1M1, RUNRMTCMD

subfile
did the above steps but its not working… Example:: —————————————– FLD1 FLD2 FLD3 AAA AAAA AAAAA AAA AAAA AAAAA AAA AAAA AAAAA rrn = 3 —————————————– BB ______ _________ i need to filter the records having the value BB ,but there is no records having that values.. There is no records having the value as [...]

Answer Question   |  April 13, 2012  6:49 AM
AS/400, AS/400 Subfiles

Unable to connect to AS/400 server
I have downloaded as400 emulator TN5250 (free trial version). After installing the setup it took the IP address automatically. But if I say connect by giving a session name, it says “Sorry, unable to connect to the selected mainframe”

Answer Question   |  April 12, 2012  11:11 AM
AS/400 connection error, AS/400 Emulator

FTP- options for receiving files
Hello all, We have an FTP client who is putting 4 files at a time on  their server folder for us to pick up. I am running into a little issue and am looking for options.  They will not delete the files from their folder after we get them. We do not have authority to [...]

Answer Question   |  April 11, 2012  5:39 PM
AS/400 FTP, AS/400 v5r4

Socket() “too many files open” error – but no files are open
I am writing an RPG Sockets program and when I call the “C” socket() function, I am receiving an “EMFILE 3452 Too many open files for this process” error.  However, there are no other files open in this program. The code and prototypes are exactly the same as an existing “C” client that is working. [...]

Answer Question   |  April 6, 2012  8:52 PM
AS/400, AS400. RPG

RPGLE program described files
  Why is this so diffcult to space so it is readable? FILE01 has some records that need to be copied to FILE02 and deleted from FILE01. This is my error: *RNF7260 30 3 The Factor 2 operand is not valid for the specified operation.  What do I need to fix? FFILE01    UF   F 2300        [...]

Answer Question   |  April 10, 2012  4:50 PM
iSeries RPGLE, RPGLE Program

Commitment Control in RPGLE Program
Hi, Is there any way that we can handle commitment control in RPGLE program i.e. if program dumps at some point then we rollback the updates done on other files in previous steps. Actually I am calling rpgle program from outside iSeries. If any error occurs on external interface then I have the way to [...]

Answer Question   |  April 5, 2012  3:25 PM
AS400 RPGLE, RPGLE

How to find the fullpath/absolute path of a file at AS400?
One program file (MYFILE) exist at one Library (MYLIBRARY), but how to know the fullpath/absolute path of this program file ? Can not find the file at /MYLIBRARY/MYFILE, where is the file located ?

Answer Question   |  April 6, 2012  8:46 AM
AS/400, as/400 files

AS400 SNDDST with Dynamic from address
kindly anyone please tell me, how to change dynamic FROM email address in the SNDDST command.I have task to change the from address in the SNDDST based on parameter user sent.I checked in the internet with option to configure TCP using WRKDIRE.But i want the dynamic from address for the particular module only.

Answer Question   |  April 17, 2012  6:45 AM
AS/400, dynamic controls, SNDDST

AS400 File transfer from AS400
I transfered the database output into excel file using CPYTOIMP command and attached the excel file using SNDDST command.But i have issue that i didn’t received the excel file through email only if the file size more.Anyone kindly tell me, how to write the data into multiple sheets or kindly advise me some idea to [...]

Answer Question   |  April 17, 2012  4:47 AM
AS/400 File Transfer, CPYTOIMPF, SNDDST

Can we rename QSECOFR user id.(Auditors requirement)
Can we rename QSECOFR user id.(Auditors requirement)

Answer Question   |  April 19, 2012  1:22 AM
AS/400, OS/400