VMS to WINDOWS approach ( set lang SQL - gen database...) ?
Joe Boyle
atla38@dsl.pipex.com
Thu, 10 Mar 2005 14:34:38 -0000
This is a multi-part message in MIME format.
------=_NextPart_000_0010_01C5257E.4C55B700
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
I'm pretty certain that you will find that qtp works in the same way; which
seems fair enough to me - half the time you'll want the parent definition
and the other half. I believe its called sod's law :-).
Maybe we need a flag to indicate which level definition is required in both
qtp and qshow ?
Regards, Joe.
_____
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Tim Cummings
Sent: 10 March 2005 13:35
To: PowerHouse List
Subject: RE: VMS to WINDOWS approach ( set lang SQL - gen database...) ?
I was just surprised that the set lang sql did not generate the lowest level
items.
If I have a column in Image called FLAGS (4 bytes) and it is defined in the
PH dictionary as redefined by FLAG_A, FLAG-B, FLAG-C, FLAG-D (each, one
byte). I would have expected it to create the columns for FLAG-A ... FLAG-D
not create the column called FLAGS.
Timothy J Cummings
Ridgewood Corporate Center
1000 Summit Drive, Suite 200
Milford, Ohio 45150
tim.cummings@frequencymarketing.com
-----Original Message-----
From: Robert Edis [mailto:robeconsult@sbcglobal.net]
Sent: Wednesday, March 09, 2005 7:32 PM
To: PowerHouse List
Subject: RE: VMS to WINDOWS approach ( set lang SQL - gen database...) ?
Tim
In general RDBMS's do not support nested columns or
arrays in tables. As you are generating SQL script I
assume it will be applied to a RDBMS and therefore
non-compliant schema constructs such as nested columns
will not be output.
Blue
--- Tim Cummings <tim.cummings@frequencymarketing.com>
wrote:
> I tried this on MPE and the only bad thing about it
> is if you have a column
> that is re-defined, it only creates the higher level
> item.
>
> Is there an option to get it to create columns for
> the lower level items?
>
>
> Timothy J Cummings
> Ridgewood Corporate Center
> 1000 Summit Drive, Suite 200
> Milford, Ohio 45150
> tim.cummings@frequencymarketing.com
>
>
> -----Original Message-----
> From: Joe Boyle [mailto:atla38@dsl.pipex.com]
> Sent: Wednesday, March 09, 2005 2:33 PM
> To: powerh-l@lists.sowder.com
> Subject: RE: VMS to WINDOWS approach ( set lang SQL
> - gen database...) ?
>
>
> I have been asked if this approach ( set lang SQL -
> gen database...) should
> work on PH7 on VMS; I then remembered that BobD told
> the list that he tested
> this and his words are pasted below -
>
> Well, this doesn't happen every day. This is a new
> one on me as well.
> I've tried it in 8.40D on OpenVMS and 8.41D on
> Windows. I'll make a bold
> assumption that UNIX works like Windows. On OpenVMS,
> the file created is
> named QSHOSQL.TXT. On UNIX and Windows the file is
> named qshogen.sql.
> The general syntax is...
>
> And if anyone cares, QSHOW on MPE/iX does the same,
> generating a file named
> QSHOSQL. And yes, it generates a table for each
> dataset in an IMAGE
> database.
>
> Regards, Joe.
>
>
> -----Original Message-----
> From: powerh-l-admin@lists.sowder.com
> [mailto:powerh-l-admin@lists.sowder.com] On Behalf
> Of Deskin, Bob
> Sent: 09 March 2005 15:33
> To: powerh-l@lists.sowder.com
> Subject: RE: Anyone have Moved from VMS to WINDOWS?
>
> Our recommendation when migrating from IMAGE/indexed
> to relational is to
> use Axiant. However, there is an undocumented
> feature (no I don't know
> why it's undocumented) of QSHOW that will let you
> generate a skeleton
> SQL table definition.
>
> In QSHOW:
>
> SET LANG SQL
> GENERATE DATABASE <indexed-file>
>
> Yes, I know it's a FILE and not a DATABASE, but you
> have to fool QSHOW
> into thinking it's dealing with relational.
>
> On Windows, this create a file named qshogen.sql
> with the basic table
> definition. If you generate all your files this way
> and put the results
> together, and add the constraints and so on, you can
> come up with a
> fairly complete database schema. It's not as good as
> Axiant but it's a
> start.
>
> Bob
>
> -----Original Message-----
> From: powerh-l-admin@lists.sowder.com
> [mailto:powerh-l-admin@lists.sowder.com] On Behalf
> Of Ken Langendock
> Sent: March 9, 2005 10:18 AM
> To: powerh-l@lists.sowder.com
> Subject: Re: Anyone have Moved from VMS to WINDOWS?
>
>
> I know there have been many conversations flying
> back
> and forth about how to convert from ISAM/KSAM/RMS to
> a database. And
> unless I didn't see the actually "final" message.
> There wasn't a nice
> way of doing this unless you are going Axiant.
>
> Mom always told me to never touched the stuff.
>
> When I converted from ISAM (or all of the above) I
> exported my file definitions in QSHOW to PDL.
>
> Then I started my Search and Replace routine.
> 1) change all the - to _
> 2) change all file names to sql sytax "create..."
> 3) changed all item statements to sql syntax.
> 4) etc.
> 5)....test/retest.
>
> Ken
>
>
> --- Othman <othman2@gmail.com> wrote:
> > how about the database migration.
> >
> > our system running with the following environment
> > -System: HP 3000/968 Rx
> > -OS : MPE / ix HP 31900
> >
> > -Reporting Quiz - Cognos PowerHouse 8.19.C4
> version.
> >
> > -Screen Designing QDESIGN - Cognos PowerHouse
> > 8.19.C4 version.
> >
> > -Transaction Processing QTP - Cognos PowerHouse
> > 8.19.C4 version.
> >
> > -Data Base Dictionary PDL - Cognos PowerHouse
> > 8.19.C4 version.
> >
> > what is the recommended path to migrate to NT ,MS
> > SQL
> >
> > On Wed, 9 Mar 2005 09:44:56 -0500 (EST), Ken
> > Langendock
> > <ken.langendock@rogers.com> wrote:
> > > I'm not sure what you mean by tool.
> > >
> > > I used a free ware search and replace tool that
> I downloaded from
> > > the net to fix the source.
> > >
> > > The last conversion was from DG ISAM to ISAM for
> > NT.
> > > So all I did there was export the file
> definitions
> > > from QSHOW on the UNIX box and cleaned them up
> for
> > NT.
> > >
> > > Most of the time I convert everything by search
> > and
> > > replace then do the rest by hand.
> > >
> > > By using my application as a building block. I
> > > converted a 100 program application within 2
> weeks
> > > (working at night). And that app was written
> back
> > in
> > > the early 80's, it was all crap code.
> > >
> > > Ken
> > >
> > > --- Othman <othman2@gmail.com> wrote:
> > > > what tool did you use for migration
> > > >
> > > >
> > > > On Wed, 9 Mar 2005 08:50:58 -0500 (EST), Ken
> > > > Langendock
> > > > <ken.langendock@rogers.com> wrote:
> > > > > I have converted an application from many
> > machines
> > > > to
> > > > > other lines.
> > > > >
> > > > > I started out on the VAX (in my opinion the
> > best
> > > > > machine still to this day), then to HP3000,
> > then
> > > > UNIX
> > > > > (HP, SUN, IBM, DG, etc) then to Powerhouse
> NT.
> > > > >
> > > > > I created a system management module that
> > takes
> > > > all of
> > > > > the O/S level code away from your
> application.
> > > > This
> > > > > allows me to convert from one platform to
> > another
> > > > > transparently to the User/Application.
> > > > >
>
=== message truncated ===
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@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.
------=_NextPart_000_0010_01C5257E.4C55B700
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:st1=3D"urn:schemas-microsoft-com:office:smarttags" =
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>RE: VMS to WINDOWS approach ( set lang SQL - gen database...) =
?</title>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"PostalCode"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"State"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"City"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"PlaceType"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"PlaceName"/>
<o:SmartTagType =
namespaceuri=3D"urn:schemas-microsoft-com:office:smarttags"
name=3D"place"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dblue>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>I’m pretty certain that you =
will
find that qtp works in the same way; which seems fair enough to me =
– half
the time you’ll want the parent definition and the other =
half… I
believe its called sod’s law </span></font><font size=3D2 =
color=3Dnavy
face=3DWingdings><span =
style=3D'font-size:10.0pt;font-family:Wingdings;color:navy'>J</span></fon=
t><font
size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:Arial;
color:navy'>.<o:p></o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>Maybe we need a flag to indicate =
which
level definition is required in both qtp and qshow =
?<o:p></o:p></span></font></p>
<div>
<p><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:
Arial;color:navy'>Regards, Joe.</span></font><font color=3Dnavy><span
style=3D'color:navy'> <o:p></o:p></span></font></p>
</div>
<div>
<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>
<hr size=3D3 width=3D"100%" align=3Dcenter tabindex=3D-1>
</span></font></div>
<p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font =
size=3D2
face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'>
powerh-l-admin@lists.sowder.com [mailto:powerh-l-admin@lists.sowder.com] =
<b><span
style=3D'font-weight:bold'>On Behalf Of </span></b>Tim Cummings<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> 10 March 2005 =
13:35<br>
<b><span style=3D'font-weight:bold'>To:</span></b> PowerHouse List<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> RE: VMS to =
WINDOWS
approach ( set lang SQL - gen database...) =
?</span></font><o:p></o:p></p>
</div>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>I was
just surprised that the set lang sql did not generate the lowest level
items. </span></font><o:p></o:p></p>
<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>If I have
a column in Image called FLAGS (4 bytes) and it is defined in the PH =
dictionary
as redefined by FLAG_A, FLAG-B, FLAG-C, FLAG-D (each, one byte). I =
would
have expected it to create the columns for FLAG-A ... FLAG-D not create =
the
column called FLAGS.</span></font><o:p></o:p></p>
<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>Timothy J
Cummings</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Ridgewood Corporate =
Center</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>1000 Summit Drive, Suite =
200</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>Milford, Ohio =
45150</span></font>
<br>
<font size=3D2><span =
style=3D'font-size:10.0pt'>tim.cummings@frequencymarketing.com</span></fo=
nt>
<o:p></o:p></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>-----Original
Message-----</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>From: Robert Edis [<a
href=3D"mailto:robeconsult@sbcglobal.net">mailto:robeconsult@sbcglobal.ne=
t</a>]</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>Sent: Wednesday, March =
09, 2005
7:32 PM</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>To: PowerHouse =
List</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Subject: RE: VMS to =
WINDOWS
approach ( set lang SQL - gen database...) ?</span></font> =
<o:p></o:p></p>
<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>Tim</span></font>
<o:p></o:p></p>
<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>In
general RDBMS's do not support nested columns or</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>arrays in tables. =
As you are
generating SQL script I</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>assume it will be =
applied to a
RDBMS and therefore</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>non-compliant schema =
constructs
such as nested columns</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>will not be =
output.</span></font> <o:p></o:p></p>
<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>Blue</span></font>
<o:p></o:p></p>
<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>--- Tim
Cummings <tim.cummings@frequencymarketing.com></span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>wrote:</span></font> =
<o:p></o:p></p>
<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>> I
tried this on MPE and the only bad thing about it</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> is if you have a =
column</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> that is re-defined, =
it only
creates the higher level</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> item.</span></font> =
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Is there an option =
to get it
to create columns for</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> the lower level =
items?</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Timothy J =
Cummings</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> <st1:PlaceName =
w:st=3D"on">Ridgewood</st1:PlaceName>
<st1:PlaceName w:st=3D"on">Corporate</st1:PlaceName> <st1:PlaceType =
w:st=3D"on">Center</st1:PlaceType></span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> 1000 <st1:City =
w:st=3D"on">Summit</st1:City>
Drive, Suite 200</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> <st1:place =
w:st=3D"on"><st1:City
w:st=3D"on">Milford</st1:City>, <st1:State =
w:st=3D"on">Ohio</st1:State> <st1:PostalCode
w:st=3D"on">45150</st1:PostalCode></st1:place></span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>>
tim.cummings@frequencymarketing.com</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> -----Original =
Message-----</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> From: Joe Boyle [<a
href=3D"mailto:atla38@dsl.pipex.com">mailto:atla38@dsl.pipex.com</a>]</sp=
an></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Sent: Wednesday, =
March 09,
2005 2:33 PM</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> To: =
powerh-l@lists.sowder.com</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Subject: RE: VMS to =
WINDOWS
approach ( set lang SQL</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> - gen database...) =
?</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> I have been asked =
if this
approach ( set lang SQL -</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> gen database...) =
should</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> work on PH7 on VMS; =
I then
remembered that BobD told</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> the list that he =
tested</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> this and his words =
are pasted
below -</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Well, this doesn't =
happen
every day. This is a new</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> one on me as =
well.</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> I've tried it in =
8.40D on
OpenVMS and 8.41D on</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Windows. I'll make =
a bold</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> assumption that =
UNIX works like
Windows. On OpenVMS,</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> the file created =
is</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> named QSHOSQL.TXT. =
On UNIX and
Windows the file is</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> named =
qshogen.sql.</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> The general syntax =
is...</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> And if anyone =
cares, QSHOW on
MPE/iX does the same,</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> generating a file =
named</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> QSHOSQL. And yes, =
it generates
a table for each</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> dataset in an =
IMAGE</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> =
database.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Regards, =
Joe.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> -----Original =
Message-----</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> From:
powerh-l-admin@lists.sowder.com</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> [<a
href=3D"mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@lis=
ts.sowder.com</a>]
On Behalf</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Of Deskin, =
Bob</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Sent: 09 March 2005 =
15:33</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> To: =
powerh-l@lists.sowder.com</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Subject: RE: Anyone =
have Moved
from VMS to WINDOWS?</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Our recommendation =
when
migrating from IMAGE/indexed</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> to relational is =
to</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> use Axiant. =
However, there is
an undocumented</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> feature (no I don't =
know</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> why it's =
undocumented) of
QSHOW that will let you</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> generate a =
skeleton</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> SQL table =
definition.</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> In =
QSHOW:</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> SET LANG =
SQL</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> GENERATE DATABASE
<indexed-file></span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Yes, I know it's a =
FILE and
not a DATABASE, but you</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> have to fool =
QSHOW</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> into thinking it's =
dealing
with relational.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> On Windows, this =
create a file
named qshogen.sql</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> with the basic =
table</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> definition. If you =
generate
all your files this way</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> and put the =
results</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> together, and add =
the
constraints and so on, you can</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> come up with =
a</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> fairly complete =
database
schema. It's not as good as</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Axiant but it's =
a</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> =
start.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Bob</span></font> =
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> -----Original =
Message-----</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> From:
powerh-l-admin@lists.sowder.com</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> [<a
href=3D"mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@lis=
ts.sowder.com</a>]
On Behalf</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Of Ken =
Langendock</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Sent: March 9, 2005 =
10:18 AM</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> To: =
powerh-l@lists.sowder.com</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Subject: Re: Anyone =
have Moved
from VMS to WINDOWS?</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> I know there have =
been many
conversations flying</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> back</span></font> =
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> and forth about how =
to convert
from ISAM/KSAM/RMS to</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> a database. =
And</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> unless I didn't see =
the
actually "final" message.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> There wasn't a =
nice</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> way of doing this =
unless you
are going Axiant.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Mom always told me =
to never
touched the stuff.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> When I converted =
from ISAM (or
all of the above) I</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> exported my file =
definitions
in QSHOW to PDL.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Then I started my =
Search and
Replace routine. </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> 1) change all the - =
to _</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> 2) change all file =
names to
sql sytax "create..."</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> 3) changed all item =
statements
to sql syntax.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> 4) =
etc.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> =
5)....test/retest.</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> Ken</span></font> =
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> --- Othman
<othman2@gmail.com> wrote: </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > how about the =
database
migration.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > =
</span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > our system =
running with
the following environment </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> >
-System: HP 3000/968 Rx</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > -OS : MPE / ix =
HP 31900</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > =
</span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > =
-Reporting Quiz -
Cognos PowerHouse 8.19.C4</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> =
version.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > =
</span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > -Screen
Designing QDESIGN - Cognos PowerHouse</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > 8.19.C4 =
version.</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > =
</span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > -Transaction
Processing QTP - Cognos PowerHouse</span></font> =
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > 8.19.C4 =
version.</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > =
</span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > -Data Base
Dictionary PDL - Cognos =
PowerHouse</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > 8.19.C4 =
version.</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > =
</span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > what is the =
recommended
path to migrate to NT ,MS</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > =
SQL</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > =
</span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > On Wed, 9 Mar =
2005
09:44:56 -0500 (EST), Ken</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > =
Langendock</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> >
<ken.langendock@rogers.com> wrote:</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > I'm not =
sure what
you mean by tool.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > =
</span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > I used a =
free ware
search and replace tool that</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> I downloaded from =
</span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > the net =
to fix the
source.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > =
</span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > The last =
conversion
was from DG ISAM to ISAM for</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > =
NT.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > So all I =
did there
was export the file</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> =
definitions</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > from =
QSHOW on the
UNIX box and cleaned them up</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> for</span></font> =
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > =
NT.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > =
</span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > Most of =
the time I
convert everything by search</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > =
and</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > replace =
then do the
rest by hand.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > =
</span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > By using =
my
application as a building block. I</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > converted =
a 100
program application within 2</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> weeks</span></font> =
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > (working =
at night).
And that app was written</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> back</span></font> =
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > =
in</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > the early =
80's, it
was all crap code.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > =
</span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > =
Ken</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > =
</span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > --- =
Othman
<othman2@gmail.com> wrote:</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > > what =
tool did
you use for migration</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > =
></span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > =
></span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > > On =
Wed, 9 Mar
2005 08:50:58 -0500 (EST), Ken</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > > =
Langendock</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > >
<ken.langendock@rogers.com> wrote:</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > > > =
I have
converted an application from many</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > =
machines</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > > =
to</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > > > =
other
lines.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > > =
></span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > > > =
I started
out on the VAX (in my opinion the</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > =
best</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > > > =
machine
still to this day), then to HP3000,</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > =
then</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > > =
UNIX</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > > > =
(HP, SUN,
IBM, DG, etc) then to Powerhouse</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> NT.</span></font> =
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > > =
></span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > > > =
I created
a system management module that</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > =
takes</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > > all =
of</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > > > =
the O/S
level code away from your</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> =
application.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > > =
This</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > > > =
allows me
to convert from one platform to</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > =
another</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > > >
transparently to the User/Application.</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>> > > > =
></span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>> </span></font><br>
<font size=3D2><span style=3D'font-size:10.0pt'>=3D=3D=3D message =
truncated =3D=3D=3D</span></font>
<o:p></o:p></p>
<p><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:10.0pt'>=3D =3D =3D =3D =3D
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Mailing list:
powerh-l@lists.sowder.com</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Subscribe: =
"subscribe" in
message body to powerh-l-request@lists.sowder.com</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Unsubscribe: =
"unsubscribe
<password>" in message body to =
powerh-l-request@lists.sowder.com</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'><a
href=3D"http://lists.sowder.com/mailman/listinfo/powerh-l" =
target=3D"_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</a></=
span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>This list is closed, =
thus to post
to the list you must be a subscriber.</span></font> <o:p></o:p></p>
</div>
</body>
</html>
------=_NextPart_000_0010_01C5257E.4C55B700--