• Bad data in as/400 database.. cant display record

    We have a user that insists on using cut and paste to enter data into our system. The problem is bad hex/ascii chars are causing errors trying to retrieve the data. If you try to edit the data using STRDFU it gives the message "The retrieved record contains invalid data." To make things worse you...

    ToddN200099,840 pointsBadges:
  • Substringing long character length field

    After doing a DSPUSRPRF command and putting the data into a file, there is a field called Special Authorities which is a 150 character length field. I need to take this field and break it up to create a separate field for each value that this field has. So if there are entries like, *ALLOBJ ...

    Rrbond07440 pointsBadges:
  • AS/400: How to read a file in CL program

    How we read a file in CL program and which command is used?

    vivekntt21185 pointsBadges:
  • AS/400 commands: Difference between CPYF vs. CRTDUPOBJ

    What is the difference between CPYF VS CRTDUPOBJ?

    vivekntt21185 pointsBadges:
  • AS/400 occurrence arrays

    What are occurrence arrays and in which case it is used in RPGLE?

    vivekntt21185 pointsBadges:
  • Consolidation error in BPCS

    Hi, I'm receiving error :- Entered whose does not match the whose used for the consolidation.

    amitsam25 pointsBadges:
  • AS/400: Using %len and %trim

    Trying to find examples on using %len and %trim functions in AS/400.

    Daverl5 pointsBadges:
  • Select statement stopped listing records

    The statement is only selecting syntax and not listing records. Process parameter is *RUN. It was working earlier.

    gamurtuza35 pointsBadges:
  • AS/400 Physical file

    How to find the physical file associated with a logical file?

    vivekntt21185 pointsBadges:
  • Listing Supplement Groups from a AS/400 user profile

    I need to create a file (I am thinking from using query) that will list a user's Supplemental Group(s) as a separate line item for each supplement group listed in their profile. I need this so our security person can run a program they have for some kind of report. Is there a way to configure this...

    Rrbond07440 pointsBadges:
  • Suppress type ZR in AS/400 audit journaling

    the size of our audit journal has exploded. In looking at the entries, we have a ton more of type ZR (object read access). Is there any way to suppress those from being captured in the audit journaling?

    dpa165 pointsBadges:
  • Display two subfiles on same page in RPG

    How can I display two subfiles on same pages in RPG programming with sample program to display the screens at the same time?

    junekotey20 pointsBadges:
  • Input/Output of data transfers (Network TCP/IP traffic

    Is there a way of knowing the input/output of data traffic (Network TCP/IP traffic) by LPAR?

    Rrbond07440 pointsBadges:
  • Rebooting and changing boot-mode through display on iSeries

    We need to reboot iSeries but can only access through display at front of iSeries. I need help with meaning af symbols in display-window and how to change these.

    JensOrkla25 pointsBadges:
  • Display Panel of AS/400

    This is displaying on the display panel: "01 B N V=F T" What does this mean?

    mklein5 pointsBadges:
  • Outfile for profile authorizations

    Can anyone tell me what command will give me the following information. The fields for the information begin with OA, but I can't figure out what command will generate the information. OADCEN OADDAT OADTIM OAUSR OAOBJA OAOPR OAOMGT OAEXS OAREAD OAADD OAUPD OADLT OAAMGT OAANAM OANAME OALIB OATYPE...

    Rrbond07440 pointsBadges:
  • BPCS user access list

    How can I generate a user access list in BPCS?

    srksherazi5 pointsBadges:
  • How to display all objects authority in a library?

    Is there anyway to display (or outfile) all objects authority in a library? DSPOBJAUT require the object name (which i need to key in the name 1 by 1 & there are thousand of them), PRTPUBAUT doesn't include those object which public authority is *EXCLUDE. But what I want to do is check all...

    Nlks5 pointsBadges:
  • AS/400 ODBC connection

    How can I restrict SQL reporter to run update and delete query via ODBC connection? I don't want to restrict some profile which are being used by other application to write some records in specific file. Please advise.

    KapilTiwari201850 pointsBadges:
  • DSPOBJD for Library size and # of objects

    Is there a command/way of just getting the number of objects and total size of libraries other than selecting the *PRINT option? I wanted to dump the information to a file so I can query over it. I can dump the library names to a file, but I had to produce a listing as well so I can get the number...

    Rrbond07440 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