• iSeries Access session won’t connect or even give a status, just remains blank

    We're running V6R1 on our iSeries (AS/400, IBM System i) and using IBM i Access 7.1 (Client Access, iSeries Access) with it. All of our PCs are on Windows 7. Every user has a .ws file that they use for starting sessions with their preferences, and it opens via PCSWS.exe. Today, one user cannot...

    ukcazo5315 pointsBadges:
  • 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...

    Jpjawili60 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:
  • DST & Qsecofr password Reset

    hi, anyone help how to reset the Qsecofr usrprf id & Dst Id if Disabled. thanks kingston

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

    deepakt175 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:
  • Find missing numbers with SQL

    In a large logfile I have records containing the field INVNO (invoice-number). The lowest and highest values are easy to find, BUT it looks like some numbers in between are not there. Anyone got a trick with SQL, which can tell which numbers are missing within the numberrange (step 1) ?

    DanTheDane2,555 pointsBadges:
  • How to unsubscribe

    I am getting ready to Retire from my current employer. I will not be working in this field as I have started a very different and unique business. have looked all around to find out how to unsubscribe but can not easily find out how. If anyone knows how, please let me know.

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