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")