• [SQL0029] INTO clause missing from embedded statement.

    HI, I have written lots of RPG/ILE & CL & COBOL programs in iSeries. I never worked on procedures & UDF. Now I'm learning these. I'm trying to create a procedure. This is the code. It's compiled without any errors. While running I got the below error. CREATE FUNCTION SUS.REWT(p_value...

    HABBIE895 pointsBadges:
  • DB restore on iSeries

    Hi, I'm trying some other functionality on AS/400 server as creating some native SQL procedures. Now I completed & I want to take the backup of one schema / library. How to get the backup of this library? Will it be possible through the emulators or do I need to use iSeries navigator? Can...

    HABBIE895 pointsBadges:
  • AS/400 MAPICS

    For MAPICS sitting on an AS/400 box, is access fully restricted at the AS/400 level or can it be fine tuned at the application level as well?

    pbishop356315 pointsBadges:
  • USRPRF last login details

    I need to know how many time a user login in the system. I have tried to audit JRN but cleanup has cleaned all the audit JRN receivers and dSPUSRPRF *all and outfile gives me only last login details. However I'm looking for total number of login details for particular user. Can someone please help...

    deepakt190 pointsBadges:
  • DST password reset

    I want to reset the DST(QSECOFR) password. Who will be having the access to reset and what is the procedure to do it...? I do not know the old password.

    didinu760 pointsBadges:
  • SEQUEL ViewPoint

    We are using SEQUEL View point to execute some queries. We can achieve this using AS400 SQL statments itself. What is advantage of using SEQUEL View point?

    rajeshece1,215 pointsBadges:
  • What is a defective PTF in AS/400

    I can't find the answer from the cover letter. It would be great if someone explains for novice.

    rahsin20 pointsBadges:
  • Vary on pending message on twin ax printer

    We have a twin ax printer which has had the shuttle and ribbon guide replaced. It prints test pages, but shows status of vary on pending when trying to print from spool file. We have varied on/off with printer on, off and even blew away description, then let it auto config; and we still have the...

    Daks190 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;...

    GoranA25 pointsBadges:
  • AS/400 auditing security

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

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

    srithea190 pointsBadges:
  • How do we login to DST from SST in AS/400

    How do we login to DST from SST in AS4/00. It would be great if someone lists all the steps.

    rahsin20 pointsBadges:
  • SSD configuration

    We added SSD disk from SVC to V7R1 partition. Type 2145 is shown, but that's a storage type, instead we have 58B3 type for SSD. Intention is to move specific objects to SSD, but we have to be sure that OS recognize disk correctly as SSD. Any idea? Thank you

    Dhoxha5 pointsBadges:
  • EXTMBR keyword in RPGLE

    Can I use multiple members in EXRMBR keyword in RPGLE? I know we can use one member name in EXTMBR but my question is can we place multiple members name in that apart from *ALL. Can someone please help me here? My requirement is to read 4,6,8 member from my 10 member PF. I know we can create...

    hndajad195 pointsBadges:
  • SAVF in CL programming

    What's SAVF in CL programming?

    mahalakshmi4375 pointsBadges:
  • Command to copy database file to folder in AS/400?

    What's the command to copy a database file to a folder in AS/400?

    Srikanth75 pointsBadges:
  • Help with Excel 2013 macro and Client Access data transfer add-in

    My Client Access data transfer add-in for Excel 2013 stopped working when a macro was created and ran. How do I get the transfer add-in to work again?

    28390010 pointsBadges:
  • Calling RPGLE program from command line with parameters

    How do I pass numeric data to CL program from AS/400 command line?

    harish1990110 pointsBadges:
  • AS/400 5251 display vary on

    A 5251 Display station requires a vary on each time the power switch is turned off and back on? Is this a set up problem?

    JVavitech15 pointsBadges:
  • AS/400: Message queue calls

    What is message queue calls in AS/400?

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