• Looking to add a column to DB2/400 table

    I'm a beginner with AS/400 and I'm wondering if there's an SQL command on AS/400 to add a column to a table in a specific ordinal position (or moving an existing column to a different position)? Pointing me in the right direction would be great. Thanks!

    ITKE352,380 pointsBadges:
  • 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?

    ITKE352,380 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...

    ITKE352,380 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...

    ITKE352,380 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,...

    ITKE352,380 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...

    ITKE352,380 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 /...

    ITKE352,380 pointsBadges:
  • Local F specs in V5R4

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

    ITKE352,380 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 =...

    ITKE352,380 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...

    ITKE352,380 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...

    ITKE352,380 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?

    ITKE352,380 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...

    ITKE352,380 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?

    ITKE352,380 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...

    ITKE352,380 pointsBadges:
  • Install GIT on AS/400 system running PHP

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

    ITKE352,380 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...

    Zack265 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