• How do I get CRTCSVF?

    How would I get CRTCSVF?

    Kittyrock5 pointsBadges:
  • Flashcopy in AS/400

    In one of our AS/400 systems, we have heavy loaded data and backup takes so much time more than 11 hours. We like to run backups through flashcopy. On the another system we have clusters and geomirror, just need to confirm if we can set up flashcopy on the same system where geomirroring running so...

    deepakt140 pointsBadges:
  • Batch programming / rename files in a loop

    Hello, I have many files in a folder: Example "SecRp201508_XXXXXXX". This have to be changed to a new month value like "SecRp201509_XXXXXXX". Over a batch program, I can manage to change only the last file in the folder: set nm=1509_ for /r %%i in ("*xls") do set Base=%%~ni set Eins=%Base:~0,7% set...

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

    deepakt140 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:
  • 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.

    rahsin10 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:
  • Advantages of AS/400

    Hi, Please let me know the Advantages of AS/400 when compared to Windows, Unix servers. Regards S.Manjunath

    Accenture130 pointsBadges:
  • Difference between logical join file vs. view

    What is the difference between a Logical Join file and a view in DB2/400?

    RBauer92525 pointsBadges:
  • DSPFD command throws message CPF3061

    I am trying to delete members from a physical file if the member size is reaced. I have written code in CL as below -> dclf file(qtemp/ehutmp) opnid efile create outfile by dspfd-> dspfd file(ehub) type(*mbrlist) output(*outfile) outfile(qtemp/ehutmp) and then read file and delete old member...

    mohit123190 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?

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

Following