Hi All,
I am not able to find if there is an environment variable to insert single space to a field in case incoming data is NULL while loading to a Teradata table.
I am aware that this we can achieve with Oracle DB using APT_ORACLE_PRESERVE_BLANKS, but not sure how to achive in teradata
Any help
Insert Blank space for null value in teradata table
Moderators: chulett, rschirm, roy
Basically We are reading a flat file and the culpret column is coming with null values which is actually a not null column in target and using transformer stage I am trying to load into Teradata table using Mload , but it is again and again failing with 3604 error message (Cannot place a null value in a NOT NULL field. ) the we tried below option
bot none of them are working for that column
If isnull(CcartDirSymp507AgtPerfDlyUps_Merged_Data.SUPERVISOR_LOGIN) THEN ' ' ELSE TRIM(CcartDirSymp507AgtPerfDlyUps_Merged_Data.SUPERVISOR_LOGIN)
If isnull(CcartDirSymp507AgtPerfDlyUps_Merged_Data.SUPERVISOR_LOGIN) THEN " " ELSE TRIM(CcartDirSymp507AgtPerfDlyUps_Merged_Data.SUPERVISOR_LOGIN)
Tried converting NullToZero , this is also not working
If isnull(CcartDirSymp507AgtPerfDlyUps_Merged_Data.SUPERVISOR_LOGIN) THEN NullToZero(CcartDirSymp507AgtPerfDlyUps_Merged_Data.SUPERVISOR_LOGIN) ELSE TRIM(CcartDirSymp507AgtPerfDlyUps_Merged_Data.SUPERVISOR_LOGIN)
Am I doing something wrong here:(
bot none of them are working for that column
If isnull(CcartDirSymp507AgtPerfDlyUps_Merged_Data.SUPERVISOR_LOGIN) THEN ' ' ELSE TRIM(CcartDirSymp507AgtPerfDlyUps_Merged_Data.SUPERVISOR_LOGIN)
If isnull(CcartDirSymp507AgtPerfDlyUps_Merged_Data.SUPERVISOR_LOGIN) THEN " " ELSE TRIM(CcartDirSymp507AgtPerfDlyUps_Merged_Data.SUPERVISOR_LOGIN)
Tried converting NullToZero , this is also not working
If isnull(CcartDirSymp507AgtPerfDlyUps_Merged_Data.SUPERVISOR_LOGIN) THEN NullToZero(CcartDirSymp507AgtPerfDlyUps_Merged_Data.SUPERVISOR_LOGIN) ELSE TRIM(CcartDirSymp507AgtPerfDlyUps_Merged_Data.SUPERVISOR_LOGIN)
Am I doing something wrong here:(
Akumar
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: