• Dynamic SQL in RPGLE

    How can I build a dynamic SQL statement for input from a screen file?

    davidgrant10 pointsBadges:
  • Uploading .CSV spread sheet to AS/400

    When saving an excel spread sheet to .CSV, the numbers in the columns will look like this 1E+13 no matter how I format the file.

    UARTJ125 pointsBadges:
  • How can I find to what program my iSeries Module was bound?

    I am trying to clean up a system (new contract) worst control of source that I have ever seen, buy I digress. My question is, If I have a module object on the iSeries, how do I find what program the module was bound?

    SicRob5 pointsBadges:
  • Turn off AS/400 notification

    At the bottom of the screen it says: The cursor is on row 3 column 23. Input is not inhibited. Insert mode is off Caps lock is off. 3270 numeric lock is off. How do I get rid of this?

    babydoll15 pointsBadges:
  • How to get details of all invalid login attempts by a user in AS/400

    I have a user profile whose invalid login attempts count in a day which is stored in the user profile does not match the logins recorded in DSPLOG for that day. How can i get details of all the invalid logins attempted by the user. Apart from DSPLOG is there anywhere else this is recorded and can...

    JohnsonMumbai1,360 pointsBadges:
  • SQL on multi-membered file without overriding

    How to query on a file and retrieve data from any of the members of the file without overriding to any of them?

    vishwaraja5 pointsBadges:
  • How do I change the IP address in AS/400?

    How do I change the ip address in an as400?

    saltysurfer5 pointsBadges:
  • Send SMTP email through AS/400 server

    I need help for send SMTP email through an AS/400 server. When I send the email I received, that email sent successfully while i didn't receive any email. Can you please advise?

    Hanisadeq963510 pointsBadges:
  • 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"

    Anugwag40 pointsBadges:
  • Automaticall Refresh Display (COBOL)

    I have a need to have the screen do an Automatic Refresh. I have created a working sample using CLP and setting the Display file to waitrcd(5). CRTDSPF WAITRCD(5). So I know it can work. I have found several examples using RPG. I need to do it using COBOL. Can any one help? I have taken everything...

    KSC90 pointsBadges:
  • DST & Qsecofr password Reset

    hi, anyone help how to reset the Qsecofr usrprf id & Dst Id if Disabled. thanks kingston

    kingstoniseries205 pointsBadges:
  • Export in db2 iseries

    i want to export query output to a csv file on iseries ..can anyone tell me how to do that

    Hn25 pointsBadges:
  • How does VLDCMDKEY work in AS/400

    I have display file with load all subfile and using function key 'F3= Exit' ,'F5=Refresh' and 'F9=Print'. I want to preventing lock of screen if user press any invalid function key(anything except F3,F5,F9).Could any one suggest me any solution? I have used VLDCMDKEY at display file but in RPG...

    nabamita90 pointsBadges:
  • Create an Excel spreadsheet from iSeries spool file

    Using the DSPUSRPRF command, I want to create an outfile, then I will want to take the spool file and create a PDF, then email it to users. Can someone offer the steps I would need to take to accomplish this? Thanks for any help you can offer.

    Rrbond07140 pointsBadges:
  • Oracle In Linux

    How can I able to get and work with Oracle in Linux platform. I am using RedHat Linux 9.0.

    Samachar0 pointsBadges:
  • mimix

    what is mimix and how it works

    Mahabub25 pointsBadges:
  • Query/400: Subtract one date from another

    I only want my calculate to use number of business days.

    queryhelpserena85 pointsBadges:
  • CL error message in AS/400

    I keep getting this CL error message in AS/400. What should I do?

    Messam280 pointsBadges:
  • Holding and restarting the job scheduler

    We have A LOT of jobs scheduled through the Advanced Job Scheduler (wrkjobjs).  We have to do some system maintenance and need to prevent the scheduled jobs from starting while we perform the maintenance. In the past, the operator has gone through the entire list of jobs on the scheduler and...

    ElTerrifico620 pointsBadges:
  • AS/400 vs. SAP

    If you are familiar with AS/400/BPICs/BAMCS can you catch onto SAP easily?

    Zero55 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