<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:tahoma, new york, times, serif;font-size:10pt"><DIV>Hi Peter,</DIV>
<DIV> </DIV>
<DIV> Yes, item b is the link item. Interesting solution. I am not familiar with this concept of a non Oracle file being declared as an external table in Oracle. Will have to try it sometime. In this case I will just make the simple change in the QTP to check if the record does not exist (instead of checking for the link-to item being null).</DIV>
<DIV> </DIV>
<DIV>Thanks</DIV>
<DIV> </DIV>
<DIV>Dan</DIV>
<DIV style="FONT-FAMILY: tahoma, new york, times, serif; FONT-SIZE: 10pt"><BR>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"><FONT size=2 face=Tahoma>
<HR SIZE=1>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Peter Bateman <peterbateman808@hotmail.com><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> danhl@rogers.com; PowerHouse List <powerh-l@lists.sowder.com><BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Mon, April 19, 2010 7:26:55 PM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: Initializing when Oracle record does not exist<BR></FONT><BR>
<STYLE><!--
.hmmessage P
{
margin:0px;padding:0px;}
body.hmmessage
{
font-size:10pt;font-family:Verdana;}
--></STYLE>
Hi All:<BR><BR> Is item b the link item ? <BR><BR> I believe QTP is working as described in the manuals. <BR><BR> Some of the later versions of Oracle allow for external tables. <BR> If you have declare file_a to be an external table in Qracle then you can<BR> join file_a to Oracle_file_b.<BR><BR> If you did the the optional join in a cursor and NULLS are allowed in the dictionary <BR> definition then QTP and Quiz should work similarly.<BR><BR> i.e.<BR><BR> Declare XYZ cursor &<BR> for select .... from file_a A left join Oracle_file_b B &<BR> on A.link_item = B.link_item <BR><BR>
Access XYZ<BR><BR>
<HR id=stopSpelling>
Date: Mon, 19 Apr 2010 13:12:31 -0700<BR>From: danhl@rogers.com<BR>Subject: Initializing when Oracle record does not exist<BR>To: powerh-l@lists.sowder.com<BR><BR>
<STYLE>
.ExternalClass DIV
{}
</STYLE>
<DIV style="FONT-FAMILY: tahoma, new york, times, serif; FONT-SIZE: 10pt">
<DIV>Hello,</DIV>
<DIV> </DIV>
<DIV> 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.</DIV>
<DIV> </DIV>
<DIV>eg. </DIV>
<DIV> </DIV>
<DIV>Access file_a link to Oracle_file_b optional</DIV>
<DIV> </DIV>
<DIV>define d_b char*5 = "Null" if b of Oracle_file_b is null</DIV>
<DIV> else b of Oracle_file_b </DIV>
<DIV> </DIV>
<DIV> (I want d_b to be null if b is null, or if the record does not esist)</DIV>
<DIV> </DIV>
<DIV>In Quiz if the record Oracle_file_b does not exist, d_b will be "Null" </DIV>
<DIV> </DIV>
<DIV>In QTP it will be " "</DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>Because of this, I must add a separate condition in QTP either:</DIV>
<DIV> </DIV>
<DIV> ... or record Oracle_file_b does not exist ... or</DIV>
<DIV> ... or b of Oracle_file_b = " "</DIV>
<DIV> </DIV>
<DIV>Thanks</DIV>
<DIV> </DIV>
<DIV>Dan</DIV>
<DIV> </DIV>
<DIV> </DIV></DIV><BR>
<HR>
Live connected. <A href="http://go.microsoft.com/?linkid=9724459" rel=nofollow target=_blank>Get Hotmail & Messenger for mobile.</A> </DIV></DIV></div></body></html>