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

brian_matthewsbrian matthews brian_matthews_bmw@hotmail.com
Wed, 09 Mar 2005 22:20:03 +0000


given that this is a 'mickey mouse' feature I think we should be grateful 
for what we have – they ( Cognos) might end up taking it away :)

Its a bit like asking for automatic headings/footings etc to be added to the 
dump command.

regards Bri,


>From: Tim Cummings <tim.cummings@frequencymarketing.com>
>To: powerh-l@lists.sowder.com
>Subject: RE: VMS to WINDOWS approach ( set lang SQL - gen database...) ?
>Date: Wed, 9 Mar 2005 16:23:19 -0500
>
>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.

_________________________________________________________________
Want to block unwanted pop-ups? Download the free MSN Toolbar now!  
http://toolbar.msn.co.uk/