Initializing when Oracle record does not exist

[DAN H LAMBSHEAD]

After a look at the manuals, I think I will stay with the solution of just adjusting this one QTP program for the case of the record not existing, as that is quite simple. Thanks.

By the way, is anyone aware of any Powerhouse contracts or jobs that may be out there ?

Dan



________________________________
From: Bob Deskin <Bob.Deskin at ca.ibm.com>
To: DAN H LAMBSHEAD <danhl at rogers.com>
Cc: powerh-l at lists.sowder.com; powerh-l-bounces+bob.deskin=ca.ibm.com at lists.sowder.com
Sent: Mon, April 19, 2010 10:15:51 PM
Subject: Re: Initializing when Oracle record does not exist

RTFM guys. Look at the ACCESS OPTIONAL option in the QUIZ and QTP manuals 
(I can only vouch for versions F and G but it's probably been that way for 
all of series 8). QUIZ and QTP do things differently because of what QTP 
does with buffers. However, there's a program parameter you can set to get 
the same behavior as QUIZ.

Bob



From:  DAN H LAMBSHEAD <danhl at rogers.com>
To:    powerh-l at lists.sowder.com
Date:  2010-04-19 04:20 PM
Subject:        Initializing when Oracle record does not exist
Sent by:        powerh-l-bounces+bob.deskin=ca.ibm.com at lists.sowder.com



Hello,

  When linking to an Oracle table where the record does not exist, Quiz 
and QTP seem to handle it differently. Quiz regards the items in the 
missing record to be null while QTP initializes them to  " " or 0 (for 
char or num type) - ie. the old, familiar, non relational db case.

eg. 

Access file_a link to Oracle_file_b optional

define d_b char*5 = "Null" if b of Oracle_file_b is null
                      else    b of Oracle_file_b 

(I want d_b to be null if b is null, or if the record does not esist)

In Quiz if the record Oracle_file_b does not exist, d_b  will be "Null" 

In QTP it will be " "

Does anyone know why ? I would prefer both Quiz and QTP to act the same 
way and for Oracle files not existing, initialize to null.

Because of this, I must add a separate condition in QTP either:

  ... or record Oracle_file_b does not exist ...        or
  ... or b of Oracle_file_b = " "

Thanks

Dan

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: 'subscribe' in message body to 
powerh-l-request at lists.sowder.com
Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to 
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the 
list archive at Google.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20100420/f63cd96e/attachment-0001.htm