• READC on load all AS/400 subfile

    I have a load all subfile.  Data is entered in a select field, F1 is hit, I go into a routine to READ the Changes on the subfile.  The READC indicator comes on for the first read, thus leaving the routine.  Why?     238       C* READ THE SUBFILE...

    Nickhutcheson165 pointsBadges:
  • how to best handle multiple level breaks for amount totals using ILE

    I'm having a hard time getting my ILE program to read a record from a file in consultant number, order type, order class sequence. It is possible a consultant may have 1 or many order types and needs to break & total some fields on each different order type, and of course break on a different...

    Jinxmom0 pointsBadges:
  • dates in rpg

    Hi! I'm starting to use RPG AS/400, and I'd like to know how to insert date fields in a table using strsql. Can anyone help me, please? Thanks in advance, MelissaG

    MelissaG20 pointsBadges:
  • Print Image File in iSeries

    Hi, I would like to ask for help to use the data type field GRAPHIC in iSeries. Can I save an image file into this field type. If so, how do I do this? I have tried but it always shows an error of character conversion not valid. Please help. Regards, Tony Tam

    Tonytam0 pointsBadges:
  • What can cause a journal entry where JOENTT = ‘CR’ (besides CLRPFM)?

    I have a problem with an interactive option that unintentionally clears an entire physical file - only very occasionally but catastrophically when it does happen. On the last occasion, the file was journalled and indicates the program responsible. The journal entry has type, JOENTT = 'CR'. Nowhere...

    NoHandle0 pointsBadges:
  • Download report from iSeries to PC with proper page break

    I currently use Client Access Ooperations Navigator to download a report to my PC by dragging the output file onto my PC desktop. This correctly produces a report that I can print from my PC but it does not put in the page breaks that existed on the iSeries. Is there a way to keep the same page...

    Acjitk0 pointsBadges:
  • Is an FTP finished?

    If a file is being FTP'ed into a file in the IFS of the iSeries, how can I tell from a CL program when the transfer is complete?

    Dasi4jpm85 pointsBadges:
  • CL and Commands

    I have a CL that calls a command I created and the command references another CL that performs an SQL update to a file and then reruns the command. I'd like display a message (either update successful or error msg) on the bottom of the screen when the command runs again. CL THAT EXECUTES COMMAND:...

    Tmrothen5 pointsBadges:
  • Optional arguments on subprocedures

    The prototype for an API to retrieve the contents of a data area is defined like this: d apirtvdta_ pr 2559 varying d name 10 const d lib 10 const d opt_start 4b 0 const options(*nopass) d opt_length 4b 0 const options(*nopass) The execution is coded as: c eval apirtvdta = apirtvdta_(name:lib) The...

    mygoodname0 pointsBadges:
  • Load All – Using Position To

    Can I use a Position To field in a Load all subfile. I don't want to clear the subfile every time as we do in a single Page subfile. How will the Page up and Page down features be affected if I use a Position to in a Load All subfile? Any help would be appreciated.

    A1b2c3330 pointsBadges:
  • FTP Problem using Zmod

    I have a problem running Zmod GETDBFFTP to retrieve files from a Unix box. Intermittently a character is being dropped from files retrieved. There seems to be no consistency to this. A file/data that has this discrepancy can be retrieved half a dozen times without problem. It is not particular to a...

    Helga520 pointsBadges:
  • Help needed for connect statement using sqlrpg

    Hi All, I need to do some checking in 2 different AS400 servers. I will read the data from one server(say local) then using connect type 2, connect to the other server(say remote), check the data and then returns back to my local server. I'm using sqlrpg for this and created 2 pgms for this. One...

    160780 pointsBadges:
  • IFS Record Count

    How can I retrieve the record count of a .csv file in the IFS? We're at V5R2. I would like a way to do it in either RPGLE or CL, but am open to other suggestions as well.

    Stepheno0 pointsBadges:
  • RPG with Embedded SQL needs journaling

    When I try updating data in a PF via embedded SQL I get a message saying I need to turn journaling on..   *  change dates on a set of records   C/EXEC SQL                             C+ UPDATE ACC02602P                    C+   SET   CSSTR8 =...

    SJSooze15 pointsBadges:
  • Array processing In RPG IV LIE

    Is the aways to dynamicly increase an array before it would overflow. defined as 100 and while processing you need to increas it to say 110 or more. I think that there is aways to do this but I can't remember.

    RPGWIZ130 pointsBadges:
  • Any Python use?

    I know of a port to iSeries from way back. Wondering if there much use? I find that for some tasks, it can be more expressive than RPG. Especially useful if you have an ORM to help with table / SQL generation. Or if you want object orientation.

    Jorjun110 pointsBadges:
  • Passing a Binary Field to an RPGLE Program using CALL

    I need to pass a 9 digit Binary field (4 bytes in length) to an RPGLE program from a non-RPG program. Following shows how I coded in RPGLE. * Parameter Fields d pmbid ds d mbid 9b 0 .. .. c *entry plist c parm pmbid .. .. When the Binary value is passed as the above parameter, the program doesn't...

    Ananda0 pointsBadges:
  • Convert an iso date to julian date

    I'm writing an rpgle pgm and I need to convert an iso date to a julian date. They don't have taatool here. Was wondering if anyone has an example on how to do this? Thanks in advance for any help

    pjshere0 pointsBadges:
  • How can I allow a user to sign off from an AS/400 web application from the browser?

    I have built a simple web application that uses a web front end to an RPG program.  Upon entering the URL the user is forced to enter a valid AS/400 user ID and password - in a similar manner to a password protected directory on a Linux server using Apache - utilizing a pop up window to collect...

    Slypknot5 pointsBadges:
  • Float type parameter containing incorrect value after a callp

    I'm calling a procedure from an rpg pgm(V5R4). It has several parameters with different types. Before calling, they are set to 0 or blanks. After calling, all is coming back with correct value except for 1 float(8f) field. We don't have the source for the procedure however, it's been tested in C...

    kglen0145 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