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

Wed, 9 Mar 2005 16:23:19 -0500

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

I was hoping for a more automated solution.

Timothy J Cummings
Ridgewood Corporate Center
1000 Summit Drive, Suite 200
Milford, Ohio  45150
tim.cummings@frequencymarketing.com

-----Original Message-----
From: brian_matthewsbrian matthews
[mailto:brian_matthews_bmw@hotmail.com]
Sent: Wednesday, March 09, 2005 4:05 PM
To: Ken@Langendock.com; powerh-l@lists.sowder.com
Subject: RE: VMS to WINDOWS approach ( set lang SQL - gen database...) ?

how about this -

create a copy of the pdl source with the lowest level redefines as the new 
highest level, recompile the dict  ( under new name ), setdict to the new 
dictionary and then run the 'set lang sql/gen database' command against the 
new dictionary/record layouts.

regards Bri,

>From: Ken Langendock <ken.langendock@rogers.com>
>Reply-To: Ken@Langendock.com
>To: powerh-l@lists.sowder.com
>Subject: RE: VMS to WINDOWS approach ( set lang SQL - gen database...)  ?
>Date: Wed, 9 Mar 2005 15:26:42 -0500 (EST)
>
>I doubt there is another "undocumented" feature to
>handle this, but it wouldn't surprise me.
>
>This would be true for any machine platform. SQL does
>not support substructures or redefines so I'm guessing
>there isn't anything like that.
>
>Ken
>
>  --- 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
> >
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>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.

_________________________________________________________________
Use MSN Messenger to send music and pics to your friends 
http://www.msn.co.uk/messenger

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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_001_01C524EE.374D33F0
Content-Type: text/html;
	charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45">
<TITLE>RE: VMS to WINDOWS approach ( set lang SQL - gen database...) ?</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=2>I was hoping for a more automated solution.</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: brian_matthewsbrian matthews</FONT>
<BR><FONT SIZE=2>[<A HREF="mailto:brian_matthews_bmw@hotmail.com">mailto:brian_matthews_bmw@hotmail.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Wednesday, March 09, 2005 4:05 PM</FONT>
<BR><FONT SIZE=2>To: Ken@Langendock.com; powerh-l@lists.sowder.com</FONT>
<BR><FONT SIZE=2>Subject: RE: VMS to WINDOWS approach ( set lang SQL - gen database...) ?</FONT>
</P>
<BR>

<P><FONT SIZE=2>how about this -</FONT>
</P>

<P><FONT SIZE=2>create a copy of the pdl source with the lowest level redefines as the new </FONT>
<BR><FONT SIZE=2>highest level, recompile the dict&nbsp; ( under new name ), setdict to the new </FONT>
<BR><FONT SIZE=2>dictionary and then run the 'set lang sql/gen database' command against the </FONT>
<BR><FONT SIZE=2>new dictionary/record layouts.</FONT>
</P>

<P><FONT SIZE=2>regards Bri,</FONT>
</P>
<BR>
<BR>
<BR>

&gt;From: Ken Langendock &lt;ken.langendock@rogers.com&gt;
 &gt;Reply-To: Ken@Langendock.com
 &gt;To: powerh-l@lists.sowder.com
 &gt;Subject: RE: VMS to WINDOWS approach ( set lang SQL - gen database...)&nbsp; ?
 &gt;Date: Wed, 9 Mar 2005 15:26:42 -0500 (EST)
 &gt;
 &gt;I doubt there is another &quot;undocumented&quot; feature to
 &gt;handle this, but it wouldn't surprise me.
 &gt;
 &gt;This would be true for any machine platform. SQL does
 &gt;not support substructures or redefines so I'm guessing
 &gt;there isn't anything like that.
 &gt;
 &gt;Ken
 &gt;
 &gt;&nbsp; --- Tim Cummings
 &gt;&lt;tim.cummings@frequencymarketing.com&gt; wrote:
 &gt; &gt; I tried this on MPE and the only bad thing about it
 &gt; &gt; is if you have a column
 &gt; &gt; that is re-defined, it only creates the higher level
 &gt; &gt; item.
 &gt; &gt;
 &gt; &gt; Is there an option to get it to create columns for
 &gt; &gt; the lower level items?
 &gt; &gt;
 &gt; &gt;
 &gt; &gt; Timothy J Cummings
 &gt; &gt; Ridgewood Corporate Center
 &gt; &gt; 1000 Summit Drive, Suite 200
 &gt; &gt; Milford, Ohio&nbsp; 45150
 &gt; &gt; tim.cummings@frequencymarketing.com
 &gt; &gt;
 &gt;
 &gt;= = = = = = = = = = = = = = = = = = = = = = = = = = = =
 &gt;Mailing list: powerh-l@lists.sowder.com
 &gt;Subscribe: &quot;subscribe&quot; in message body to powerh-l-request@lists.sowder.com
 &gt;Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to 
 &gt;powerh-l-request@lists.sowder.com
 &gt;<A HREF="http://lists.sowder.com/mailman/listinfo/powerh-l" TARGET="_blank">http://lists.sowder.com/mailman/listinfo/powerh-l</A>
 &gt;This list is closed, thus to post to the list you must be a subscriber.

<P><FONT SIZE=2>_________________________________________________________________</FONT>
<BR><FONT SIZE=2>Use MSN Messenger to send music and pics to your friends </FONT>
<BR><FONT SIZE=2><A HREF="http://www.msn.co.uk/messenger" TARGET="_blank">http://www.msn.co.uk/messenger</A></FONT>
</P>

<P><FONT SIZE=2>= = = = = = = = = = = = = = = = = = = = = = = = = = = =</FONT>
<BR><FONT SIZE=2>Mailing list: powerh-l@lists.sowder.com</FONT>
<BR><FONT SIZE=2>Subscribe: &quot;subscribe&quot; in message body to powerh-l-request@lists.sowder.com</FONT>
<BR><FONT SIZE=2>Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; 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>

</BODY>
</HTML>
------_=_NextPart_001_01C524EE.374D33F0--