Data Conversion
Peter Bateman
shediac92@hotmail.com
Tue, 01 Apr 2003 13:24:48 -0400
Viet:
Terry made an interesting point about binary data. Do you have
any scaled data? If you do are you going to make them scaled in
MS SQLserver. I think I would make them scaled in the database so
that non-PowerHouse applications would not have to worry about
scaling.
e.g. in PDL
Element X numeric 15 decimal 2 default datatype packed size 8
in SQL
X decimal (15,2)
Regards,
Peter
>From: "Viet Nguyen" <VNguyen@wsboces.org>
>To: <terrycurran@onetel.net.uk>, <powerh-l@cube.swau.edu>
>Subject: RE: Data Conversion
>Date: Tue, 1 Apr 2003 08:54:04 -0500
>
>Thank you all for the suggestions on the data conversion. I think I am
>going to port the files to the portable subfiles and go from there.
>Viet.
>
>-----Original Message-----
>From: Terry Curran [mailto:terrycurran@onetel.net.uk]
>Sent: Tuesday, April 01, 2003 6:41 AM
>To: Viet Nguyen; powerh-l@cube.swau.edu
>Subject: RE: Data Conversion
>
>I don't think this is a practical solution.
>
>This would only work properly if the data in the files was 'Text', i.e.
>all fields were CHARACTER, or ZONE UNSIGNED numeric. Any numeric fields
>will have binary data in them which would not translate correctly when
>transferred to Windows!!
>
>That's why you should use portable subfiles as the portable subfiles
>convert numeric values to characters. Anyway its very simple to create
>Portsbale subfiles in QUIZ, just
>
>Access <filename>
>Report all
>Set subfile name <subfilename> portable keep
>Set report nolimit
>Go
>
>Then just transfer the .psd, and the .pd fdiles, and they can be read
>directly by quiz
>
>
>------------------------------------------------------------------------
>----------------
>
>This email is brought to you courtesy of 1 & 1, for more details please
>visit the
>link below
>
> http://oneandone.co.uk/xml/init?k_id=5753616
>
>------------------------------------------------------------------------
>----------------
>
>
>-----Original Message-----
>From: powerh-l-admin@cube.swau.edu [mailto:powerh-l-admin@cube.swau.edu]
>On Behalf Of Viet Nguyen
>Sent: Monday, March 31, 2003 2:53 PM
>To: Greig Morrison; powerh-l@cube.swau.edu
>Subject: RE:Data Conversion
>
>
>
>Hi Mike & Greig,
> Thank you for the suggestions. I have a question: Can I not
>just move the raw data files and the dictionary from Unix and recompile
>in Windows then read the files directly with PowerHouse and output them
>into MS Sql tables? Thanks in advance. Viet.
>
>-----Original Message-----
>From: Greig Morrison [mailto:greig.morrison@sympatico.ca]
>Sent: Sunday, March 30, 2003 1:03 PM
>To: powerh-l@cube.swau.edu
>Subject: Re: powerh-l digest, Vol 1 #597 - 1 msg
>
>A possible solution if you have PowerHouse on NT available.
>
>One of the issues you probably have is that the MS SQL database will
>have "_" underscore in table and item names where "-" dashes may exists
>in the C-ISAM dictionary definitions, assuming that your new MS SQL
>database uses most of the same names. Using PowerHouse to do the data
>conversion, you can create a new dictionary from the existing dictionary
>for your C-ISAM files changing all the "-" dashes to "_" underscores.
>Compile this new dictionary on the Unix box, unload all the files to
>Portable subfiles with QUIZ or QTP. Download the subfiles via FTP using
>binary for the data component (.ps) and ASCII for the dictionary
>component (.psd) to a PC. You could use PowerHouse on NT or Axiant to
>read the subfiles directly, to load the MS SQL database, these products
>will read the subfile dictionary and use automatic initialization to
>load like named items from the subfiles to the corresponding MS SQL
>tables. Note: you need to manipulate any dates with "0" (zeroes) to
>convert them to Nulls etc.
>
>Greig
>
>powerh-l-request@cube.swau.edu wrote:
>
> > Send powerh-l mailing list submissions to
> > powerh-l@lists.swau.edu
> >
> > To subscribe or unsubscribe via the World Wide Web, visit
> > http://lists.swau.edu/mailman/listinfo/powerh-l
> > or, via email, send a message with subject or body 'help' to
> > powerh-l-request@lists.swau.edu
> >
> > You can reach the person managing the list at
> > powerh-l-admin@lists.swau.edu
> >
> > When replying, please edit your Subject line so it is more specific
> > than "Re: Contents of powerh-l digest..."
> >
> > Today's Topics:
> >
> > 1. RE:moving c-isam files to MS SQL (Viet Nguyen)
> >
> > --__--__--
> >
> > Message: 1
> > Subject: RE: moving c-isam files to MS SQL
> > Date: Fri, 28 Mar 2003 14:53:20 -0500
> > From: "Viet Nguyen" <VNguyen@wsboces.org>
> > To: <powerh-l@lists.swau.edu>
> >
> > Hi all, can someone show me how to move c-isam files to Microsoft SQL?
>
> > We have c-isam on IBM AIX (Unix).
> >
> > --__--__--
> >
> > = = = = = = = = = = = = = = = = = = = = = = = = = = = = Mailing list:
> > powerh-l@lists.swau.edu
> > Subscribe: "subscribe" in message body to
>powerh-l-request@lists.swau.edu
> > Unsubscribe: "unsubscribe <password>" in message body to
>powerh-l-request@lists.swau.edu
> > http://lists.swau.edu/mailman/listinfo/powerh-l
> > This list is closed, thus to post to the list you must be a
>subscriber.
> >
> > End of powerh-l Digest
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.swau.edu
>Subscribe: "subscribe" in message body to
>powerh-l-request@lists.swau.edu
>Unsubscribe: "unsubscribe <password>" in message body to
>powerh-l-request@lists.swau.edu
>http://lists.swau.edu/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.swau.edu
>Subscribe: "subscribe" in message body to
>powerh-l-request@lists.swau.edu
>Unsubscribe: "unsubscribe <password>" in message body to
>powerh-l-request@lists.swau.edu
>http://lists.swau.edu/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.swau.edu
>Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
>Unsubscribe: "unsubscribe <password>" in message body to
>powerh-l-request@lists.swau.edu
>http://lists.swau.edu/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail