ODBC and .dbf bit-fields
Posted: Mon Jan 12, 2004 11:37 am
Dear all
We have encountered a problem reading .DBF files through an ODBC-stage from
a Solaris implementation of DataStage ... the contents of the fields of type
'BIT' are always returned as 0.
Has anyone encountered this sort of problem? Can anyone suggest any
appropriate work-arounds?
Thanks
James
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you are not the intended addressee, you must
not disclose, copy or take any action in reliance of this transmission.
The Company reserves the right to monitor all telecommunications that make
use of or passes through the Company facilities. This includes, but is not
limited to, E-mail, Internet, Facsimiles, Company Telephones and Company
Mobile Telephones. Please be advised that your telecommunication may be
intercepted, read, copied, deleted or retrieved by authorised personnel,
other than the sender or recipient of the original telecommunication, as
the Company sees fit.
Although this message and its contents have been scanned for viruses and no
viruses were detected, no responsibility whatsoever is accepted by the
Company, or any of its offices or companies for any loss or damage
arising in any way from receipt or use thereof.
If you have received this email in error please delete this message and
notify the Polk System Administrator at postmaster@polkglobal.com.
We have encountered a problem reading .DBF files through an ODBC-stage from
a Solaris implementation of DataStage ... the contents of the fields of type
'BIT' are always returned as 0.
Has anyone encountered this sort of problem? Can anyone suggest any
appropriate work-arounds?
Thanks
James
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you are not the intended addressee, you must
not disclose, copy or take any action in reliance of this transmission.
The Company reserves the right to monitor all telecommunications that make
use of or passes through the Company facilities. This includes, but is not
limited to, E-mail, Internet, Facsimiles, Company Telephones and Company
Mobile Telephones. Please be advised that your telecommunication may be
intercepted, read, copied, deleted or retrieved by authorised personnel,
other than the sender or recipient of the original telecommunication, as
the Company sees fit.
Although this message and its contents have been scanned for viruses and no
viruses were detected, no responsibility whatsoever is accepted by the
Company, or any of its offices or companies for any loss or damage
arising in any way from receipt or use thereof.
If you have received this email in error please delete this message and
notify the Polk System Administrator at postmaster@polkglobal.com.