• Dynamic SQL in RPGLE

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

    davidgrant5 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,325 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:
  • Job Dependency across LPARS

    J1 scheduled to run in lpar - lets say L1 J2 scheduled to run in lpar - lets say L2 Here my requirement is J2 should start run after completion of J1. Can we make this dependency across the LPARS? I am using CA ESP tool to schedule the jobs.

    Manoranjani5 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:
  • AS/400 display program message

    I am seeing this message from a lot of my users when they try and access the routing application within the AS/400. It has 4 options to answer the message but none seem to do anything. The exact wording is" Job 408069/ED/QPADEV0160 started pm 7/25/16 at 08:46:10 in subsystem QINTER Message queue Ed...

    whaline5 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