• Read selective file in CL by using OVRDBF

    How do I read selective file in CL by using OVRDBF by positioning to from particular record till selective record? Lets say I have Emp (record format is REC) file which is having 10 records (rrn or key field). Now I want to read file from 2nd record till 8th  record, how can we do this with...

    hndajad180 pointsBadges:
  • Reading COBOL indexed file in SQL procedure in iSeries

    How do I read a COBOL indexed file in SQL procedure in iSeries?

    Bhusha25 pointsBadges:
  • AS/400 dump space

    Removed a MSD from one of our systems and cleared some space. After the weekly RTVDSKINF *SYSBAS and printing the disk information report - we still find some 10% (of 400Gb SYSBAS) allocated to Dump space. Is this 'Dump space' the same as the area used by the MSD or something else? If used by MSD;...

    GoranA5 pointsBadges:
  • RPG /Free Local Data Area definitions

    I am trying to define the LDA with an external definition in RPG /free. Any help?

    Rstinsonindy15 pointsBadges:
  • Old AP invoices that need to be cleared

    There are old AP invoices that need to be cleared. What is the best procedure(s)?

    cadrake5 pointsBadges:
  • BRMS backups stretching

    Hello, We have BRMS daily full system backups running, everything was smooth going on, however in last Month from 15th June backup is stretching day by day and now it s taking 1.40 minutes where it use to take only 50 minutes. I have checked everything i.e.libs counts,obj size,interfaces are also...

    deepakt125 pointsBadges:
  • AS/400 – Operator and Operand split

    Hi, Assume if I have a expression like (A < Fieldb) and (C >= FieldD) Then I need to split into 2 arrays or write into a table like: Seq, Operator , Operand1 Operand2. 1 > A Fieldb 2 >= C FieldD 3 and 1 2 If not possible in RPG, is there any other language which can used in AS/400?...

    as400dev550 pointsBadges:
  • Convert spool file to .pdf with overlay

    Why is my overlay changed when I convert the file to .pdf? This is my code: OVRPRTF    FILE(BOLPRT) DEVTYPE(*AFPDS) PAGESIZE(11 8.5 +              *UOM) RPLUNPRT(*YES '-') DRAWER(1) +                      PAGRTT(0) UOM(*INCH) FRONTOVL(MXBOL) +                  ...

    mdawson65 pointsBadges:
  • How to get TAB DELIMITED file format in AS/400 flat file

    I am extracting some data into a flat file using DTF

    rav200025 pointsBadges:
  • AS/400 auditing security

    Hi, everyone. How can I know if a user profile has authority to modify auditing security in AS/400?

    srithea165 pointsBadges:
  • AS/400 User Class and Special Authority

    Hi, everyone. I have been going around AS/400 Security Reference and seemed to understand some part of it. but I find it so difficult the understand the table below. Special Authority User Classes *SECOFR *SECADM *PGMR *SYSOPR *USER *ALLOBJ All 10 or 20 10 or 20 10 or 20 10 or 20 *AUDIT All    ...

    srithea165 pointsBadges:
  • Exporting Polish characters from iSeries

    V5R4. We have a client database that, for the first time, has to deal with Latin-2 characters. We have set up some sessions to use Polish configuration (code page 1153) and got around printing problems by having a separately configured printer. Now we have a problem with exporting the data to...

    Abby7075 pointsBadges:
  • Session or Device error

    Any ideas on how this might occur ? Even a hunch would help. A remote user recently got this error. So far, I've been unable to make it happen. I believe I've only seen this when doing MANY pagedown requests (so subfile exceeds the 4-digit RRN field). This application gets maybe 50 subfile records...

    aceofdelts2,130 pointsBadges:
  • AS/400 force password change at first login

    Hi guys, How can I know if a user profile has been forced to change its default password at first login?

    srithea165 pointsBadges:
  • iSeries 6.1 ‘IBMDA400.DataSource not registered

    I have a case where I installed iSeries 6.1 on user machine. we have a test machine with the iSeries installed too. They are both 32-bit machines. we are getting an error message The 'IBMDA400.DataSource.1' provider is not registered on the local I have reinstalled iSeries, application etc.

    todd092515 pointsBadges:
  • DB2/400 SQL Sub Query Performance?

    Here is the problem. Table INVEHH is a (Events header table) with about 500 records and INVEHD (Event Details) with about 22 million records. These tables are on a DB2/400 database. 1) Original Query that takes forever: select EVENT, INUMBR, ISTORE, EVHYY, EVHMM, EVHDD from INVEHD where EVENT in...

    Apothen0 pointsBadges:
  • SQL Option SQL option SRTSEQ=*LANGIDSHR

    I have PGM1 with SQL option SRTSEQ=*LANGIDSHR. Now from PGM1 I am calling PGM2 (PGM2 is a *PGM object with *InLR = *On) where SQL option SRTSEQ=*HEX When controls comes back to PGM1, what would be the SRTSEQ?

    BibekMajilla45 pointsBadges:
  • Is AS/400 audit log able to be modified or deleted?

    Is AS/400 audit log able to be modified or deleted? And who have authority to do that? Thank you.

    srithea165 pointsBadges:
  • Record format in DB2/400

    How to check file name using record format in DB2/400?

    vishwaraj60 pointsBadges:
  • User profile disabled

    Hi again, first off, thanks for your help in my other quests. New problem - Subsystem QSYSWRK disabled user profile USER on device *N. This happens constantly for just this one user. I have changed the PWDEXPITV to *NOMAX but it still happens. I don't know if this is is because of the new version...

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

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following