• Journal Codes

    Where can I find a list of Journal Codes? Or do you have one to share. I have all these codes like , DL, CO, OP in my journals. I can figure out some of them but i want to know what they all are. Thanks in advance

    RonKoontz1,780 pointsBadges:
  • Check lock before copy

    Could u pls tell me how to check a file is available to copy records in CL

    pwopen12240 pointsBadges:
  • BRMS backup with cleaning tape included

    We have a 3581 tape library. Once a quarter we do a full backup but we'd also like to clean the tape drive. The unit is offsite and managed by a third party as far as unloading and loading tapes is concerned. We thought we could ensure a clean always takes place if we put one in the tape pool to be...

    Pmaddox140 pointsBadges:
  • How to make new QINTER subsystem?

    can anyone tell how make new subsystem Qinter

    Kiong135 pointsBadges:
  • Running Microsoft SQL Server on AS/400

    Anyone out there running Microsoft SQL Server on an AS/400?

    TopKat135 pointsBadges:
  • Convert character field in decimal field.

    hi, everybody i need a help for this: waval = 15A wnval = 15 2 i put in my source this eval wnval = %dec(waval:15:2) but when i run the program stop with error in this line. what i need to do, because i want this example: waval = 123456789012345 wnval = 123456789012345.00 but if i put this: waval =...

    BUG68235 pointsBadges:
  • what is the max length for an sql cursor name?

    what is the max length for an embeded sql cursor name in RPG?

    TheMarkWTaylor5 pointsBadges:
  • AS/400 stored procedure passing parameter

    I have created a stored procedure with an input parameter of type varchar(100). I am using the input variable in the query below select deptid,name , max(location) from emp where empid in (empnos); In which the empnos is the parameter i pass to the procedure and the variable is of type varchar....

    Jacky160 pointsBadges:
  • New Contest: Win 1 of 3 Xbox 360′s

    New Contest: A trio of Xboxes for our top three users Now through the end of April, you can not only show off your IT skills by asking and answering questions on ITKnowledgeExchange.com, but you can earn the chance to spend some quality time honing your bad-guy-vaporizing skills on your very own...

    ITKE344,900 pointsBadges:
  • Print a txt member of a qclsrc file using strseu does not work from Advanced JS

    I want to print, a “txt” file member, from a qclsrc file using strseu, option 6. I have a cl (Ovrprtf & strseu) that accomplishes this interactively, but when I call this cl from an Advanced JS, job I get an error {CPF000,1 error - Error found on STRSEU command,) and it does not print. The...

    Opssvr055 pointsBadges:
  • Using the return value of a SQL Restore script

    I am trying to use the return value of a SQL Restore script executed with SQLCMD, so that my batch script can report on the succes or failure of the restore. I am having difficulty getting the script to return the result of the backup or restore process. Do you have any suggestions? The follwoing...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Printer Output via iSeries Navigator

    how can I know who use printer output via iSeries Nvigator. or can I play with wrkreginf.

    Maltaf65 pointsBadges:
  • Sending report to multiple outqs

    We have a need to send some reports to multiple output queues and have tried to use the SNDNETSPLF solution in Search400 but get an error "User not enrolled in system directory". This response has been encountered by others as there was a link to a discussion group on this in the same web page but...

    FrankStacey105 pointsBadges:
  • How do you change the OUTQ for the QYIVRIPS job?

    The OUTQ for the QYIVRIPS job is the system printer. I get several printouts a week containing the following Java errors: com.ibm.as400.sa.svcsndr.TerminateException: Error starting profile. Excp id: TCP9309 at java.lang.Throwable.<init>(Throwable.java:195) at...

    mshen27,385 pointsBadges:
  • New to Journaling AS/400

    How do you start journaling files that were created long before the journal & receiver were created??

    Maureeno5 pointsBadges:
  • Reading an unknown file in RPG

    Hi All, I am working on a DBU like utility which will provide a maintainance screen for each file. I need to read the file in an rpg program but i dont know the program name till runtime. I can't declare the file in F specs as i dont know the file name. SQL is very bothering and is very heavy for...

    Detuli15 pointsBadges:
  • Auxilliary Storage Pool

    Hi, Can anyone tell me the exact concept behind Auxxiliray Storage Pool? Thanks, Siddharth

    Sangay635 pointsBadges:
  • Setting lower limits In CL

    I know how to declare a file and read through the data in CL....but how can you reset it? Like setll in CL. I have searched and searched but nothing works. I have closed opend...etc.. Any ideas? Example: PGM DCLF FILEA Loop: RCVF FILEA If %EOF ne '0' DO Goto Loop: Enddo. Now I want to read through...

    RonKoontz1,780 pointsBadges:
  • Delete old mail distributions on AS/400

    I have numerous distributions that show on the SAVDLO print out. I am unable to access these via QRYDST and therefore not able to delete them with DLTDST because I can not find the distribution identifier. How can I get these to go away? Where are they stored?

    Boomhower5 pointsBadges:
  • how to avoid problems with the storage AS/400

    Hi, I want to know if you have used the STRWCH command to prevent the CPF0907 (serious storage condition). I'm looking for a way to prevent the operators miss the error message (it is not requesting reply and sometimes they press enter and the message dissapears from the screen). Thank you in...

    Nordan435 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