• Create table dynamic SQL using SQLRPGLE

    Hi. How can I create table using dynamic SQL using SQLRPGLE?

    amiruladli9540 pointsBadges:
  • infinium file names

    I have experience with infinium but it has been a while. Can someone send me the file names or structures of infinium software, AR, AP, Fixed assets, payroll? Any of them will do. Thanks.

    Ngevor5 pointsBadges:
  • Upload Excel file into AS/400

    Can an excel file be uploaded into AS/400?

    Tammyc15695 pointsBadges:
  • BPCS V6.1 Shop Order Status

    Can anyone provide me with a list of what the shop order status codes mean in field FSO.SSTAT?

    jaggity25 pointsBadges:
  • RPGLE SETLL / READE for update getting record lock on different key

    We are encountering sporadic unexpected record locks with update files using: setll (Key1) MasterFile; // Partial key. dou %eof(MasterFile); reade (Key1) MasterFile; if not %eof(MasterFile); // [Stuff] update MasterFmt; endif; enddo; Looking at the problem record by RRN, its key does not match...

    SemiTechieGeo70 pointsBadges:
  • iSeries & Godex G500 printer

    I would very much appreciate it if anyone knows the parameter values to configure a Godex G500 printer i=on an iSeries. Thanks very much!

    ermc102210 pointsBadges:
  • How to create a AS400 Qshell script (.sh) file

    Hi, I want to run a command STRQSH CMD ('/REPORTGENERATOR/move2current.sh') Where move2current would be a .sh file with commands as below: rm /HPA_CURRENT/_YOUR_AS400_NAME*.CSV cp /REPORTGENERATOR/*$(date '+%Y%m%d')* /HPA_CURRENT #set new owner chown hpa_transf /HPA_CURRENT/*.CSV My question is how...

    DeepikaR115 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:
  • IBM API for viewing debug data

    I want to check the debug view of all programs of a particular library. Tedious to go with DSPPGM on all programs and verify the DEBUG DATA parameter. Is there a system API that provides this information? I came across QCLRPGMI API and pass format name as PGMI0100. However, this doesn't have the...

    sri8707240 pointsBadges:
  • Printing Superscript / Subscript from RPGLE

    How to print subscript / superscript through RPGLE into spool file. This gets converted to PDF at the end. How to print "1st" as 1st using RPGLE. The printer field type is character length 5. Printer device type . . . . . . . . . : *AFPDS Coded as @Symbo = '1' x'09 'st' x'03 It prints "1 st ", with...

    LINYUSA201825 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:
  • Automatic email notifications from iSeries

    Nagi needs to write a code on his iSeries 870 to send a notifications to his e-mail, such as server rebooting, jobs not started or need reply, etc. He's a Windows guy, and doesn't know where to start. Can someone help him with the code and possibly send him steps on how to write it and where and...

    MichelleDavidson515 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:
  • AFPDS PRTF special character printing within text string?

    Is it possible to include a special character within a text sting output to an AFPDS print file? We have output the special character by using a symbol character set but it has to be output as an individual field and results are not perfect for different printers. Has anyone created a DDS Print...

    hafwhit1,180 pointsBadges:
  • Advantages of database system over file systems

    What are the advantages of database system over file systems?

    Michael Tidmarsh65,655 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:
  • Using XML-into in RPG getting error

    Hello.. I am having an issue using xml-into when my xml has only an ending tag. I am receiving error "XML document does not match RPG variable". The vendor sending the xml file to me states it is still valid xml and should not cause error. How can I get around this error using xml-into. My xml...

    clauinger15 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:
  • Free websites to access AS/400

    Hi, can anyone can tell me the free sites to access AS/400, where we can do the actual RPG coding?

    Sabarish60 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