• Superseded PTFs.

    If there are special instructions for a superseded PTF that is not loaded or applied on your system in an ordered PTF cover letter, do you need to order the superseded PTF and follow the instructions for it before loading the PTF that will supersede it? I hope my question makes sense.

    Bkr0963c0 pointsBadges:
  • How do I change the field length in a physical file using chgpf command?

    Hi,  This is giri.Im looking to change the field length in pf using chgpf command?Please give me what are the steps i have to do?How can i change the field?

    Girilabs130 pointsBadges:
  • create xml content from as/400 db2

    Hi, wonder if these xml functions (XML2CLOB, XMLELEMENT, XMLATTRIBUTES, XMLAGG, ...) can be used in db/400 -- as/400 V6R1M0, if yes, any sample code? of not what else I can use to generate xml content from db2 queries? Any answer is appreciated.

    Jluo1235 pointsBadges:
  • STRPDM and STRDFU Authority in iSeries

    I would like to block all users except the programmers from using either of these commands. I have tried using *Exclude for *Public and it blocks all users with a *USER for user class but does not block the users with a *SYSOPR user class and they are the ones I need to block. Anyone have any...

    Patcoad30 pointsBadges:
  • iSeries object-level security question

    This iSeries user is trying to augment his object-level security with exit programs. He's working on one now to control ODBC using the QIBM_QZDA_SQL2 exit point. His question is: What is the proper authority for an exit program and its log file? All of his users without *ALLOBJ, bypass his exit...

    MichelleDavidson435 pointsBadges:
  • Need help figuring out compile error

    Bob needs help figuring out this error he keeps receiving. He is writing a free-form RPG program, and he needs to use CALLP, prototypes, etc., to call another RPG program, passing parms both ways. The called program is also called by many other legacy programs using CALL. The compile error he gets...

    MichelleDavidson435 pointsBadges:
  • CHKIN Command in iseries

    What is the use of CHKIN command and where do we use this? i have gone through infocenter but couldn't understand ...... "The Check In Object (CHKIN) command checks in an object that had previously been checked out." can anybody explain the use of it?

    qmaster1,675 pointsBadges:
  • iseries ftps connection to unix server

    All, A client is using iSeries/AS400 to ftps to our unix server. About 60 minutes into the transission the client receives a "no response from remote host, closing connection". On our end, the client is idle for 15 minutes and times out, resulting in a closing of the connection to the client. I...

    Mark98760 pointsBadges:
  • Sending iSeries spool files to a network printer

    I have a problem whereby my network printer is printing multiple copies of a spool file I have sent to it - it just keeps churning them out. The printer in question is an OCE' re-branded multi-function printer. I believe it's a VL2822C VarioPrint machine. Has anyone used these to print from an...

    Bristoldoug45 pointsBadges:
  • Simulate a key stroke using CL on an AS/400 system?

    Just currious, but is there a way to simulate a key stroke like the >enter< key within a cl prog on an as400 system?    Thanks.

    lotofbad205 pointsBadges:
  • CL Command definition parameter with Mixed valid values

    Hello, I want to create a command with a parameter same as Stream file code page in CPYTOSTMF. It shoud allow only 1 - 32657, *STMF, *PCASCII, *STDASCII. Can someone explain how could I declare parameter to have this ? Thanks Sim

    sim400305 pointsBadges:
  • Determining Source Files for RPGLE programs.

    How can I retrieve or print non-interactively what source file an RPGLE module was compiled from? I know how to find this information interactively using the DSPPGM command. The DSPOBJD command does not show any value for an RPGLE program.

    Frieseframe0 pointsBadges:
  • Determining source file an RPGLE program was compiled from (created with CRTBNDRPG command).

    How can I retrieve or print non-interactively what source file an RPGLE program (created with CRTBNDRPG command) was compiled from? I know how to find this information interactively using the DSPPGM command. The DSPOBJD command does not show any value for an RPGLE program.

    Frieseframe0 pointsBadges:
  • Retrieving Last 7 days Details in AS/400

    I've a senario, In that i need to extract last 7 days details using query in AS/400. I tried with MAX function. In that it takes MAX(&CURNTDATE) as whole number and subtract. For example i'm subtracting 7 from today's date (1101027 - 7), i got 1101020. If i subtract 40 means i got 1100987. Can...

    Dsaran2007150 pointsBadges:
  • SQL performance vs. Internal pgogram database access

    Is SQL access to a database faster than using the file internally within a program? Assuming that the following: The program was coded to use the keyed index. The SQL statement is coded to use the index that exists on the logical in the most efficient manor.

    Crookedpinkies0 pointsBadges:
  • How to determine password expiration

    Recently this iSeries user wrote in with a question about password expiration. He writes, "How can I tell if a user's password does not expire? I've used the user profile report, but all it gives me for expiration values are 0's or -1's for all of the users." Can you help? Michelle Davidson Editor...

    MichelleDavidson435 pointsBadges:
  • move (or Eval) between record formats

    Isn't it possible to move a database file record format to a different format in one statement? i have tried move, movel, and eval, and still get errors. it seems it should be possible. thanks!

    LFiato200 pointsBadges:
  • journal entry’s entry specific data

    Hi, I am trying to extract fields from security audit events. The problem comes when dealing with entry specific data field. This field contains lot of info which varies according to the entry type. Is there any API which returns information present in the entry specific data portion in a...

    Pprasad1230 pointsBadges:
  • Key Mapping Error when writing records in AS/400

    When i try to write to record, i am getting Key Mapping error.Please let me know if somebody has faced this type of error

    C.naveen09140 pointsBadges:
  • CHGPRTF: AS/400 printer file

    I am changing the width of a printer file width from 132 to 198 using CHGPRTF cmd. Will this work or should i re-compile.

    Mailid5 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