• Infor XA Modules list

    Hi, I would like to know about INFOR XA in almost all the below areas, your help in any of it is very much appreciated. Infor XA data dictionary Basic architecture Modules list Database mapping Any user guide

    as400dev670 pointsBadges:
  • Execute SQL Server Procedure from the iSeries

    I have an internal web address for a SQL Server application, where they want to run an iSeries stored procedure to connect to the SQL Server, call a SQL Server Stored Procedure, and receive resulting values back to the iSeries. Is this possible?

    sonorato15 pointsBadges:
  • Limit Query PF File Size

    When creating a PF thru AS/400 Query, would like to limit file size?

    Yuehan6835 pointsBadges:
  • Pasing Distinct values to UDFs in SQLRPGLE

    Hi, I need to execute a query like, select UDF(col2) from FILE.    col2 is not a unique field in FILE. I don't want to calculate UDF(col2) for same values.  FILE col1 col2 1      77 2      77 3       85 4       85 5       52 I need to handle this situation in query itself....

    xselvam20 pointsBadges:
  • How to read physical file and split to another physical file

    Hi, how to split physical file when we have first column is 1? that means page break. Than create new physical file automatically when split file.

    amiruladli9540 pointsBadges:
  • DB2 Triggers not always firing

    When EDI writes our order detail lines to the physical file which is triggered, the triggers are not firing. However, when entering detail lines through a screen the triggers fire and and all is well. Through journals I can see the EDI program is writing all lines in  probably less than 1 second...

    UARTJ230 pointsBadges:
  • Upload Excel file into AS/400

    Can an excel file be uploaded into AS/400?

    Tammyc15695 pointsBadges:
  • Setoff EndOfFile and Found built-in functions

    How can we manually setOFF and setON the %Eof and %Found built-in functions on RPGLE? (Without using reading opcodes)

    csuoaananth110 pointsBadges:
  • Configure AS/400 mirror machine

    We have an AS/400 production machine and we buy another to be the production mirror. Could you explain how it should be configured to be the exact replica of production?

    CJAVIER10 pointsBadges:
  • jt400 getMessage() no response

    We are using jt400-6.7.jar to get the message text from a message file from IBM i. We are getting intermittent timeouts i.e. java.net.socketException: Connection timed out (read failed). Below is the code we used to get the message text from a message file object in the iSeries: AS400Message...

    Jpjawili315 pointsBadges:
  • SNDNETF fails

    I am trying to send a network file but I get the following message. My user id is in the system directory on both systems. SNDNETF FILE(BONDELIB/PROFILES) TOUSRID((PRDADMSX DEV)) Distribution to user PRDADMSX DEV not done; user ID is not valid. File PROFILES in BONDELIB member PROFILES not sent to...

    Rrbond07750 pointsBadges:
  • Difference between STRTCP and STRTCPSVR

    What is the difference between STRTCP and STRTCPSVR besides a few parms?

    rrockk201835 pointsBadges:
  • SETGT READPE RPG FREE

    I am using a SETGT followed by READPE and not getting the right results. When this piece of code runs in figure 1 I end up retrieving LINE 7 instead of LINE 8. Begsr Sub1; SetGT ('-':wareh:appt#) I3APPTP1; ReadPE ('-':wareh:appt#) I3APPTP1; if %eof (I3APPTP1); SetGT (' ':wareh:appt#) I3APPTP1;...

    UARTJ230 pointsBadges:
  • Integer value using physical file in iSeries

    How can I use an integer value using physical file in iSeries?

    hbrooks30 pointsBadges:
  • Make SHA hash value in SQL on AS/400

    How can I make a SHA hash value in SQL on AS/400?

    nadineha5 pointsBadges:
  • Compiling CL Program

    When compiling a CL program, the program will not compile if the current programmer is not the one who last compiled the program. It gives the following error: CPF2146 40 Owner of object and object being replaced not the same. We then have to delete the object and then compile it. Is there anyway...

    GHENDER250 pointsBadges:
  • Receive message cpe3021 on CPYFRMIMPF

    Received message cpe3021 on cpyfrmimpf...any suggestions?

    jlbarlow12155 pointsBadges:
  • Work Object Link

    Do you know a way to mass edit file permissions in work with object link, I have about 3K objects I need to change permissions on?

    liolios5 pointsBadges:
  • Printing from AS/400

    When printing from AS/400, the language is not clear. What can I do?

    hayammehras1235 pointsBadges:
  • Cursor not open in joblog

    I have a SQLRPGLE program, where I'm performing few activities using cursor. When I view the joblog after the program is called, I see "Cursor not open" message. I understand the reason for this message. But, my doubt is, when I debug the program, I could also see other messages like "row not found...

    sri8707320 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following