DSXchange

It will be nice if you can continue any one post.Try

Did you really mean handle_null() ?
Or maybe you're replying to a different post?

My problem is not resolved I am getting same error.

I specified same like you sent. But i am getting this error.

main_program: Error parsing modify adapter: Error in binding: Expected ')', got: "-12"
Expected destination field selector, got: ")"; input:
SRC_DATE = handle_null(SRC_DATE,9999-12-31)
;
DUMMYCOL= handle_null(DUMMYCOL," ")
;
Error parsing modify adapter: Error in binding: Expected ')', got: "-12"
Expected destination field selector, got: ")"; input:
RUN_DT = handle_null(RUN_DT,9999-12-31)
;
DUMMYCOL= handle_null(DUMMYCOL," ")
;

us1aslam1us wrote:It will be nice if you can continue any one post.Try

Code: Select all

DATE1=handle_null(DATE1,"%yyyy-%mm-%dd %hh:%nn:%ss")

Can you post that part of the generated OSH related to the modify operator?

Thanks

New? 44 posts? Ah well. Open the job properties where you will find a tab called Generated OSH. It's there.