Recent content by LearningFox

All were very good but I probably enjoyed Paul the most. To keep this from becoming just a personal correspondance, I would highly recommend RPG World for any level of RPG developer. Not only were the sessions very good but we got to spend time in Q & A and networking with some of the very best...

Were you wearing a Chiefs shirt one day? I thought the conference was very good. I learned quite a bit. How about you? Kyle

Sorry but you missed it this time - it ended today. www.rpgworld.com Kyle

Say hello if you bump into me! Kyle

I'm coming from Richmond, VA. I take it you will be attending? Kyle

Yes, I am. Kyle

Ronze, I did not mean to imply that you not use RPGLE. I was suggesting that you work out the format of your sql statement prior to putting it in your program. Having said that, perhaps I did not fully understand your situation. If you need to retrieve one record at a time from file01 and...

If I understand what you want to do (update file01 from a value found in file02) you don't really need a cursor. Try a single sql statement like this: INSERT INTO FILE01 (MYCHAR) SELECT MYCHAR FROM FILE02 WHERE MYCHAR LIKE 'M%' If you type "strsql" from a command line and type "insert" and...

I'm not sure it would be considered good style but it works fine. I write almost exclusivly in /free now but embedded SQL requires fixed-type specs. Rather than drop in and out of /free, I exsr from /free and place my fixed code in the subroutine. Kyle

If I understand your question to be: Can a subprocedure contain subroutines? Sure; no problem.

I've just recently started passing pointers. Seems to work very well. If this is not familiar to you, there is an excellent tutorial at http://www.scottklement.com/rpg/pointers.html

Copy To Import File (CPYTOIMPF) will allow you to specify a CSV output format.

I on three lists: RPG Midrange WDSc

<code> ***************************************************************** * Program name: EAf20R150 * * Program objective: send email to sale reps for previously faxed * EA Select customer welcome letter * * Creation date...

First thing is that you do not need the f-spec for the PF. Second, when you want to loop through a set of records, you load a cursor ( temporary result set) and then fetch one record at a time from the cusor for your report processing. I will post a short example later.