[AccessD] AS400 data upload (Lost in Translation)

Thanks!
Jim Hale

-----Original Message-----
From: Gary Kjos [mailto:garykjos at gmail.com]
Sent: Friday, August 19, 2005 1:02 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] AS400 data upload (Lost in Translation)


Hi Jim,

I think not an empty string but a single space character surrounded by
the appropriate quotation marks is what I would use.  Hex 40 is EBCDIC
for a space. ASCII space is hex 20.  Evidently the space it originally
contained got stripped as part of a "trim" trailing spaces that the
file transfer did for you - which you would have preferred in this
case that it hadn't done.

Give it a space and you should be good to go.

Gary

On 8/19/05, Hale, Jim <Jim.Hale at fleetpride.com> wrote:
> I imported tables into Access from the AS400 using IBM's client Access
ODBC
> driver. I updated the tables in Access, emptied the tables on the AS400
and
> uploaded the Updated Access data to the AS400 via an append query (the
AS400
> tables were linked via the ODBC driver). This worked fine except for one
> table. The table came from the AS400 with blank fields. When I tried to
> upload it back the AS400 puked saying I was trying to place nulls in the
> field. The AS400 guys tell me the AS400 does not have nulls, that the
field
> is really  a blank (hex 40?). How can I change my query so that the AS400
> will accept it? Use an empty string? Use the ASC equivalent of hex 40? TIA
> 
> Jim Hale
> 
> ***********************************************************************
> The information transmitted is intended solely for the individual or
> entity to which it is addressed and may contain confidential and/or
> privileged material. Any review, retransmission, dissemination or
> other use of or taking action in reliance upon this information by
> persons or entities other than the intended recipient is prohibited.
> If you have received this email in error please contact the sender and
> delete the material from any computer. As a recipient of this email,
> you are responsible for screening its contents and the contents of any
> attachments for the presence of viruses. No liability is accepted for
> any damages caused by any virus transmitted by this email.
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 
> 


-- 
Gary Kjos
garykjos at gmail.com
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

***********************************************************************
The information transmitted is intended solely for the individual or
entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or
other use of or taking action in reliance upon this information by
persons or entities other than the intended recipient is prohibited.
If you have received this email in error please contact the sender and
delete the material from any computer. As a recipient of this email,
you are responsible for screening its contents and the contents of any
attachments for the presence of viruses. No liability is accepted for
any damages caused by any virus transmitted by this email.