• How to clear work with DG Activity Entries in a single command

    How do I clear work with DG Activity Entries in a single command. We have a bulk of entries.

    07091988ramya60 pointsBadges:
  • Advantages of database system over file systems

    Does anyone know of the advantages of a database system over file systems. Thanks!

    kabuye5 pointsBadges:
  • How to set proper TCP buffer size?

    Hi, We have 3 AS/400 systems PR, HA (Both are on same physical location) & DR (situated in different physical location around 1000 KM away from PR system). All the three systems are in sync using MIMIX Global. We had 100 mbps WAN link configured for PR to DR replication. PR & HA replication...

    Ketan19305 pointsBadges:
  • AS/400: Remove duplicate rows from table

    I have a table created through Create Table query. Now there are duplicate records in this table. eg:  field1    field2        100      AAAAA 100     BBBBB         200    CCCCC         200    DDDDD         300    EEEEE 400    FFFFF         400    GGGGG. Now, I...

    Supriyoas400220 pointsBadges:
  • QHSMMOVL API in a CLLE program

    I am trying to use QHSMMOVL API in a CLLE program to move libraries between ASP's (1-32) and iASPS(33-256). I keep getting the error CPFB79E -  Auxiliary storage pool does not exist or CPF3C3C Value for parameter not valid. I think it has something to do with the Target auxiliary storage pool...

    Jpjawili75 pointsBadges:
  • Changing variable value in calling RPGLE program

    How do I go about changing a variable value in calling a RPGLE program?

    KeithN25 pointsBadges:
  • Reducing percentage of temporary addresses in WRKSYSSTS

    Hi , Is there is way to reduce  % temp addresses in WRKSYSSTS . Is there will be any system issue if this grows  ?  How we can control it ? Has any one encountred more than 50% of it currently my system is having this status for it . % CPU used . . . . . . . :       25.2 % DB capability ...

    BISHT321245 pointsBadges:
  • How do I get CRTCSVF?

    How would I get CRTCSVF?

    Kittyrock5 pointsBadges:
  • SSL just hanging intermittently

    We recently performed our 7.1 upgrade (from 6.1) on a number of 400's. Since the upgrade, we are having issues with SSL communication over data queues in particular. It seems that the system simply stops sending for no reason (nothing in the logs to explain why). If the job involved in the socket...

    Markus15 pointsBadges:
  • joining what is the diffrences between oracle proprietary join and sql 1999 compliant joins

    what is the diffrences between oracle proprietary join and sql 1999 compliant joins

    Muktioracle50 pointsBadges:
  • SQL/400: Call CL program

    From stored procedure in SQL/400, I want to call the CL program. I have created the wrapper program for calling CL as SQL procedure.(qcmd). How can I pass the param with quotes to CL program? SBMJOB CMD(CALL PGM(abc) PARM('parm1' +'parm2 'prtn1')) JOB(prt1) + USER(braha1)

    Bhusha40 pointsBadges:
  • [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:

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.