• AS/400: ODBC call continues to hang

    My Uncle is using C# .NET ODBC connection to try to retrieve data from an iSeries (AS/400) database. From what he tells me, if the files and procedures are not promoted properly on the iSeries side, ODBC should call a level check error. Unfortunately, it appears the handshake between the ODBC...

    ITKE342,860 pointsBadges:
  • How to replace Regex in iSeries

    How can I use Regex Replace with iSeries? I can see how to match Regex via C++ libraries, but not how to replace it. Any ideas?

    ITKE342,860 pointsBadges:
  • iSeries: Channel transfer problem with NIO file

    One of my good friends has been having trouble with Java NIO code running on iSeries box (JDK 1.5). From what he's told me, the code is splitting a file up into chunks (part of the file to another smaller file). The same code has been operating on other iSeries boxes for some time with no problems....

    ITKE342,860 pointsBadges:
  • I’m trying to connect to AS/400 using .NET

    I'm looking to build a .NET web application using SQL (to query an AS/400 database). This is actually my first time I'm working with AS/400.What do I have to install on my machine in order to connect? Is it IBM iSeries Access for Windows? What are the components of the connection string? Any help...

    ITKE342,860 pointsBadges:
  • Problems with Commitment Control in iSeries

    I'm running an iSeries ILE program and trying to end commitment control with ENDCMTCTL.  Unfortunately, instead of this working correctly, I get the following error message: CPF8355 - ENDCMTCTL not allowed. Pending changes active What is the proper way to do this without simply signing out and...

    ITKE342,860 pointsBadges:
  • Sending IFS attachments via iSeries?

    I need to send an email with an attachment from IFS. Is this possible using an iSeries terminal?

    ITKE342,860 pointsBadges:
  • Development tools for XML and iSeries RPGLE

    I've been recently working on an iSeries to .NET compact framework project. It includes RPGLE programs that are exposed as web services / and a Windows mobile app that uses the web services. Now, each of my iSeries programs have a specific web service wrapper and a .NET app reference. But I'm...

    ITKE342,860 pointsBadges:
  • How do you do LIMIT in DB2 for iSeries?

    We currently have a table of more than 50,000 records and we're trying to return records of 0 to 10,000 / records of 10,000 to 20,000. We already know that in SQL, if you write "LIMIT 0,10000" at the end of the query, it will bring you that record. How can you do it in DB2 for iSeries? Thanks!

    ITKE342,860 pointsBadges:
  • after IPL the server is slow for hours

    I have Iseries , and after it finish count from 1 to 48, a black empty screen stayed for about 30 minutes .. and after it start working the server always become very very slow for about 3 hours ... is there any solution to that

    abar1425 pointsBadges:
  • AS/400 Supress Form feed and Carriage return Characters for spool file

    Does anyone know how to supress form feed and Carriage return charcters in a print file. I am sending a Spool file to a wintel server for data input. When I display the spool file I don't see any of these special characters. However, when the wintel server gets the file, these special characters...

    Eamon6075 pointsBadges:
  • iSeries DB2 searching text filters

    Can someone help me with iSeries DB2 searching text filters?

    manfinson5 pointsBadges:
  • Adding a sato cl608e with internal print server to iSeries

    I created a remote outq, when printing if I release more than 1 spool file only the first one prints and the others disappear.

    Karens6180 pointsBadges:
  • JDE with Robot/Schedule

    Hi All, Our new E1 interface to Robot seems to have created an issue where previous EDI react jobs are not finishing in the OS and so Robot Schedule continues to think they are still running. After looking at the job log for the hung job I noticed it only created a data queue in the ROBOTLIB. I...

    northwoods180 pointsBadges:
  • Regarding SFTP

    I am not a AS/400 programmer but overheard my colleagues and suggested them to use SSH. Greatly appreciated if anyone can suggest here... They have a batch job which creates a text file containing the sftp command passing IP address, username, password and the file to be transferred. I suggested...

    bijunator5 pointsBadges:
  • Email attachments sent from iSeries to webmail on a mobile device

    This question was originally posted in July 2007 and I was wondering if anyone had a solution for it. email attachments sent from the AS/400 via SNDDST to a mobile device arrive with carats (<>) around the file name. (i.e. <test.txt> instead of test.txt). As a result the mobile device...

    lmensah15 pointsBadges:
  • Compile question

    Have you encountered any issues with clients not being able to compile programs once upgraded to V7R1? I have a client who can not compile RPGLE programs. They are on an iSeries and upgraded from V5R4M5 to V7R1M0 Thanks

    expson75 pointsBadges:
  • How to manage SQL queries on iSeries

    We have users who are using SQL to perform queries on our iSeries. As such, we need a way to manage these queries so that, if a runaway, poorly written, etc. causes issues for CPU and/or DASD we can either be notified, end the job, or some other parameter. Is there such an animal? Thanks!

    StarTaylor15 pointsBadges:
  • IS WRKSYSVAL SYSVAL (QMAXSIGN) COMMAND USER SPECIFIC OR GLOBAL

    Actually I need one commen user id to have mutiple attempts for sign on I had tried with below command but it updates globally and not for one user IS WRKSYSVAL SYSVAL (QMAXSIGN) COMMAND USER SPECIFIC OR GLOBAL pls help

    Manojcgupta25 pointsBadges:
  • File is not moving in folder

    Hi, I want to move a file which has a invoice no and create a sub-folder in /hame folder using the invoice number as the folder name. for example: NAMEIN=/home/Indicium/20202021.pdf Nameout=/home/Intellichief/20202021/20202021.pdf PGM PARM(&NAMEIN &NAMEOUT) DCL VAR(&NAMEIN) TYPE(*CHAR)...

    97834441841,355 pointsBadges:
  • AS400 online cobol program that needs to get data dynamically from a vendor systems SQL server database.

    I have a AS400 online cobol program that needs to get data dynamically from a vendor systems SQL server database. Is there a API or some method for doing this. Help.

    Theraven35 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