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.
datatype problem while reading
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 46
- Joined: Wed Jun 06, 2007 10:32 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: