DSXchange

Hi all Thanks all of you guys and DSXchange. I need to create fixed length flat file.I am getting this error.I selected record length is fixed.how can i resolve this problem Please give me suggestion. Sequentialfile1: Error when checking operator: "record_length=fixed" (no length given) an...

I checked.Thank you very much for your quick response.

us1aslam1us wrote:Check your other post...

I specified in properties like below specification=DATE = handle_null(DATE," ") I am getting the below Error. Modify_14: Error when checking operator: When binding output schema variable "outRec": When binding output interface field "DATE" to field "DATE": Bad...

here i am littile bit confusion wtih (timestamp)
string_from_timestamp[timestamp_format] (timestamp)

string_from_timestamp[%yyyy-%mm-%dd %hh:%nn:%ss](DATEFIELD)
Is this above code correct?

us1aslam1us wrote:A clear specification with format is given in Parallel Job Developer's guide, Page 28-10,28-11.

Thanks for your response DSguru2B Can you please give me one example? I am getting problem with that. DATEFIELD=handle_null() what can i specify in () ? A small correction here. NullToValue() will work only in the transformer stage. It wont in the modify stage. There is a mistake in the parallel gui...

I am not able to see the code
can you please type only the code?

ray.wurlod wrote:In the Modify stage the format string is given in square brackets, the input argument (field name) is given in parentheses. For example

Code: Select all

string_from_timestamp[%yyyy-%mm-%dd %hh:%nn: ...[/quote]

Default timestamp is %yyyy-%mm-%dd %hh:%nn:%ss

ray.wurlod wrote:To answer my question open the Administrator client, open the Parallel tab in your project properties, and determine the date, time and timestamp format strings recorded there. These are the defaults ...

time stamp is the default datatype

ray.wurlod wrote:To answer my question open the Administrator client, open the Parallel tab in your project properties, and determine the date, time and timestamp format strings recorded there. These are the defaults ...

How can i change timestamp field into string and string to timestamp?
give me example on that.

specification property.

Thanks to all guys to sharing your ideas in DSXchange.

how can i handle null on timestamp in modify stage?
in specification properties what can i write? give suggestion.

Thanks

Which error you are getting?

kirankota79 wrote:iam able to view data from oracle stage, but when i run the job, it is getting aborted. I am writing the ouput to a sequential file.

In oracle table the date is like this 5/1/2007(source) I took datatype as timestamp in datastage in my job without modify stage the job is running.but i am getting warningslike below: When checking operator: When binding output interface field "DATE" to field "DATE": Converting a...

I spcified like this SRC_DATE = handle_null(SRC_DATE,'9999-12-31') RUN_DT = handle_null(RUN_DT,'9999-12-31') 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 select...

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,&...

Hai I am getting the following error.i tried two dates. I am getting this error.please check this error. actually there are two columns one is date field and another is varchar field. main_program: Error parsing modify adapter: Error in binding: Expected ')', got: "-31" Expected destinatio...