DSXchange

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.

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

Thank you

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