• Why does the keyword END is not accepted at the end of a stored proc ?

    Hey guys,  I have thise error in SQL stored proc.  I'm on ISERIES and I use RUNSQLSTM to very my procedure. could you help ?  It's seem I can't put a END at the end! ---------------------     160            AND DUDGCT =...

    FRANKIA5 pointsBadges:
  • Where to find now IBM models and features tables?

    IBM used to have a find web page where you could configure a search process based on processor feature, model, processor characteristic, cpw...and more. But they don't maintain/update/host it anymore? Any idea where to find anything similar and quick, withouth having to call a consultant?

    I40075 pointsBadges:
  • QSH on two differnet iSeries

    Hello Everyone, I'm working with two different iSeries boxes. Using a CL program, I execute a QSH similar to this: STRQSH     CMD(&COMMAND) &COMMAND is a string built inside the CL Program. When I call the CL program on the first box (call it DEV) it runs fine. When I call the CL program on the...

    Dcantwell470 pointsBadges:
  • AS/400 Command Line

    The capabilities of my user profiles are limited via LMTCPB(*YES). But the ERP package which we use (ASW from IBS) needs the command GO to work properly. So I had to set this command free for usage via ALWLMTUSR(*YES). Now of course, my users can enter GO MAIN or GO DATA and do whatever the like....

    IveVerschuren15 pointsBadges:
  • Can I read a Word doc in the IFS in an RPG program?

    I am looking for a way to read the contents of a Word doc in the IFS from an RPG program.  Does anyone know of a way to do this? I have found some articles about using QShell or PASE to read text files, but I am not sure if they will work for Word documents. Any help would be greatly appreciated....

    Joy Stalnecker170 pointsBadges:
  • iSeries Token Error

    Need help with this query - it will not run token error.  Here is the query: SELECT   SUM  ("T16.CTDT".TD_DETAIL_AMT_01 * .10) AS TOTAL, "T16.CPRP".CP_DISTRICT_CODE

    lorit365 pointsBadges:
  • Notes agent accessing attachment from IFS on another iSeries

    I have a domino server running on an iSeries(Ranger). Through a scheduled agent I am trying to put an attachment from a different iSeries (Raven) in a notes document.  I am having difficulties with this.  When the IFS was local (on the same iSeries) it was easy, just point to the directory with...

    Streeter45 pointsBadges:
  • IBM i certifications

    Hi, can anybody plz list out the types of certifications one can do on IBM i including the administration and development. I am experienced over 5 yrs in development and a novice in administration. Hence to move my career ahead and as an administrator too i wanna do some certifications. Plz help me...

    ten20081,150 pointsBadges:
  • sql what is TOSTMF

    In SQL what is TOSTMF for an output file, and how do I use it?

    GlendaBennett15 pointsBadges:
  • website on iSeries not being indexed by web search engines

    Our website is hosted on our iSeries.  It appears that our pages are not being indexed by the various web search engines.  Has anyone encountered this?  Any ideas on where to look/what to check?  We are using our ip address not a DNS name.  All pages are encrypted (https). 

    Chance105 pointsBadges:
  • Tracking data changes on IBM i with triggers

    Hi I like to implemnet this tip can you share the sources files of this tip

    Ecuafruit5 pointsBadges:
  • How to Trace and ODBC job Identity

    how to find by whom the JOB has been submitted through ODBC connection?

    Websphere50 pointsBadges:
  • iseries system management monitor

    Hi, I'm looking for a iseries system management monitor tool. I found one at www.tango04.com, Visual Message Center, but my question is; are there other alternatives available? These monitors can run on Windows or Linux platform, a gui would be nice.

    RainbowSolutions0 pointsBadges:
  • System messages to an OUTQ?

    Does anyone have a method to monitor system operator messages requiring a response via a report sent to an outq? I can't get approval to spend significant dollars for a monitoring system so I am trying to find a way to be alerted via email for any system messages that need to be answered. I have...

    FrankStacey105 pointsBadges:
  • Has anyone connected a Droid to AS400?

    Was thinking of getting updated Blackberry but after playing with my son-in-law's Droid - it is VERY cool. And open. I.E. TN5250, etc.

    DoneThat830 pointsBadges:
  • can i create a directory in a CL with a variable name?

    I am running a job that many people can submit at one time, I am writing files to qtemp and am putting into a directory in the IFS, but I would like to create a directory with the jobnumber as the directory name, then remove it when the job is complete.

    Workingagain5 pointsBadges:
  • iSeries SQL UDF gets CPF426A

    I created a SQL UDF using the iNav wizard.  It created the service program for me yet when I try to use the function I get CPF426A "User-defined function &5 cannot be invoked." with a reason 2 (Either the service program is not found or the program entry point &6 does not exist.)  It says the...

    RJonesPartrick25 pointsBadges:
  • DSPOBJD – Storage Information

    We have a production system and a DR system, we use MIMIX to keep the systems in sync.  If I do a DSPOBJD on a Ile in both systems I get a Different value in the Storage Information : Size field.  The number of records and everything are the same.  Any Ideas ?

    Johnd0155 pointsBadges:
  • How to create iSeries printer file width greater than 378 limit?

    Is it possible to create an iSeries spooled printer file with a width greater than the 378 character limit on the CRTPRTF command? Possibly using an AFP function? The spooled file is intended to be imported into the COMPLEO utility for conversion to EXCEL. There is no need to print the spooled...

    Shuete25 pointsBadges:
  • Delete and Update in Query Magager

    How can I use delete and update statments in Query Manager (QMQ) in OS/400. I can able to create QM Queries for Select Statment but not able to update tables using Delete and Update statment. Please help, a production project in pending for this.

    Abhichavan5 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