<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>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.</DIV>
<DIV> </DIV>
<DIV>By the way, is anyone aware of any Powerhouse contracts or jobs that may be out there ?<BR></DIV>
<DIV>Dan</DIV>
<DIV style="FONT-FAMILY: tahoma, new york, times, serif; FONT-SIZE: 10pt"><BR>
<DIV style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 13px"><FONT size=2 face=Tahoma>
<HR SIZE=1>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Bob Deskin <Bob.Deskin@ca.ibm.com><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> DAN H LAMBSHEAD <danhl@rogers.com><BR><B><SPAN style="FONT-WEIGHT: bold">Cc:</SPAN></B> powerh-l@lists.sowder.com; powerh-l-bounces+bob.deskin=ca.ibm.com@lists.sowder.com<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Mon, April 19, 2010 10:15:51 PM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: Initializing when Oracle record does not exist<BR></FONT><BR>RTFM guys. Look at the ACCESS OPTIONAL option in the QUIZ and QTP manuals <BR>(I can only vouch for versions F and G but it's probably been that way for <BR>all of series 8). QUIZ and QTP do things differently because of what QTP <BR>does with buffers. However, there's a program parameter you can set to get <BR>the same behavior as QUIZ.<BR><BR>Bob<BR><BR><BR><BR>From: DAN H LAMBSHEAD <<A href="mailto:danhl@rogers.com"
ymailto="mailto:danhl@rogers.com">danhl@rogers.com</A>><BR>To: <A href="mailto:powerh-l@lists.sowder.com" ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A><BR>Date: 2010-04-19 04:20 PM<BR>Subject: Initializing when Oracle record does not exist<BR>Sent by: powerh-l-bounces+bob.deskin=<A href="mailto:ca.ibm.com@lists.sowder.com" ymailto="mailto:ca.ibm.com@lists.sowder.com">ca.ibm.com@lists.sowder.com</A><BR><BR><BR><BR>Hello,<BR><BR> When linking to an Oracle table where the record does not exist, Quiz <BR>and QTP seem to handle it differently. Quiz regards the items in the <BR>missing record to be null while QTP initializes them to " " or 0 (for <BR>char or num type) - ie. the old, familiar, non relational db case.<BR><BR>eg. <BR><BR>Access file_a link to Oracle_file_b optional<BR><BR>define d_b char*5 = "Null" if b of Oracle_file_b is
null<BR> else b of Oracle_file_b <BR><BR>(I want d_b to be null if b is null, or if the record does not esist)<BR><BR>In Quiz if the record Oracle_file_b does not exist, d_b will be "Null" <BR><BR>In QTP it will be " "<BR><BR>Does anyone know why ? I would prefer both Quiz and QTP to act the same <BR>way and for Oracle files not existing, initialize to null.<BR><BR>Because of this, I must add a separate condition in QTP either:<BR><BR> ... or record Oracle_file_b does not exist ... or<BR> ... or b of Oracle_file_b = " "<BR><BR>Thanks<BR><BR>Dan<BR><BR>-- <BR>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<BR>Mailing list: <A href="mailto:powerh-l@lists.sowder.com" ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A><BR>Subscribe: 'subscribe' in message body to <BR><A
href="mailto:powerh-l-request@lists.sowder.com" ymailto="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</A><BR>Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to <BR><A href="mailto:powerh-l-request@lists.sowder.com" ymailto="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</A><BR><A href="http://lists.sowder.com/mailman/listinfo/powerh-l" target=_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A><BR>This list is closed, thus to post to the list you must be a subscriber.<BR>Add 'site:lists.sowder.com powerh-l' to your search terms to search the <BR>list archive at Google.<BR><BR></DIV></DIV></div></body></html>