Re: help with tables

In article <bav1q3t26jjt26156j9eh4lpp1ivtot9a0@xxxxxxx>,
Robert <no@xxxxxx> wrote:
On Wed, 30 Jan 2008 10:39:16 +0000 (UTC), docdwarf@xxxxxxxxx () wrote:

In article <15ovp3p40dmvcovmgc3co257gi595dn3ii@xxxxxxx>,
Robert <no@xxxxxx> wrote:
On Tue, 29 Jan 2008 19:05:40 +0000 (UTC), docdwarf@xxxxxxxxx () wrote:

In article <c7sup39sjmh3d0n70m26o05ql6np5igq5r@xxxxxxx>,
Robert <no@xxxxxx> wrote:

[snip]

You are putting words in my keyboard. I did not say anything about the
ANSI standarxd, I
said bulk collect is available in Cobol, it is not a PL/SQL feature.

According to
http://www.oracle.com/technology/oramag/oracle/04-jan/o14tech_plsql.html
'bulk collect' most certainly *is* available in PL/SQL:

--begin quoted text:

BULK COLLECT and FORALL are very helpful, not only in improving
performance but also in simplifying the code you need to write for SQL
operations in PL/SQL.

--end quoted text

... but what would Oracle know about the features of PL/SQL, anyhow?

If you don't like BULK COLLECT syntax, leave it out.

It may be less a matter of what *I* like, Mr Wagner, and more a matter of
what my client has asked me to do in exchange for my wages.

Requests I get depend on who within the client organization is asking.

I try to avoid 'multiple sourcing' at the client level, Mr Wagner, by
referring all requests to the person who signs my time***. I start
gently, with 'Well, I'll have to speak with Mr/s Finkerhabben about
that... the one who signs my time*** gets to tell me what to do and how
to do it, you know the song'...

.... and, if necessary, move to a level of 'Ms/r Oubientot, I'm sorry...
but I do not believe you have the authority to command the use of my time
as a Corporate Resource. Mr/s Zhardnivskov signs my time*** and Mr/s
Zhardnivskov has not told me to deal with this task, let alone what
approach to take towards it. I'll be happy to turn my attentions towards
this matter once I receive explicit instructions from Mr/s Zhardnivskov
and I will be equally happy to put these words in writing to you and cc:
it appropriately. Is there any other way I might be of assistance?'

[snip]

Round five: the client asks me to 'Make it run faster. We think all ya
gotta do is
optimize the database.'

Tell them to use a bulk collect... never mind that it is DB2.

[snip]

I forgot to show him the MAINFRAME WAY:

3100-SEARCH-TABLE2.
D DISPLAY 'IN 3100-SEARCH-TABLE2'.
MOVE WS-CONST-N TO WS-IND1.
PERFORM 5600-LOOK-IN-TABLE2 THRU 5699-LOOK-IN-TABLE2-EXIT
VARYNG WS-COMP-SUB2 FROM WS-CONST-1
BY WS-CONST-1
UNTIL WS-IND1 = WS-CONST-Y
OR WS-COMP-SUB2 > WS-COMP-TABLE2-SIZE
END-PERFORM.

That's similar to a way I have seen things done on mainframes, yes... but
a way that would not pass muster in more than a few shops where I've
worked and would have gotten you laughed out of Prod Implementation
reviews.

I've never seen a Prod Implementation review. I've only seen reviews
BEFORE testing began.
Sounds like you're putting untested rewrites into production.

That might be due to the fact that it is something you admit to being
outside of your experience, Mr Wagner; a Prod Implementation review can
require a programmer to submit test results.


(if 3100- begins in column 8 (as indicated by the debugging line
following it) then the imperatives which follow precede column 12)

My keypunch machine was down.

Try the ISPF editor, Mr Wagner... it's good 1970s technology.

DD

.

Quantcast