×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
As usual, extremely knowledgeable responses! I appreciate your help.
I finally checked the "Convert CCSID 65535" box to solve the DBCS data
issue.
I then determined that the date & time fields were not necessary for my
immediate needs, so I just ignored them. The last problem left to solve was
the fact that one date column had blanks for many rows, and I had no idea
how to resolve that by transferring records into a table defined with date
data type fields. Perhaps an SQL field selection "if e2=blank, then
'0001-01-01', else e2"? Otherwise, if I need to do this in the future, I'll
define a table with alpha types replacing the date & time types, and then
use SQL to feed the table with the date & time data types.
Thanks,
Dan
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
