Re: Howto use fields "by name"

[rob@xxxxxxxxx]

Try the STRDBG and an INSERT and see.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





afvaiv <afvaiv@xxxxxxxxxx> 
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
06/11/2004 03:11 PM
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc

Fax to

Subject
Re: Howto use fields "by name"






I'm afraid that's not the case, since ALL sentences are just INSERTs, so
I don't thing an index or view or whatever will do any good to its
performance. Or, maybe, am I wrong?
Antonio

DeLong, Eric escribio':

>Has anyone done any performance tuning on the SQL statement being run?
>Chances are, most of the performance problems can be tied to missing
>indexes, which the SQL query optimizer will report to you if you run the 
job
>in debug mode.  For ODBC connections, there is a check box on the ODBC
>datasource dialog that runs the connection job in debug mode.
>
>Eric DeLong
>Sally Beauty Company
>MIS-Project Manager (BSG)
>940-898-7863 or ext. 1863
>
>
>
>-----Original Message-----
>From: afvaiv [mailto:afvaiv@xxxxxxxxxx]
>Sent: Friday, June 11, 2004 1:43 PM
>To: RPG programming on the AS400 / iSeries
>Subject: Re: Howto use fields "by name"
>
>
>Charles, thanks for your answer.
>I know I could just run the SQL statement. In fact it comes from an ODBC
>connection which is behaving too slow under some circunstances, and we
>got some changes, store it in the IFS as a set of statements, copy them
>to a plain, flat file, in a file, and now I'd like to run them "on the
>fly" directly. If I use dynamic SQL results, I fear, will be as slow (or
>even worse) they were when executed directly under ODBC...
>Any other suggestions?
>Antonio.
>
>CWilt@xxxxxxxxxxxx escribio':
>
> 
>
>>Wouldn't it be easier just to the run the SQL statement?  You could even
>>change the INSERT into an UPDATE if need be.
>>
>>Besides which, I'm pretty sure the answer to you question.  You can't
>> 
>>
>update
> 
>
>>a field given the fieldname stored in a variable (at least in RPG). Look
>> 
>>
>in
> 
>
>>the archives and you should find some discussions along these lines. 
Most
>>will recommend you simple use dynamic SQL.
>>
>>HTH,
>>
>>Charles
>>
>>
>> 
>>
>> 
>>
>>>-----Original Message-----
>>>From: afvaiv [mailto:afvaiv@xxxxxxxxxx]
>>>Sent: Friday, June 11, 2004 8:45 AM
>>>To: RPG400-L
>>>Subject: Howto use fields "by name"
>>>
>>>
>>>Folks,
>>>I don't know if the following can be done or not.
>>>I'm reading a file, whose records contain SQL sentences like
>>>"INSERT INTO xxxxx (fielda, fieldh, fieldx) VALUES ('aaaaa',18,'xyz');
>>>
>>>I want to be able to
>>>- parse that sentence,
>>>- read the field names in a loop, into a variable that will 
>>>contain one 
>>>field name at a time
>>>- read the new values in same loop, into a variable that will contain 
>>>one value at a time
>>>
>>>now comes the question:
>>>
>>>I would have to do a lot of  "case" sentences, or nested 
>>>"if's" so that 
>>>in the end I could either MOVE or EVAL each field to its new 
>>>value. The 
>>>question is: since I will have the field name as the value 
>>>contained in 
>>>a variable called "FieldName",
>>>can I do some kind of   Eval   of the real field to the 
>>>desired value, 
>>>addressing the field by the name contained in FieldName?
>>>
>>>I hope I made it clear enough.
>>>
>>>Any examples or hints?
>>>TIA
>>>
>>>-- 
>>>Antonio Fernandez-Vicenti
>>>afvaiv@xxxxxxxxxx
>>>
>>>
>>>--
>>>This is the RPG programming on the AS400 / iSeries (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.
>>>
>>> 
>>>
>>> 
>>>
>>--
>>This is the RPG programming on the AS400 / iSeries (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.
>>
>>
>> 
>>
>> 
>>
>
> 
>

-- 
Antonio Fernandez-Vicenti
afvaiv@xxxxxxxxxx


--
This is the RPG programming on the AS400 / iSeries (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.