• Can I select the identity value from an insert statement?

    Our company is using iSeries for DB2/AS400 and we're hoping someone can help us with this simple question. Would there be a way to return the identity value from an insert statement without using two lines of SQL? We're currently being forced to use inline SQL in C# to perform an insert. Basically,...

    ITKE345,295 pointsBadges:
  • problem installing iseries access

    i can't install iseries access(V5R3M0) on windows 8 enterprise

    fischeprov5 pointsBadges:
  • I need help creating a delimitted string in DB2

    Over the past few days, I've been trying to create a delimited string from the results of a query in DB2 on iSeries. I was able to do it in T-SQL but am struggling here.Here's the code I used in T-SQL. I'm basically looking for the equivalent in DB2.DECLARE @a VARCHAR(1000) SELECT @a = COALESCE(@a...

    ITKE345,295 pointsBadges:
  • RPGLE: Can’t see print to command window

    I'm hoping someone can help me! In my RPGLE program, I currently can't see the DSPLY 'some text' output in the command window. I'm using IBM WebSphere development studio client for iSeries to create a simple RPGLE program. I'm compiling the program with no errors or programs but I can't see the...

    ITKE345,295 pointsBadges:
  • CASE keyword statement in DB2 for IBM iSeries

    I've been recently writing queries for DB2 on an IBM iSeries box. I know about the "CASE" keyword, but it's not working for me. I keep receiving this error message: Keyword CASE not expected. Here's one of my sample code: IF EXISTS ( SELECT * FROM MYTABLE WHERE KEY = xxx ) THEN UPDATE MYTABLE SET...

    ITKE345,295 pointsBadges:
  • How to disable joblog on QZDASOINIT?

    When a webpage makes a ODBC query, it writes to the joblog on QZDASOINIT, but I don't want this to happen as it is flooding the log. Is there a way to disable this? I am working on AS/400 using PHP/PDO via a Linux Centos server, running iSeries

    ITKE345,295 pointsBadges:
  • 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...

    ITKE345,295 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?

    ITKE345,295 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....

    ITKE345,295 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...

    ITKE345,295 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...

    ITKE345,295 pointsBadges:
  • Sending IFS attachments via iSeries?

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

    ITKE345,295 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...

    ITKE345,295 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!

    ITKE345,295 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:

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