datatype problem while reading

[sreddy]

Hi

I have a table using as a lookup, size is not mentioned.

DataStage
----------------------------------------------
ID ------------- Decimal 38
Date ------------ TimeStamp 38
Sequence No --- Decimal 38
================================
Oracle DDL
----------------------
Number
Date
Number

When i write a used defined script max(table.sequence no ) sequence no

Please help me on this error.

I am getting error.

##I TUTL 000031 11:52:14(001) <main_program> The open files limit is 8192; raising to 2147483647.
##I TOSH 000002 11:52:14(002) <main_program> orchgeneral: loaded
##I TOSH 000002 11:52:14(003) <main_program> orchsort: loaded
##I TOSH 000002 11:52:14(004) <main_program> orchstats: loaded
##I TFSC 000001 11:52:14(005) <main_program> APT configuration file: /usr/etl/default.apt
##W TCOS 000049 11:52:15(000) <main_program> Parameter specified but not used in flow: DSProjectMapName
##W TFIP 000022 11:52:16(004) <Oracle_Enterprise_11> When checking operator: When binding output interface field "SEQ_NO" to field "SEQ_NO": 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.

[kbsuryadev]

it says your target column is not nullable, so make it null and try

[sreddy]

Thank you

[ray.wurlod]

And, if that works, please mark the thread as Resolved using the green button at top.