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

    ITKE346,080 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:
  • 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:
  • ISeries System Debug Manager

    I have recently started using the ISeries System Debug Manager (I know, finally making the move to RPGLE). I have having trouble setting up the library list for it. We do not use the SYSVAL library lists normally for our users. We have a menu system that controls the users library list outside of...

    Willhud69205 pointsBadges:
  • HP printers

    HI, we have quite a few of HP HP4730MFP color laserjet printers, but we print a specific data(iSeries data stream) which makes the printer crashes . Not sure if it the reason is the iSeries data not being compatible . The WSCST we have set as HP8000R as for all other printers and the Manufacture...

    harisudhan211,005 pointsBadges:
  • Issues with BRMS Network Group

    When you go to BRMS Menu --> Policy Administration --> System Policy --> Change Network Group, you can see all the Boxes connected each other. There are 5 LPARS in total. It shows Network Status INACTIVE on one while the others shows ACTIVE. and receive media info is set to none What steps...

    Sjw915 pointsBadges:
  • STRWCH and CPF0607

    Hi, I want to know if you have used the STRWCH command to prevent the CPF0607 (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:
  • CL/400 program for copying files

    regarding as/400. I need to create a CL program for copying all files from HWMSFMODS(library) to HEXPFMODS(library). we are suppose to clear all data in from files. Please advice...

    Askt265 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