• Job Information

    I want to retrieve Job number & user name for a particular job name. I come to know that through 'QUSLJOB'or 'QUSRJOBI' we can retrieve Job number & user name for a given job name.Is it possible ? I tried doing in the system through CL but it retrieves the current job name info running in the...

    Sundaras4005 pointsBadges:
  • What is Copybook in AS/400(RPG)

    Can any one pl explain me with an example what is copybook?.

    Alicsc370 pointsBadges:
  • avoid 1 user from copying member of other user

    Hi, just want what am i supposed to do to that member on one source pf to avoid specific user from copying the member of other user. For practical example, I was log in as user A, then i view the list of objects in library of user B, i have an access to display the source of member BBB but i was...

    Clg08115 pointsBadges:
  • Iseries 5.4 HP Printing.

    We have been replacing our HP printers throughout the organization. I have updated the new IP address within the wrkdevd and updated the driber info. Now when the user prints from the AS/400 it will print portrait instead of landscaped....where should I be looking....this is driving me nuts! THanks

    Rmason345 pointsBadges:
  • Using system() function in RPG IV

    Could someone please tell why this doesn't work? Path = '\SOMENAME. I get a CPF006 ('Errors occurred in command.') The message in the joblog is 'String '\XMLDATA\A' contains a character that is not valid.' D path S 63A Varying D cpfmsg S 7A Import('_EXCP_MSGID') D command S 1024A Varying D system...

    GLinds0125 pointsBadges:
  • Error when trying to drop a table that doesn’t exist in RUNSQLSTM

    If I try and DROP a table that does not exist the RUNSQLSTM will fail. Is it possible to monitor for this in the RUNSQLSTM so it won't fail?

    Gingertosser10 pointsBadges:
  • random value

    i would like to apply a random value into a RPG/400 or RPG/II.But I can't find how to do it in official guide. Is there any expert to help me?

    Eddie.lam5 pointsBadges:
  • AS400 ODCB table link

    When i link tables with a ODBC driver then some table won't give me any records (I link into microsoft access. But I do see the column headings. I the record fields I get: #Name? Is this an AS400 problem, ODCB or Access ?

    Davidfromnetherlands15 pointsBadges:
  • User Files

    How do I copy user rights and access priveleges from one as/400 to another and still have access to both systems?

    Gw325 pointsBadges:
  • AS400 Job Schedule Access

    I am doing an audit on AS400 at our company and I am trying to identify users who have access to add, modify, delete jobs in AS400. I would appreciate if anyone has any suggestion on how we can obtain this information. Last year, we looked at users with access to *JOBSCD object type but after doing...

    Toosunneo70 pointsBadges:
  • finding parameters in as/400 program objects

    how do you find the parameters passed to a program if we dont have source and we have only object and cannot debug it

    TNKR130 pointsBadges:
  • How to view jobs in spool?

    I have tried with owner and pre commands still not able to view. previously i was able to view the jobs in spool.Please advice.

    Swapna110 pointsBadges:
  • XML-INTO and File Lock

    Hi, I want to process an XML file from the IFS using XML-INTO. I want to lock the file so that no one accesses it while it is being processed. I use Open(FileName:O_RdOnly:O_Share_None). This seems to lock the file alright but the XML-INTO will not work while the file is locked. Both the Open and...

    MD99910 pointsBadges:
  • How to Import Data from a .CSV or .XLSX file to an AS400 file?

    I want to import the data of a .CSV or .XLSX file to a AS400 file. How can I accomplish this? Also, the .CSV/.XLSX file has two columns that I would like to keep in the AS400 File. Any inputs would be really appreciated.

    Jorame5 pointsBadges:
  • Problem with copying from IFS to pc.

    I need to copy a savf of a library to my pc. I've saved the library in a savf, run the cpytostmf command to put in on the IFS in a folder off of the root. When I try to drag it to my desktop, I get 'Access denied...' message box.

    Glenninsc10 pointsBadges:
  • Does QCMD write to job log when called from RPG

    If I have an RPGLE program that executes a CL command using a CALLP to to QCMD, will that CL command be written to the job log.  The LOGCLPGM paramaeter is set to *YES, if that matters.

    ElTerrifico620 pointsBadges:
  • AS/400 SQL for two file compare and update

    Need a update in SQL comparing two tables check description and if equal to blank then match keys on master update blank desc. field with master desc field. UPDATE mbmtest01/wbmscur  set spdesc = itdsc  from amflib7/itemasa  where spdesc = ' ' and itnbr = spptno Keyword FROM not expected. Valid...

    nitzinger385 pointsBadges:
  • Clearing the Joural Entries attached for a receiver

    Ex: Run DSPJRN JRN01, and you can see the list of entries of changes. Can someone explain me, how to clear the above list without deleting receiver?

    Kar425 pointsBadges:
  • AS/400 File Sizes

    How do I determine or get a list of the files or ojbjects that are taking up the most space on an AS/400?  

    BreisJ10 pointsBadges:
  • PDF password protected

    How to password protect a PDF file from a non-authorized user when viewed or downloaded from the internet. The content of this PDF file are list of customers and its billing information. These information were extracted from AS400 then downloaded to the pResdesigner software/application to create...

    Jcm03045 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