• Using SELECT with LIMIT clause on a physical file

    Hi - I'm new to PHP & SQL and wanted to know if you can use mysql SELECT with the LIMIT clause on a iseries physical file in order to do pagination. Thanks for the help.

    jakusza30 pointsBadges:
  • Identifying special characters when creating XML output

    Hi Everyone, I'm in the process of creating xml files (using RPGLE) to send order details to our clients. One requirement is the need to replace (encode) special characters such as < > '"& No problem there, my scan can identify and replace where necessary. The problem arises with characters...

    NeilD450 pointsBadges:
  • RPG/400 Trigger Program

    RPG/400 trigger program was suggested to develop a moving average computation. There's a rule that needs to be followed when posting a record in the computation. One rule is that all credit transactions be first posted in the computation - Is this possible in a trigger program? How could I...

    Elm0215645 pointsBadges:
  • SQL RPGLE – How to override data set data structure at run time

    I currently have an SQL RPGLE routine that receives a SELECT statement as a parameter and then fetches the data set into a data structure based on the file. This only works over a single file as the datastructure is created at compile time and has to be based on filea. I would like to make this...

    NarkedDiver20 pointsBadges:
  • Blackberry access to iSeries

    I am looking for a cheap simple way to access/manage the iSeries via Blackberry device

    Dsmith335 pointsBadges:
  • Tape availability in AS/400

    I have tapes in the library that are "inserted" how do i make them "avaiable" for backup?

    Chaster5 pointsBadges:
  • Database Issues – Trying to prove that something has to be done

    Hello Everyone, I'm currently trying to prove a concept on why we should re-create our old existing PFs into SQL defined tables (Portability, performance, etc.). After taking a look at some files, I noticed an even larger problem that would ruin my chance of proving this concept. Unless some major...

    Dcantwell470 pointsBadges:
  • Partial DST

    What is Partial DST? and how do we do it with out putting system in Manual mode?   AS/400,iSeries

    qmaster1,675 pointsBadges:
  • iSeries spool file to Livelink

    How can i extract an iSeries spool file into Livelink?

    Rickwind15 pointsBadges:
  • Using CTE with Update on the iSeries

    Anyone have examples of using a common table expression with an update of fields in a file?

    Dhascuba15 pointsBadges:
  • get an i-Series *LIBL in a .NET program

    I have a .NET programmer asking how he can get the i-Series *LIBL. Based on how the connection is established we can run under 6 different environments. A production and a test for 3 different locations. These are all running on the same i-Series machine. Any ideas or pointers? I have just started...

    ToddN20009,700 pointsBadges:
  • FTP PUT command adding an extra (carriage return?) character

    I have a physical file on the iSeries which I am sending to a Windows server. When the file gets to the server, an extra line has been added with what is (I think) an end of file or carriage return character. The software that is processing the file on the server doesn't handle this character well....

    Wlakesearcher100 pointsBadges:
  • WRKQRY – V5R4

    Are there any issues concerning an upgrade from V5R2 to V5R4 with regard to WRKQRY?

    ARIZONAJO5 pointsBadges:
  • Special character in a PF

    Hi, Is there any way to know if a file has any carriage return on any of the records? I have a file which is populated bby front end users and sometimes when they copy paste an item it also picks up the carriage return. any way to find out if file is having any of these in iseries

    Rockleadme385 pointsBadges:
  • Can a Display File be used in an RPGLE program running in batch?

    I would like to convert an interactive RPGLE program to run in batch mode and would like to keep from replacing the display file in the batch version. Like the interactive version, the batch version would have to write/update and read each of the 3 subfiles in the display file, but would use no...

    TJA10 pointsBadges:
  • CPTYTOSTMF problem

    I am getting error in cpytostmf command while getting the member to ifs folder which is object is not a file or is a file with attributes not supported by this command. object not copied /QSYS.LIB/LIBRARY.LIB/FILENAME.FILE/MBRNAME.MBR

    Vens20105 pointsBadges:
  • created a test profile with only *JOBCTL authority; unable to type WRKJOBSCDE

    Hi all, I created a test profile with only *JOBCTL authority. I was unable to type command WRKJOBSCDE & ADDJOBSCDE, but I was able to CHGJOBSCDE, DELJOBSCDE & HLDJOBSCDE. Wanted to know what did I set wrongly, please help, thanks. User Profile : TEST User class : *USER Special authority : *JOBCTL...

    Tohtoh10 pointsBadges:
  • subrcp in S/36 environment

    What can I replace "SUBRCP", a non-IBM subroutine that returns cursor position on the screen to a S/36 program, with that will work in System/36 environment? Is there a AS/400 routine (function, or ??) that will work in the System/36 environment on an iSeries AS/400?

    Scyla6060100 pointsBadges:
  • What causes a CPF9076 Internal system error pocessing documents or folders

    We have received this message CPF9076 Internal system error pocessing documents or folders intermittently when copying a document to a folder. I have tried to find out why but have been unsuccessful in my searches. Does anyone have any ideas. Thanks

    JaneS485 pointsBadges:
  • Passing parms to Query400

    Has anyone ever come across a method of passing a parm into a query run - such as a date?

    Abbey120 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