VMS to WINDOWS approach ( set lang SQL - gen database...) ?

Guy Werry guy.werry@hbms.ca
Thu, 10 Mar 2005 07:55:06 -0600


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_01C52578.C4495290
Content-Type: text/plain;
	charset="iso-8859-1"

The whole point is that it is SQL/RDBMS that do not support the
re-definition.  Powerhouse is just following the rules of the underlying
platform.
 
Guy L. Werry
Senior Systems Analyst
Hudson Bay Mining & Smelting Co., Limited. 

-----Original Message-----
From: Tim Cummings [mailto:tim.cummings@frequencymarketing.com]
Sent: Thursday, March 10, 2005 7:35 AM
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
<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
<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
<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
<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
<http://lists.sowder.com/mailman/listinfo/powerh-l>  
This list is closed, thus to post to the list you must be a subscriber. 


------_=_NextPart_001_01C52578.C4495290
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>RE: VMS to WINDOWS approach ( set lang SQL - gen database...) ?</TITLE>

<META content="MSHTML 6.00.2800.1400" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=640045313-10032005>The 
whole point is that it is SQL/RDBMS that do not support the re-definition.&nbsp; 
Powerhouse is just following the rules of the underlying 
platform.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN 
class=640045313-10032005></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=640045313-10032005>
<P><FONT size=2>Guy L. Werry<BR>Senior Systems Analyst<BR>Hudson Bay Mining 
&amp; Smelting Co., Limited. </FONT></P></SPAN></FONT></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> Tim Cummings 
  [mailto:tim.cummings@frequencymarketing.com]<BR><B>Sent:</B> Thursday, March 
  10, 2005 7:35 AM<BR><B>To:</B> PowerHouse List<BR><B>Subject:</B> RE: VMS to 
  WINDOWS approach ( set lang SQL - gen database...) ?<BR><BR></FONT></DIV>
  <P><FONT size=2>I was just surprised that the set lang sql did not generate 
  the lowest level items.&nbsp; </FONT></P>
  <P><FONT size=2>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).&nbsp; I would have expected it to create the columns for 
  FLAG-A ... FLAG-D not create the column called FLAGS.</FONT></P>
  <P><FONT size=2>Timothy J Cummings</FONT> <BR><FONT size=2>Ridgewood Corporate 
  Center</FONT> <BR><FONT size=2>1000 Summit Drive, Suite 200</FONT> <BR><FONT 
  size=2>Milford, Ohio&nbsp; 45150</FONT> <BR><FONT 
  size=2>tim.cummings@frequencymarketing.com</FONT> </P><BR>
  <P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From: 
  Robert Edis [<A 
  href="mailto:robeconsult@sbcglobal.net">mailto:robeconsult@sbcglobal.net</A>]</FONT> 
  <BR><FONT size=2>Sent: Wednesday, March 09, 2005 7:32 PM</FONT> <BR><FONT 
  size=2>To: PowerHouse List</FONT> <BR><FONT size=2>Subject: RE: VMS to WINDOWS 
  approach ( set lang SQL - gen database...) ?</FONT> </P><BR>
  <P><FONT size=2>Tim</FONT> </P>
  <P><FONT size=2>In general RDBMS's do not support nested columns or</FONT> 
  <BR><FONT size=2>arrays in tables.&nbsp; As you are generating SQL script 
  I</FONT> <BR><FONT size=2>assume it will be applied to a RDBMS and 
  therefore</FONT> <BR><FONT size=2>non-compliant schema constructs such as 
  nested columns</FONT> <BR><FONT size=2>will not be output.</FONT> </P>
  <P><FONT size=2>Blue</FONT> </P>
  <P><FONT size=2>--- Tim Cummings 
  &lt;tim.cummings@frequencymarketing.com&gt;</FONT> <BR><FONT 
  size=2>wrote:</FONT> </P>
  <P><FONT size=2>&gt; I tried this on MPE and the only bad thing about 
  it</FONT> <BR><FONT size=2>&gt; is if you have a column</FONT> <BR><FONT 
  size=2>&gt; that is re-defined, it only creates the higher level</FONT> 
  <BR><FONT size=2>&gt; item.</FONT> <BR><FONT size=2>&gt; </FONT><BR><FONT 
  size=2>&gt; Is there an option to get it to create columns for</FONT> 
  <BR><FONT size=2>&gt; the lower level items?</FONT> <BR><FONT size=2>&gt; 
  </FONT><BR><FONT size=2>&gt; </FONT><BR><FONT size=2>&gt; Timothy J 
  Cummings</FONT> <BR><FONT size=2>&gt; Ridgewood Corporate Center</FONT> 
  <BR><FONT size=2>&gt; 1000 Summit Drive, Suite 200</FONT> <BR><FONT 
  size=2>&gt; Milford, Ohio&nbsp; 45150</FONT> <BR><FONT size=2>&gt; 
  tim.cummings@frequencymarketing.com</FONT> <BR><FONT size=2>&gt; 
  </FONT><BR><FONT size=2>&gt; </FONT><BR><FONT size=2>&gt; -----Original 
  Message-----</FONT> <BR><FONT size=2>&gt; From: Joe Boyle [<A 
  href="mailto:atla38@dsl.pipex.com">mailto:atla38@dsl.pipex.com</A>]</FONT> 
  <BR><FONT size=2>&gt; Sent: Wednesday, March 09, 2005 2:33 PM</FONT> <BR><FONT 
  size=2>&gt; To: powerh-l@lists.sowder.com</FONT> <BR><FONT size=2>&gt; 
  Subject: RE: VMS to WINDOWS approach ( set lang SQL</FONT> <BR><FONT 
  size=2>&gt; - gen database...) ?</FONT> <BR><FONT size=2>&gt; </FONT><BR><FONT 
  size=2>&gt; </FONT><BR><FONT size=2>&gt; I have been asked if this approach ( 
  set lang SQL -</FONT> <BR><FONT size=2>&gt; gen database...) should</FONT> 
  <BR><FONT size=2>&gt; work on PH7 on VMS; I then remembered that BobD 
  told</FONT> <BR><FONT size=2>&gt; the list that he tested</FONT> <BR><FONT 
  size=2>&gt; this and his words are pasted below -</FONT> <BR><FONT size=2>&gt; 
  </FONT><BR><FONT size=2>&gt; Well, this doesn't happen every day. This is a 
  new</FONT> <BR><FONT size=2>&gt; one on me as well.</FONT> <BR><FONT 
  size=2>&gt; I've tried it in 8.40D on OpenVMS and 8.41D on</FONT> <BR><FONT 
  size=2>&gt; Windows. I'll make a bold</FONT> <BR><FONT size=2>&gt; assumption 
  that UNIX works like Windows. On OpenVMS,</FONT> <BR><FONT size=2>&gt; the 
  file created is</FONT> <BR><FONT size=2>&gt; named QSHOSQL.TXT. On UNIX and 
  Windows the file is</FONT> <BR><FONT size=2>&gt; named qshogen.sql.</FONT> 
  <BR><FONT size=2>&gt; The general syntax is...</FONT> <BR><FONT size=2>&gt; 
  </FONT><BR><FONT size=2>&gt; And if anyone cares, QSHOW on MPE/iX does the 
  same,</FONT> <BR><FONT size=2>&gt; generating a file named</FONT> <BR><FONT 
  size=2>&gt; QSHOSQL. And yes, it generates a table for each</FONT> <BR><FONT 
  size=2>&gt; dataset in an IMAGE</FONT> <BR><FONT size=2>&gt; database.</FONT> 
  <BR><FONT size=2>&gt; </FONT><BR><FONT size=2>&gt; Regards, Joe.</FONT> 
  <BR><FONT size=2>&gt; </FONT><BR><FONT size=2>&gt; </FONT><BR><FONT 
  size=2>&gt; -----Original Message-----</FONT> <BR><FONT size=2>&gt; From: 
  powerh-l-admin@lists.sowder.com</FONT> <BR><FONT size=2>&gt; [<A 
  href="mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@lists.sowder.com</A>] 
  On Behalf</FONT> <BR><FONT size=2>&gt; Of Deskin, Bob</FONT> <BR><FONT 
  size=2>&gt; Sent: 09 March 2005 15:33</FONT> <BR><FONT size=2>&gt; To: 
  powerh-l@lists.sowder.com</FONT> <BR><FONT size=2>&gt; Subject: RE: Anyone 
  have Moved from VMS to WINDOWS?</FONT> <BR><FONT size=2>&gt; </FONT><BR><FONT 
  size=2>&gt; Our recommendation when migrating from IMAGE/indexed</FONT> 
  <BR><FONT size=2>&gt; to relational is to</FONT> <BR><FONT size=2>&gt; use 
  Axiant. However, there is an undocumented</FONT> <BR><FONT size=2>&gt; feature 
  (no I don't know</FONT> <BR><FONT size=2>&gt; why it's undocumented) of QSHOW 
  that will let you</FONT> <BR><FONT size=2>&gt; generate a skeleton</FONT> 
  <BR><FONT size=2>&gt; SQL table definition.</FONT> <BR><FONT size=2>&gt; 
  </FONT><BR><FONT size=2>&gt; In QSHOW:</FONT> <BR><FONT size=2>&gt; 
  </FONT><BR><FONT size=2>&gt; SET LANG SQL</FONT> <BR><FONT size=2>&gt; 
  GENERATE DATABASE &lt;indexed-file&gt;</FONT> <BR><FONT size=2>&gt; 
  </FONT><BR><FONT size=2>&gt; Yes, I know it's a FILE and not a DATABASE, but 
  you</FONT> <BR><FONT size=2>&gt; have to fool QSHOW</FONT> <BR><FONT 
  size=2>&gt; into thinking it's dealing with relational.</FONT> <BR><FONT 
  size=2>&gt; </FONT><BR><FONT size=2>&gt; On Windows, this create a file named 
  qshogen.sql</FONT> <BR><FONT size=2>&gt; with the basic table</FONT> <BR><FONT 
  size=2>&gt; definition. If you generate all your files this way</FONT> 
  <BR><FONT size=2>&gt; and put the results</FONT> <BR><FONT size=2>&gt; 
  together, and add the constraints and so on, you can</FONT> <BR><FONT 
  size=2>&gt; come up with a</FONT> <BR><FONT size=2>&gt; fairly complete 
  database schema. It's not as good as</FONT> <BR><FONT size=2>&gt; Axiant but 
  it's a</FONT> <BR><FONT size=2>&gt; start.</FONT> <BR><FONT size=2>&gt; 
  </FONT><BR><FONT size=2>&gt; Bob</FONT> <BR><FONT size=2>&gt; </FONT><BR><FONT 
  size=2>&gt; -----Original Message-----</FONT> <BR><FONT size=2>&gt; From: 
  powerh-l-admin@lists.sowder.com</FONT> <BR><FONT size=2>&gt; [<A 
  href="mailto:powerh-l-admin@lists.sowder.com">mailto:powerh-l-admin@lists.sowder.com</A>] 
  On Behalf</FONT> <BR><FONT size=2>&gt; Of Ken Langendock</FONT> <BR><FONT 
  size=2>&gt; Sent: March 9, 2005 10:18 AM</FONT> <BR><FONT size=2>&gt; To: 
  powerh-l@lists.sowder.com</FONT> <BR><FONT size=2>&gt; Subject: Re: Anyone 
  have Moved from VMS to WINDOWS?</FONT> <BR><FONT size=2>&gt; </FONT><BR><FONT 
  size=2>&gt; </FONT><BR><FONT size=2>&gt; I know there have been many 
  conversations flying</FONT> <BR><FONT size=2>&gt; back</FONT> <BR><FONT 
  size=2>&gt; and forth about how to convert from ISAM/KSAM/RMS to</FONT> 
  <BR><FONT size=2>&gt; a database. And</FONT> <BR><FONT size=2>&gt; unless I 
  didn't see the actually "final" message.</FONT> <BR><FONT size=2>&gt; There 
  wasn't a nice</FONT> <BR><FONT size=2>&gt; way of doing this unless you are 
  going Axiant.</FONT> <BR><FONT size=2>&gt; </FONT><BR><FONT size=2>&gt; Mom 
  always told me to never touched the stuff.</FONT> <BR><FONT size=2>&gt; 
  </FONT><BR><FONT size=2>&gt; When I converted from ISAM (or all of the above) 
  I</FONT> <BR><FONT size=2>&gt; exported my file definitions in QSHOW to 
  PDL.</FONT> <BR><FONT size=2>&gt; </FONT><BR><FONT size=2>&gt; Then I started 
  my Search and Replace routine. </FONT><BR><FONT size=2>&gt; 1) change all the 
  - to _</FONT> <BR><FONT size=2>&gt; 2) change all file names to sql sytax 
  "create..."</FONT> <BR><FONT size=2>&gt; 3) changed all item statements to sql 
  syntax.</FONT> <BR><FONT size=2>&gt; 4) etc.</FONT> <BR><FONT size=2>&gt; 
  5)....test/retest.</FONT> <BR><FONT size=2>&gt; </FONT><BR><FONT size=2>&gt; 
  Ken</FONT> <BR><FONT size=2>&gt; </FONT><BR><FONT size=2>&gt; </FONT><BR><FONT 
  size=2>&gt;&nbsp; --- Othman &lt;othman2@gmail.com&gt; wrote: </FONT><BR><FONT 
  size=2>&gt; &gt; how about the database migration.</FONT> <BR><FONT 
  size=2>&gt; &gt; </FONT><BR><FONT size=2>&gt; &gt; our system running with the 
  following environment </FONT><BR><FONT size=2>&gt; &gt; 
  -System:&nbsp;&nbsp;&nbsp; HP 3000/968 Rx</FONT> <BR><FONT size=2>&gt; &gt; 
  -OS : MPE / ix HP 31900</FONT> <BR><FONT size=2>&gt; &gt; &nbsp;&nbsp;&nbsp; 
  </FONT><BR><FONT size=2>&gt; &gt; -Reporting&nbsp; Quiz - Cognos PowerHouse 
  8.19.C4</FONT> <BR><FONT size=2>&gt; version.</FONT> <BR><FONT size=2>&gt; 
  &gt; &nbsp;&nbsp;&nbsp; </FONT><BR><FONT size=2>&gt; &gt; -Screen 
  Designing&nbsp;&nbsp; QDESIGN - Cognos PowerHouse</FONT> <BR><FONT size=2>&gt; 
  &gt; 8.19.C4 version.</FONT> <BR><FONT size=2>&gt; &gt; &nbsp;&nbsp;&nbsp; 
  </FONT><BR><FONT size=2>&gt; &gt; -Transaction 
  Processing&nbsp;&nbsp;&nbsp;&nbsp; QTP - Cognos PowerHouse</FONT> <BR><FONT 
  size=2>&gt; &gt; 8.19.C4 version.</FONT> <BR><FONT size=2>&gt; &gt; 
  &nbsp;&nbsp;&nbsp; </FONT><BR><FONT size=2>&gt; &gt; -Data Base 
  Dictionary&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PDL - Cognos PowerHouse</FONT> 
  <BR><FONT size=2>&gt; &gt; 8.19.C4 version.</FONT> <BR><FONT size=2>&gt; &gt; 
  </FONT><BR><FONT size=2>&gt; &gt; what is the recommended path to migrate to 
  NT ,MS</FONT> <BR><FONT size=2>&gt; &gt; SQL</FONT> <BR><FONT size=2>&gt; &gt; 
  </FONT><BR><FONT size=2>&gt; &gt; On Wed, 9 Mar 2005 09:44:56 -0500 (EST), 
  Ken</FONT> <BR><FONT size=2>&gt; &gt; Langendock</FONT> <BR><FONT size=2>&gt; 
  &gt; &lt;ken.langendock@rogers.com&gt; wrote:</FONT> <BR><FONT size=2>&gt; 
  &gt; &gt; I'm not sure what you mean by tool.</FONT> <BR><FONT size=2>&gt; 
  &gt; &gt; </FONT><BR><FONT size=2>&gt; &gt; &gt; I used a free ware search and 
  replace tool that</FONT> <BR><FONT size=2>&gt; I downloaded from 
  </FONT><BR><FONT size=2>&gt; &gt; &gt; the net to fix the source.</FONT> 
  <BR><FONT size=2>&gt; &gt; &gt; </FONT><BR><FONT size=2>&gt; &gt; &gt; The 
  last conversion was from DG ISAM to ISAM for</FONT> <BR><FONT size=2>&gt; &gt; 
  NT.</FONT> <BR><FONT size=2>&gt; &gt; &gt; So all I did there was export the 
  file</FONT> <BR><FONT size=2>&gt; definitions</FONT> <BR><FONT size=2>&gt; 
  &gt; &gt; from QSHOW on the UNIX box and cleaned them up</FONT> <BR><FONT 
  size=2>&gt; for</FONT> <BR><FONT size=2>&gt; &gt; NT.</FONT> <BR><FONT 
  size=2>&gt; &gt; &gt; </FONT><BR><FONT size=2>&gt; &gt; &gt; Most of the time 
  I convert everything by search</FONT> <BR><FONT size=2>&gt; &gt; and</FONT> 
  <BR><FONT size=2>&gt; &gt; &gt; replace then do the rest by hand.</FONT> 
  <BR><FONT size=2>&gt; &gt; &gt; </FONT><BR><FONT size=2>&gt; &gt; &gt; By 
  using my application as a building block. I</FONT> <BR><FONT size=2>&gt; &gt; 
  &gt; converted a 100 program application within 2</FONT> <BR><FONT size=2>&gt; 
  weeks</FONT> <BR><FONT size=2>&gt; &gt; &gt; (working at night). And that app 
  was written</FONT> <BR><FONT size=2>&gt; back</FONT> <BR><FONT size=2>&gt; 
  &gt; in</FONT> <BR><FONT size=2>&gt; &gt; &gt; the early 80's, it was all crap 
  code.</FONT> <BR><FONT size=2>&gt; &gt; &gt; </FONT><BR><FONT size=2>&gt; &gt; 
  &gt; Ken</FONT> <BR><FONT size=2>&gt; &gt; &gt; </FONT><BR><FONT size=2>&gt; 
  &gt; &gt; --- Othman &lt;othman2@gmail.com&gt; wrote:</FONT> <BR><FONT 
  size=2>&gt; &gt; &gt; &gt; what tool did you use for migration</FONT> 
  <BR><FONT size=2>&gt; &gt; &gt; &gt;</FONT> <BR><FONT size=2>&gt; &gt; &gt; 
  &gt;</FONT> <BR><FONT size=2>&gt; &gt; &gt; &gt; On Wed, 9 Mar 2005 08:50:58 
  -0500 (EST), Ken</FONT> <BR><FONT size=2>&gt; &gt; &gt; &gt; Langendock</FONT> 
  <BR><FONT size=2>&gt; &gt; &gt; &gt; &lt;ken.langendock@rogers.com&gt; 
  wrote:</FONT> <BR><FONT size=2>&gt; &gt; &gt; &gt; &gt; I have converted an 
  application from many</FONT> <BR><FONT size=2>&gt; &gt; machines</FONT> 
  <BR><FONT size=2>&gt; &gt; &gt; &gt; to</FONT> <BR><FONT size=2>&gt; &gt; &gt; 
  &gt; &gt; other lines.</FONT> <BR><FONT size=2>&gt; &gt; &gt; &gt; &gt;</FONT> 
  <BR><FONT size=2>&gt; &gt; &gt; &gt; &gt; I started out on the VAX (in my 
  opinion the</FONT> <BR><FONT size=2>&gt; &gt; best</FONT> <BR><FONT 
  size=2>&gt; &gt; &gt; &gt; &gt; machine still to this day), then to 
  HP3000,</FONT> <BR><FONT size=2>&gt; &gt; then</FONT> <BR><FONT size=2>&gt; 
  &gt; &gt; &gt; UNIX</FONT> <BR><FONT size=2>&gt; &gt; &gt; &gt; &gt; (HP, SUN, 
  IBM, DG, etc) then to Powerhouse</FONT> <BR><FONT size=2>&gt; NT.</FONT> 
  <BR><FONT size=2>&gt; &gt; &gt; &gt; &gt;</FONT> <BR><FONT size=2>&gt; &gt; 
  &gt; &gt; &gt; I created a system management module that</FONT> <BR><FONT 
  size=2>&gt; &gt; takes</FONT> <BR><FONT size=2>&gt; &gt; &gt; &gt; all 
  of</FONT> <BR><FONT size=2>&gt; &gt; &gt; &gt; &gt; the O/S level code away 
  from your</FONT> <BR><FONT size=2>&gt; application.</FONT> <BR><FONT 
  size=2>&gt; &gt; &gt; &gt; This</FONT> <BR><FONT size=2>&gt; &gt; &gt; &gt; 
  &gt; allows me to convert from one platform to</FONT> <BR><FONT size=2>&gt; 
  &gt; another</FONT> <BR><FONT size=2>&gt; &gt; &gt; &gt; &gt; transparently to 
  the User/Application.</FONT> <BR><FONT size=2>&gt; &gt; &gt; &gt; &gt;</FONT> 
  <BR><FONT size=2>&gt; </FONT><BR><FONT size=2>=== message truncated ===</FONT> 
  </P>
  <P><FONT size=2>= = = = = = = = = = = = = = = = = = = = = = = = = = = =</FONT> 
  <BR><FONT size=2>Mailing list: powerh-l@lists.sowder.com</FONT> <BR><FONT 
  size=2>Subscribe: "subscribe" in message body to 
  powerh-l-request@lists.sowder.com</FONT> <BR><FONT size=2>Unsubscribe: 
  "unsubscribe &lt;password&gt;" in message body to 
  powerh-l-request@lists.sowder.com</FONT> <BR><FONT size=2><A 
  href="http://lists.sowder.com/mailman/listinfo/powerh-l" 
  target=_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A></FONT> 
  <BR><FONT size=2>This list is closed, thus to post to the list you must be a 
  subscriber.</FONT> </P></BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C52578.C4495290--