• How to substring and cast in select where statement on iSeries with RPG free

    Hi. I'm relatively new to free form RPG and I rewrote a program to be RPG free and SQL. I'm having problems with my where clause. I'm trying to substring the second byte on a 2 digit packed field. I've tried to use the CAST statement to convert the packed field to CHAR and then do the SUBSTRING on...

    raynesnf65 pointsBadges:
  • Difference between READE and CHAIN

    Hi, What is difference between CHAIN and READE both reads equal key record? Looping possible do while in both so that both will filter equivalent key records but what is main difference then? Thanks!

    6r1,850 pointsBadges:
  • Can OS/400 change an object’s update date?

    Can OS/400 change an object's update date? I have an audit issue because fields ODSRCD and ODLDAT in a *PGM object appear to be changed, while the application has not changed and we don´t even have the source code.

    GerardoB5 pointsBadges:
  • RPGLE calculation of date

    I had a requirement to calculate a due date based on given date + n number of days. The due date should exclude Saturday and Sunday comes in between the range. Is there any way to achieve this? For eg.  if 15 days add to 6 May, 2016, then the due date should be 27 May, 2016.

    Babs312290 pointsBadges:
  • Working on AS400 for 3 years, please help me with some sources to get job in abroads.

    Hi, I am working on AS400 development for 3 years in INDIA for MNC company. But i didn’t get a chance to travel to Onsite to work closely with clients. Some of my friends who had same experience in AS400 got jobs in US and UK and some other countries through some external sources. Now I don’t...

    ManishAS40015 pointsBadges:
  • Error code CWBCO1048

    I keep getting a CWBCO1048 A firewall or blockage or Time-out occurred trying to connect IBM i. How do I cure this. It seems to happen in only this one branch and not in any others? Thanks Leo

    superbru43115 pointsBadges:
  • Message queue – Break Handling Program

    I should get a break message instead of giving DSPMSG every time, Created message in my lib (TSTMSGQ/TSTLIB) added this in my user prf (TSTPRF). I'm getting completed normally messages whenever a job completes. But every time I should check by giving DSPMSG cmd. Can anyone tell me how to make it...

    Explorer1910240 pointsBadges:
  • Export condition fields in Synon

    Can I export the condition fields in Synon?

    skbrown36635 pointsBadges:
  • Updating using AS/400 Sequel Viewpoint

    I can find and display files on AS/400, how can I edit data, rather a field? is that possible?

    Bigdogg30 pointsBadges:
  • SIBS and AS/400

    Dear All, Could anyone help me distinguish the difference or relation between SIBS (Silverlake Integrated Banking System) and AS/400. Is it a built-in solution of AS/400 or a separate solution? And it's AS/400 is object based design which APP, OS and DB are integrated, how the use access to those...

    srithea355 pointsBadges:
  • Remove Audit and Notify errors in MIMIX

    How to remove the Audit and Notify errors in MIMIX?

    YEMEN50 pointsBadges:
  • Connecting SPSS to AS/400 DB2

    Hi I need to connect SPSS to AS/400 DB2 in order to run queries and get data. I try to connect using iSeries Access ODBC Driver I receive the following error: "Database connection failed. The driver may not be configured properly." I tried to connect to AS/400 from ACCESS and from iSeries Navigator...

    felixb95 pointsBadges:
  • SQLRPGLE with dynamic query

    I have employee1 table with field student_id,name,marks and table with field name, suppose NEHA is present in name field, I have a table with name NEHA. In name table marks,id and subject field is there. I want to fetch subject from name table(neha) where marks >10. I need to write SQLRPGLE...

    nabamita90 pointsBadges:
  • RunRmtCmd doesn’t work with Windows Server 2008

    Hi everybody, I change my windows server from 2003 to 2008 and now my AS/400 CL: RunRmtCmd doesn't work. (Still Hang). Someone can help me please?

    oracleboy974205 pointsBadges:
  • Can you FTP a STMF object?

    Can I FTP a STMF object?

    johnmeno15 pointsBadges:
  • How to setup ZM400 as a local printer in SAP

    I have installed a ZM400 printer on a HP laptop. In Windows it works fine, however in SAP it won't work. How can I configure this in SAP?

    Dirkl15 pointsBadges:
  • DB2 on IBM iSeries AS/400

    How to upgrade the version of DB2 in iSeries AS/400?

    kumarbabu5 pointsBadges:
  • File system block size vs disk block size

    Take that my file system block size is 4k, and my disk block size (physical sector size) is 4k. What happens if my increase file system block size to 64k? Is file system block size actually I/O block size, or is it something else? And what is kernel block size? How does it all impact my reading and...

    Krcevina5 pointsBadges:
  • Can I access data queues from Java application running on iSeries WAS?

    Hello, We have started exploring Web Services developed using RDI and deploying onto iSeries WAS. Does this application run in Server job running under subsystem QWAS**? If the application generated in RDi using PCML, how this WAS Job calls COBOL/RPG? Will it send request to QZRCSRVS job or any...

    sim400375 pointsBadges:
  • Is IBM AS/400 not growing anymore (at all)?

    Did IBM let the AS/400 die? Do you think that CIOs and IT managers that are in charge of an AS/400 system would modernize it? Or for those companies trying to acquire a new  IT system, would they consider implementing a brand new AS/400 for their new system?

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

Thanks! We'll email you when relevant content is added and updated.

Following