• Creating Objects

    is it possible to create a spool file without creating object? If possible suggess me the steps..

    thambiyannanvignesh50 pointsBadges:
  • Creating an integer in RPGLE

    Looking for a way to create an integer in RPGLE in a way that is similar to the int command in Java. Is there anything like this?

    ITKE54,655 pointsBadges:
  • Locating default library in AS/400 with iSeries

    I'm having trouble figuring out how to boot to the default library while connecting to an AS/400 stored procedure layer using the IBM iSeries Access for Windows package. This set-up works through.NET DLL with classes similar to those in the System.Data namespace, and therefore uses its connect...

    ITKE54,655 pointsBadges:
  • iSeries: Command that accepts object name as parameter

    I've been trying (and trying) to create a new command on iSeries, where the parameter has the same file name using the LIBRARY/FILE MEMBER syntax. Something like this:MYCMD FILE(MYLIB/MYFILE MYMEMBER)Or this:MYCMD FILE(MYLIB/MYFILE) MEMBER(MYMEMBER)I've tried several things including:Create a PARM...

    ITKE54,655 pointsBadges:
  • RPGLE: Conditional Compilation?

    This is more of a general question but I'm wondering if I can include a section of code that's based on whether a variable is defined in my program or is the preprocessor completely not able to access this info (only compilation conditions)? This is what I'm looking for:/IF DEFINED(myVariable) D...

    ITKE54,655 pointsBadges:
  • 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,...

    ITKE54,655 pointsBadges:
  • Locating active procedures in iSeries SQL

    I have a strange problem in iSeries SQL. I'm running a script that fails every time it tries to create a procedure that already exists. The script is quite involved and necessary to complete a number of projects. Is there a way I can determine if specific procedures within the system already exist...

    ITKE54,655 pointsBadges:
  • Trying to call a DB2 stored procedure in IBM System i Access

    I'm trying to test a DB2 stored procedure that's running on an AS/400 system. Our company currently has the IBM System i Access for Windows installed that runs SQL commands against the DB2 database. My big question: What is the syntax to execute a stored procedure that takes in a parameter /...

    ITKE54,655 pointsBadges:
  • Local F specs in V5R4

    How does one simulate local F specs in V5R4 in a SRVPGM procedure?

    ITKE54,655 pointsBadges:
  • Can I convert single characters into integers in RPGLE?

    I'm looking for a way to convert single characters in RPGLE into integers. It would have to work for all inputs and provide a different integer for each input (or at the very least provide a different value for all common inputs). This is a sample code of how I would like it to work:characterData =...

    ITKE54,655 pointsBadges:
  • problem installing iseries access

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

    fischeprov5 pointsBadges:
  • subfiles

    can any one share a link where i can read a example of auto refresh subfiles.... thanks

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

    ITKE54,655 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...

    ITKE54,655 pointsBadges:
  • Remote Java Program for zip codes in RPG

    I'm designing a remote Java program to look up zip codes for RPG running on iSeries V5. Its a web client service running in Websphere. Is there a way I can set this up so that the calls go through RPG instead of having to create another Java program to handle it?

    ITKE54,655 pointsBadges:
  • Are logical files and indexes the same thing?

    My background is certainly in MSSQL and I've asked people at my company if they have created indexes on certain columns. They always says yes but point me to logical files.When I'm using iSeries Navigator, logical files show up under the "Views" category. However, when I click "Indexes", nothing...

    ITKE54,655 pointsBadges:
  • Scheduling join queries in AS/400

    I have an AS/400 join query that runs across 5 tables. I need to get it to run programmatically via scheduled CL scripts. I'm trying to make it work using RUNQRY, but that only shows the query itself, not the results. How can I make this work?

    ITKE54,655 pointsBadges:
  • RPG: INLR statement

    I've recently been looking at some legacy programs, such as the following code:C/free Dow 1=1; SubRoutine(); EndDo; *INLR = *On; /end-freeThe program that I'm questioning is a "server-like" program, where the sub routine handles incoming requests over the network. I feel like the *INLR=*On...

    ITKE54,655 pointsBadges:
  • Install GIT on AS/400 system running PHP

    Is it possible to install GIT on an AS/400 system running PHP?

    ITKE54,655 pointsBadges:
  • AS400 – displaying window in *DS3 screen size over SFL in *DS4 screen size

    I want to be able to display a window with a 24x80 screen size, without removing the background SFL which is displayed with a 27x132 screen size. Haven't been able to do it. I have tried 2 different formats in one display file, using 2 line and position definitions per field (one for DS3 and...

    Zack250 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