Portable Subfile Converter???
Jones Allen (Van)
Allen.Jones@vpgroup.com
Thu, 30 May 2002 12:07:04 -0700
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C2080D.2FC87AA0
Content-Type: text/plain;
charset="iso-8859-1"
Are the Oracle tables already defined? Consider using Powerhouse (QTP)
itself to do this if the Oracle tables are already defined in the database.
Just define the Oracle database in the dictionary, then access the subfiles
and output the Oracle tables. If the subfile items and Oracle column names
are the same, let the item statements default. If they have different
names, then you have to provide the item...final statements but you'd have
to provide similar info to any utility.
OR, you might be able to edit the subfile dictionary files with at text
editor and rename them there before running QTP, then the automatic item
statements will work.
-----Original Message-----
From: Sal Emma [mailto:semma@sysinc.com]
Sent: Thursday, May 30, 2002 11:51 AM
To: powerh-l@lists.swau.edu
Subject: Portable Subfile Converter???
Hello and thank you all for your help. Does anyone know of a commercial
product (or shareware) that will read the mini-dictionary of a portable
subfile and format the data into
columns so that I can export the data to Oracle? Does anyone have a
solution? I have to use portable subfiles to stage the data.
Thanks,
Sal Emma
------_=_NextPart_001_01C2080D.2FC87AA0
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=448485818-30052002><FONT face=Georgia color=#000080>Are the
Oracle tables already defined? Consider using Powerhouse (QTP) itself
to do this if the Oracle tables are already defined in the database. Just
define the Oracle database in the dictionary, then access the subfiles and
output the Oracle tables. If the subfile items and Oracle column names are
the same, let the item statements default. If they have
different names, then you have to provide the item...final statements
but you'd have to provide similar info to any utility.</FONT></SPAN></DIV>
<DIV><SPAN class=448485818-30052002><FONT face=Georgia
color=#000080></FONT></SPAN> </DIV>
<DIV><SPAN class=448485818-30052002><FONT face=Georgia color=#000080>OR,
you might be able to edit the subfile dictionary files with at text editor
and rename them there before running QTP, then the automatic item
statements will work. </FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Sal Emma
[mailto:semma@sysinc.com]<BR><B>Sent:</B> Thursday, May 30, 2002 11:51
AM<BR><B>To:</B> powerh-l@lists.swau.edu<BR><B>Subject:</B> Portable Subfile
Converter???<BR><BR></FONT></DIV>
<DIV><SPAN class=147264618-30052002><FONT face=Arial size=2>Hello and thank
you all for your help. Do</FONT></SPAN><SPAN class=147264618-30052002><FONT
face=Arial size=2>es anyone know of a commercial product (or shareware) that
will read the mini-dictionary of a portable subfile and format the data into
</FONT></SPAN></DIV>
<DIV><SPAN class=147264618-30052002><FONT face=Arial size=2>columns so that I
can export the data to Oracle? Does anyone have a solution? I
have to use portable subfiles to stage the
data. </FONT></SPAN></DIV>
<DIV><SPAN class=147264618-30052002><FONT face=Arial size=2>Thanks,
</FONT></SPAN></DIV>
<DIV><SPAN class=147264618-30052002><FONT face=Arial size=2>Sal
Emma</FONT></SPAN></DIV></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C2080D.2FC87AA0--