Re: RNF7535: varchar not compatible with options(*varsize)?

Thanks for clarifying Charles - I missed that. But then I am supposed to be on holiday today so that's my excuse ...


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Mar 30, 2018, at 4:49 PM, Charles Wilt <charles.wilt@xxxxxxxxx> wrote:

lol...

I said "No", Jon says "Yes". But we're both right ... just answering
different parts of your question...

Jon's "yes" is for these
"Do I understand correctly that, by specifying %addr(DataToHash:*DATA),
that no data is being copied, but simply the address of that data is passed
to Qc3CalculateHash?"
"If that's the case, I wouldn't need to worry about defining DataToHash as
varchar; just define it as char. Do I have that right?"

My "no" is for this
"The biggest concern was, if I didn't use varchar, I'd always be passing
16MB of data to Qc3CalculateHash. "

Also w.r.t the idea that you have to use %addr(DataToHash:*DATA) to pass
just a pointer. As described in my other post, unless VALUE is specified
you're ALWAYS passing just a pointer.

I second Jon's articles, they would be a big help in understanding..

Charles



On Fri, Mar 30, 2018 at 2:32 PM, Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:

Yes - although varchar may still be a good choice depending on how the
string is built and how else it is used.

For example:

for i = 1 to 1000000;
varchar += %char(i) + ',';
endear;

for i = 1 to 1000000;
char = %trimrR(char) + %char(i) + ',';
endear;

The first case will run in a hundredth (or less) of the time taken by the
second fixed char version.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On Mar 30, 2018, at 2:14 PM, Dan <dan27649@xxxxxxxxx> wrote:

Gentlemen, thanks for all of the replies. I probably won't get back to
this project until next week, but I wanted to acknowledge your
contributions. It's apparent I still have much to learn about this type

of

stuff.

The biggest concern was, if I didn't use varchar, I'd always be passing
16MB of data to Qc3CalculateHash. 95% of the time, the length of the

data

to be hashed won't exceed 100KB, but those outliers kill ya, so I
accommodate the max. Do I understand correctly that, by specifying
%addr(DataToHash:*DATA), that no data is being copied, but simply the
address of that data is passed to Qc3CalculateHash? If that's the case,

I

wouldn't need to worry about defining DataToHash as varchar; just define

it

as char. Do I have that right?

- Dan
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)

mailing list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related

questions.

Help support midrange.com by shopping at amazon.com with our affiliate

link: http://amzn.to/2dEadiD

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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

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

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD