• 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,480 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:
  • 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:
  • 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.

    Rrbond07520 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.

    queryhelpserena105 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 vs. SAP

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

    Zero55 pointsBadges:
  • List libraries and size used by DB2

    How do I list all the libraries used by DB2 in an AS/400 environment?

    gmorote15 pointsBadges:
  • CTG opening programs

    What program opens to original contents of CTG Files?

    aff84air5 pointsBadges:
  • Easy way to identify DB file for specific data on screen (AS/400)

    I am trying to identify where a specific line of data is coming from when I am in a session. I've tried Shift+ESC+3+14, and all I get are active DB files. Is there a way to focus the search to one specific line of data and identify the source DB?

    mssanwo15 pointsBadges:
  • Change Default on StrPrtWtr CMD within iSeries Nav.

    How can I change the default on StrPrtWtr CMD within iSeries Navigator?

    MaryM995 pointsBadges:
  • DFU with VARCHAR fields?

    Can I use DFU to maintain VARCHAR fields in a table? If not, is there another easy utility that I can give users to add text to such a file?

    markhod5 pointsBadges:
  • DSPJOBLOG message for a individual session

    Just to be curious, any number of commands which we executed in the command line are shown if we took dspjoblog. Actually from where the dspjoblog command retrieves those information and shows to us. I tried with wrkmsgq (my workstation and also my user profile). I found nothing but the information...

    harish1990125 pointsBadges:
  • Spoolfile entry object/owner

    Is there a way to change the owner of a spoolfile entry? One user created the report and now a 2nd user needs to see it via Spool Explorer. neither has a full command line since we tightened security. Many years ago I would convert the spooler entry to a physical file and later convert it back to a...

    aceofdelts2,475 pointsBadges:
  • Promote a CL that uses TAATOOL utility

    Hi. I have some CLS written that use TAATOOL command. If I compile, it compiles well since TAATOOL is in the library list. However at the time of promotion it says compile fail, since it was unable to find the TAATOOL command.

    QaziHassan5 pointsBadges:
  • Problem with character alignment on output or retrieval of variables

    We have an issue we have never seen before but I'm sure happens all the time. We have a DDS screen where the character's are shown as follows:- RETAIL LOGISTICS                     : £99.00 RETAIL FREIGHT                         :£120.00...

    Sxlad200145 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