set lang SQL - use redefinitions ?
Joe Boyle
atla38@dsl.pipex.com
Thu, 10 Mar 2005 16:39:27 -0000
This is a multi-part message in MIME format.
------=_NextPart_000_0029_01C5258F.BBC925C0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
I recall what the problem is now. If the lower level redefinition is fewer
bytes that the parent, then, in those cases where the redefined items are
used, the data would be truncated.
This is very annoying when restoring from subfiles.
Regards, Joe.
_____
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Joe Boyle
Sent: 10 March 2005 14:35
To: 'Tim Cummings'; 'PowerHouse List'
Subject: RE: VMS to WINDOWS approach ( set lang SQL - gen database...) ?
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_0029_01C5258F.BBC925C0
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=3DContent-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;
font-family:Arial;
color:navy;}
span.EmailStyle19
{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 recall what the problem is =
now. If
the lower level redefinition is fewer bytes that the parent, then, in =
those
cases where the redefined items are used, the data would be truncated. =
<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'>This is very annoying when =
restoring from
subfiles.<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>Joe Boyle<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> 10 March 2005 =
14:35<br>
<b><span style=3D'font-weight:bold'>To:</span></b> 'Tim Cummings'; =
'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 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_0029_01C5258F.BBC925C0--