midrange.com -- rpg400-l mailing list

Re: UDF returning a Boolean

CRPence — 2012-02-04T12:15:21-06:00

No idea why having to code isTollFree(ANI)=1 would be "worrisome" ;-) No really, I do understand and I believe a boolean data type in SQL would be nice, especially for that scenario. Presumably the data type is still awaiting inclusion in standards.? I checked the CREATE FUNCTION (scalar) and the RETURNS /data-type2/ does not include BOOLEAN as of v7r1; well, at least according to what is supposed to be the full list of each /built-in-type/ available, shown in the CREATE TABLE documentation. So the best I ...

Re: Open Access to be generally available as part of the RPGcompiler

Dave — 2012-02-04T11:11:23-06:00

That look's very interesting, Henrik, but very difficult to read and not clear at all to me. Le 3 février 2012 23:16, Henrik Rützou <hr@xxxxxxxxxxxx> a écrit : A programmer I knew explained project time overruns as an extension of the common 80/20 rule: "The first 80% of the project takes the first 80% of the time. The last 20% takes the other 80% of the time." -- This is the RPG programming on the IBM i / System i (RPG400-L) mailing list -- Regards, Henrik Rützou http://powerEXT.com <http://powerext.com/t;...

Re: AW: Open Access to be generally available as part of the RPG compiler

Henrik Rützou — 2012-02-03T16:32:36-06:00

-- This is the RPG programming on the IBM i / System i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.

Re: AW: Open Access to be generally available as part of the RPG compiler

Scott Klement — 2012-02-03T16:25:45-06:00

Re: Open Access to be generally available as part of the RPGcompiler

Henrik Rützou — 2012-02-03T16:16:27-06:00

A programmer I knew explained project time overruns as an extension of the common 80/20 rule: "The first 80% of the project takes the first 80% of the time. The last 20% takes the other 80% of the time." -- This is the RPG programming on the IBM i / System i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a m...

Re: Open Access to be generally available as part of the RPGcompiler

Vern Hamberg — 2012-02-03T16:11:51-06:00

Re: AW: Open Access to be generally available as part of the RPG compiler

Vern Hamberg — 2012-02-03T16:10:39-06:00

I approach this with a similar stance as UI modernization. Shouldn't we be using SQL to access remote databases instead of native record-level I/O?! Wouldn't that be better. Sure, you could say that there are lots of existing programs out there using native I/O and maybe users want to have them work with SQL Server or Oracle or something without rewriting the code. Okay, I can see that -- but, again, that's a quick-fix, not the ultimate goal. The ultimate goal should be to use SQL. Dieter Bender has alread...

UDF returning a Boolean

Kurt Anderson — 2012-02-03T16:04:48-06:00

Can a UDF return a Boolean value? I am taking my first stab at making a UDF for SQL (after successfully writing my first stored procedure). This function would wrap up a service program procedure that returns an indicator. It looks like I might have to make the return value CHAR and check for '1' to see if the UDF is returning a 'true' value. Since SQL can handle Boolean (e.g. where exists), I was hoping the UDF could return such a value so I wouldn't need the actual SQL to say = '1'. For example: Want to d...

Re: AW: Open Access to be generally available as part of the RPG compiler

Peter Dow — 2012-02-03T15:04:50-06:00

Re: Open Access to be generally available as part of the RPGcompiler

sjl — 2012-02-03T15:04:40-06:00

Re: FW: Open Access to be generally available as part of the RPGcompiler

Henrik Rützou — 2012-02-03T15:01:59-06:00

list -- This is the RPG programming on the IBM i / System i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/rpg400-l or email: RPG400-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/rpg400-l.

Re: FW: Open Access to be generally available as part of the RPGcompiler

Dave — 2012-02-03T14:04:37-06:00

So Henriks' 95% in one month really means 2 years? Le 3 février 2012 19:27, Charles Sallee <csallee@xxxxxxxxxxxxxxx> a écrit :

Re: Open Access to be generally available as part of the RPGcompiler

Douglas Handy — 2012-02-03T13:59:44-06:00

FW: Open Access to be generally available as part of the RPGcompiler

Charles Sallee — 2012-02-03T12:27:27-06:00

LOL Robert - are your initials HR? Seriously, I don't know what "it" is, and I do know that all the times I've said it's SMOP (simply a matter of programming) it's never taken just a short time.

Re: Open Access to be generally available as part of the RPGcompiler

sjl — 2012-02-03T11:46:19-06:00

LOL Robert - are your initials HR? Seriously, I don't know what "it" is, and I do know that all the times I've said it's SMOP (simply a matter of programming) it's never taken just a short time.

Re: AW: AW: Open Access to be generally available as part of the RPG compiler

Vern Hamberg — 2012-02-03T10:22:30-06:00

Hi Vern, Been following this thread with interest, although I'm not yet in a position to be able to discover OAR for myself. What are the difficulties in handling the IO? I thought it was going tobe easier to transform an RPG for use with a browser than with CGIDEV2, for example.

Re: AW: Open Access to be generally available as part of the

Henrik Rützou — 2012-02-03T10:07:04-06:00

Re: AW: Open Access to be generally available as part of the

James Horn — 2012-02-03T09:04:10-06:00

Let me see 1 month * 100 programs + 3 months * 10 programs + 10 months * 1 program. seems those months really add up. :) Especially for 2 developers. Jim message: 6 date: Thu, 2 Feb 2012 22:28:51 +0100 from: Henrik R?tzou <hr@xxxxxxxxxxxx> subject: Re: AW: Open Access to be generally available as part of the RPG compiler "On the other hand... I think Henrik is forgetting that there are millions of already written programs that use the display file paradigm, and that the amount of work needed to refactor all...

Re: Open Access to be generally available as part of the RPGcompiler

Dave — 2012-02-03T03:01:06-06:00

I took it to mean that 95% of his code is comment lines. Le 2 février 2012 23:43, <Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx> a écrit : -snip- years two -- This is the RPG programming on the IBM i / System i (RPG400-L) mailing list list -- Regards, Henrik Rützou http://powerEXT.com <http://powerext.com/> -- This is the RPG programming on the IBM i / System i (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mai...

Re: AW: AW: Open Access to be generally available as part of the RPG compiler

Dave — 2012-02-03T02:36:20-06:00

Le 3 février 2012 08:52, Vern Hamberg <vhamberg@xxxxxxxxxxx> a écrit : Hi Vern, Been following this thread with interest, although I'm not yet in a position to be able to discover OAR for myself. What are the difficulties in handling the IO? I thought it was going tobe easier to transform an RPG for use with a browser than with CGIDEV2, for example.