• How to check IP address of a printer in AS/400?

    How to check IP address of a local and remote printer in AS/400? Are there any specific commands available to check?

    rahsin20 pointsBadges:
  • Query/400 to give Column totals

    Hello, I would like to use Query/400 to provide a particular column total. I have about 6 fields and the final field is Inventory Cost that needs to be totaled in the end in the database file. I know it is easier over SQL, but I would like to know if this is possible.

    yaazhisai260 pointsBadges:
  • Certificate not signed by trusted authority

    We have been been communicating with Twitter from our iSeries. Recently Twitter increased their security and now required a digital certificate. We followed all the setup instructions but get this error on the green screen.  gsk_secure_soc_init() failed with rc = 6000 and errno = 0. 8 rc of 6000...

    WoodEngineer6,955 pointsBadges:
  • Can a system have more than one load source in AS/400?

    What is the number assigned to disk known as load source? Can a system have more than one load source in AS/400?

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

    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:

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.