• Audit Question – Force user signoff after inactivity

    I am auditing a client and would like to know what setting they should set to have the system log off the user from AS400 after a period of inactivity. Currently, they have setting as QINACTMSGQ = *ENDJOB, but not sure if this would log the user off the system or does it have to be set to *DSCJOB...

    Toosunneo70 pointsBadges:
  • Display Query for OS/400 SQL script

    Is it possible to view the SQL that is generated by a query created in Query for OS/400. I have the query defined as I want it and would now like to give the SQL script to my development team to use in automating reports by accessing the database directly.

    Tomotsk75 pointsBadges:
  • Echo AS400 job log to Display file

    Is there a way or freeware utility to display each line or step of a job to a display file as they execute? Each job would add a new "line" to the display file as it ran so that you would see the last 20 or so job steps on the 5250 screen. I'm using the SNDPGMMGS command but it just shows one line...

    Acithorold5 pointsBadges:
  • What & Why do we use FMTDTA Command?

    I would like to know about Format Data Command in detail. What is the main purpose of this command and in which case shall we use this . Give me clear information . Thanks in Advance. * AddThis Social Bookmark Button

    Chrisjam95 pointsBadges:
  • Looking for info on AS/400 printing

    i am new to as400 and i want to learn printer files ...can any one send me the links where i could find information for rlu

    Rpgile25 pointsBadges:
  • AS/400 auto reply to STRCPYSCN

    How to answer to the message from STRCPYSCN automaticaly insted of user.

    coopjer10 pointsBadges:
  • iSeries print usage

    All of our network printing goes to a Novell print server, and we use a piece of Novell software called iPrint to track that usage. We need to track the iSeries printing that is done on network printers in the same way. We're not even sure that it's possible, but we're not ready to take no for an...

    Bruce Regis20 pointsBadges:
  • DB2/400 field to match an Oracle VARCHAR?

    We are having trouble trying to use a 255 byte key in DB2/400 DDS specs. We use Oracle VARCHAR keys 255 bytes long all the time. How do we specify a DB2/400 key to be like an Oracle VARCHAR? Note: in an Oracle VARCHAR the trailing spaces are compressed out. In a pure 255 DDS field, apparently any...

    Michaelwpeak5 pointsBadges:
  • Compare a field from a file to a column from DB2

    Need to compare a field from a VSAM file to a column from a DB2 table and run through the whole file/table to find differences.

    BobBill10 pointsBadges:
  • What is command we can use for calculate difference between 2 times (like subdur)?

    we can use subdur for calculate the difference between 2 dates. and what's the function code that can use for difference between two times?

    Ccss10 pointsBadges:
  • Locking in AS400

    Good day, I hava a process in as400 system that locks if 2 users enter the application at the same time. I thought that once it is out of System-36 and becomes ILE Cobol, locking would be resolved. I was wrong. This is what it does: 1. File is read and data presented on screen (database file). 2....

    Lenny2113115 pointsBadges:
  • Copy of QPDZDTALOG

    Hi there, Is there a way to automatically generate an additional spool copy of QPDZDTALOG (generated during DFU) similar to SNDNETSPLF without interrupting the original spool or to automatically dump the spool contents to a file without the knowledge of the guy who is using DFU. Have a nice day....

    Usheriff25 pointsBadges:
  • Convert Spool file to DB file

    Hi, I have a spool file which I created by WRKACTJOB (*print).. Is it possible to convert the spool file format to a database file..... What does an OVRPRTF command do ...? Thanks, Yogesh

    Cool400115 pointsBadges:
  • WRKOBJLCK problem – file locking I think

    this is the problem. I run a long job containing updates of 2 files, OCLINE and OCHEAD. The program finishes fine but when I try to get into the file maint programs for these files, a blanks screen comes up. Then I sign off the terminal and sign on again and the maint program works fine. I think it...

    Mikea5 pointsBadges:
  • Writing directly ot iSeries optical drive

    We are creating a file that is being copyied to the IFS using the cpytoimpf command. This is working fine. But the problem is that the file is for a State agency that is requiring that the file be sent on a CD for security instead of emal which would be our normal process. Is it prossible to copy...

    AS400PCFileTransfer16115 pointsBadges:
  • When I call CL by 3 parm. (‘ ‘) change to (‘)

    When I call CL by use 3 parm like this command = CALL PGM(CTLMNUCUP) PARM('MENUA' '1' 'CALL PGMA ('')') In pgm it show Parm3 = 'CALL PGMA (') What the method I can solve? thk u.

    Naveeya5 pointsBadges:
  • How to find out number of members in Source file ?

    Hi All, i want to find out how many number of members are available in one source file. For example i have created one source file (QRPGSRC) in (LIBRARY1) now i want to find how many sources are available in LIBRARY1/QRPGSRC this source in my RPGILE program. Do we have any AS400 command or API to...

    Mohan K695 pointsBadges:
  • Flat file to PF conversion

    Hi, can anybody tell me how to transfer the entire flat files contents to a new Physical file in regular fields format?

    ten20081,150 pointsBadges:
  • field validation in display file and cl

    i created one field in display file, i want accept only chars . how to validate in display file and cl program.

    Geethardi10 pointsBadges:
  • Restrict user to Specify Workstation ID

    Here is the situatiion: We have told users to use only their workstation id range only but some users are not follow instructions and in that case they are using other user workstation id range. Although, system value QLMTDEVSSN is already set as '1' (Limit). By setting up system value we can only...

    abiha6325110 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