?
Solved

Lotue LEI Direct Transfer error message, SQL0407N

Posted on 2003-12-09
2
Medium Priority
?
493 Views
Last Modified: 2013-12-18
Hi, I'm getting this error message, SQL0407N  Assignment of a NULL value to a NOT NULL column "*N" is not allowed.  SQLSTATE=23502,  Connector 'DataWarehouse',  Method -Insert-  (-407)

when i'm trying to send 9 fields from a Notes database to a AS400 DB2 database.   All the fields are Text on the Notes side and all are Alpha on the DB2 side.

Help!!!!

I searched Google and found this explanation, it looks like it comes down to data types incompatible but how can that be if I'm moving Text to Alphas?  



sqlcode: -407

sqlstate: 23502

SQL0408N A value is not compatible with the data type of its assignment target. Target name is "<name>".  


Explanation: The data type of the value to be assigned to the column, parameter, SQL variable, or transition variable by the SQL statement is incompatible with the declared data type of the assignment target. Both must be:

Numeric
Character
Graphic
Dates or character
Times or character
Timestamps or character
Datalinks
The same distinct types
Reference types where the target type of the value is a subtype of the target type of the column.
The same user-defined structured types. Or, the static type of the value must be a subtype of the static type (declared type) of the target.
The statement cannot be processed.

User Response: Examine the statement and possibly the target table or view to determine the target data type. Ensure the variable, expression, or literal value assigned has the proper data type for the assignment target.

0
Comment
Question by:stanstan30
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 24

Accepted Solution

by:
HemanthaKumar earned 1500 total points
ID: 9905474
Change the column to accept nulls on DB2 side..

Or you can host domino on AS\400 which will overcome this problem

~Hemanth
0
 

Author Comment

by:stanstan30
ID: 9906422
Hemanth, thanks for the update.

We currently do have Domino running on a AS400 box.

Accepting Nulls on DB2 side worked.

0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question