Remove Warnings while populating sequential files
Moderators: chulett, rschirm, roy
Remove Warnings while populating sequential files
I am populating sequential file from database using single transformations . While populating the XXXX field i am facing following warning.:
[i]When checking operator: When binding output interface field "xxxx" to field "xxxx": Converting a nullable source to a non-nullable result;[/i]
I tried option like Make the nullable field to yes for both source and taret. Added is null check like IF ISNULL(XXXX) then XXXX ELSE XXXX. (Just to avoid the warning)
Can you please let me know how can I remove the warning?
Thanks and Regards
Sameer
[i]When checking operator: When binding output interface field "xxxx" to field "xxxx": Converting a nullable source to a non-nullable result;[/i]
I tried option like Make the nullable field to yes for both source and taret. Added is null check like IF ISNULL(XXXX) then XXXX ELSE XXXX. (Just to avoid the warning)
Can you please let me know how can I remove the warning?
Thanks and Regards
Sameer
Last edited by sampitke1 on Mon Jul 14, 2008 8:35 am, edited 1 time in total.
This warning should disappear when you code an explicit null handling into the transform or modify stage. Are you certain the warning did not go away when you tried this?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Remove Warnings while populating sequential files
Thanks for your reply. However
I used following code for null handling.
1) If IsNull(XXXX) Then XXXX Else '000000000' : Warning is still there
2) If IsNull(XXXX) Then XXXX Else XXXX : Warning is still there.
Target is fixedwidth file.
Thanks
Sameer
I used following code for null handling.
1) If IsNull(XXXX) Then XXXX Else '000000000' : Warning is still there
2) If IsNull(XXXX) Then XXXX Else XXXX : Warning is still there.
Target is fixedwidth file.
Thanks
Sameer
Remove Warnings while populating sequential files
I used the code in the transformer. In the Column Derivation of XXXX column.
Thanks
Sameer
Thanks
Sameer
Re: Remove Warnings while populating sequential files
1. Open the prooerties tab of the seq file
2. Go to Input --> columns tab
3. You see the field # assigned for each field
4. Double click on the field # and set the null value
I hope it will resolve the issue.
2. Go to Input --> columns tab
3. You see the field # assigned for each field
4. Double click on the field # and set the null value
I hope it will resolve the issue.
Re: Remove Warnings while populating sequential files
Nullable status for all the fields is "No".
Still I am facing the warning. "When checking operator: When binding output interface field "XXXX" to field "XXXX": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur; use the modify operator to
specify a value to which the null should be converted."
Still I am facing the warning. "When checking operator: When binding output interface field "XXXX" to field "XXXX": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur; use the modify operator to
specify a value to which the null should be converted."
-
- Charter Member
- Posts: 299
- Joined: Wed Nov 13, 2002 5:38 pm
- Location: USA
Nullable status for all fields is NOT No. At least one: "XXXX" is defined in the database as NULLABLE. Your job column metadata should match the DDL of the database table. The Table will override your job metadata, hence the warning. Further just because you hand code an IF statement doesn't mean Datastage is smart enough to realize that the field can't be NULL. DataStage trusts the metadata and the Modify stage. Use them.
Re: Remove Warnings while populating sequential files
With the first code, arent you supposed to use IsNotNull() ???sampitke1 wrote:Thanks for your reply. However
I used following code for null handling.
1) If IsNull(XXXX) Then XXXX Else '000000000' : Warning is still there
2) If IsNull(XXXX) Then XXXX Else XXXX : Warning is still there.
Target is fixedwidth file.
Thanks
Sameer
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can do the null handling at column level.Go to column meta data double click on the number ..it will pop up another window..there you will have to explicitly define the value in pace of null...Do it by selecting Null Field value = ' ' ...The number of spaces will be the same as the length of your field. I hope it will resolve the issue
Thanks..
Thanks..
ambasta
You can do the null handling at column level.Go to column meta data double click on the number ..it will pop up another window..there you will have to explicitly define the value in pace of null...Do it by selecting Null Field value = ' ' ...The number of spaces will be the same as the length of your field. I hope it will resolve the issue
Thanks..
Thanks..
ambasta
Change the datatype of seq file
Even I have faced the same error.
From the transformer,I was populating the records into seq file.
So in the output tab,I have changed the char and date data type to varchar.
Definetly this will resolve ur warning,and one more thing In seq file input/format mention null field value ="
From the transformer,I was populating the records into seq file.
So in the output tab,I have changed the char and date data type to varchar.
Definetly this will resolve ur warning,and one more thing In seq file input/format mention null field value ="
thanks n regards
nani
nani