DSXchange

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

I gave like this in modify stage. DATE:timestamp = handle_null(SRC_DATE,"12/31/9999") Again i got the following error message.give me idea Modify_13: Error when checking operator: When binding output schema variable "outRec": When binding output interface field "SRC_DATE&quo...

I gave like this in modify stage. DATE:timestamp = handle_null(SRC_DATE,"12/31/9999") Again i got the following error message. Modify_13: Error when checking operator: When binding output schema variable "outRec": When binding output interface field "SRC_DATE" to field ...

I am using modify stage to resolve the below warning "TABLENAME: When checking operator: When binding output interface field "DATE" to field "DATE": Converting a nullable source to a non-nullable result; a fatal runtime error could occur; use the modify operator to specify a...

I am not getting clear idea about this? Can you please give me brief details?

DSguru2B wrote:Thispost may help.

Hi ssgrpid, can you please explain briefly about this?Please let me know. I got the same issue with aggregator. Did you resolve the issue? Please let me know how can i resolve the issue Hi All, Scenario: I have used an aggregator and used the "maximum value output column" function to get t...

How can I get min value of date from aggregator stage? I am getting the below warnings. Can you please help me? Aggregator_1: Error when checking operator: When binding input interface field "DATE1" to field "DATE1": No default type conversion from type "timestamp" to t...

Fields AAAAA Min(DATE) Min(BBBBB) Sum(CCCCC) Source have these 4 fields Group By AAAAA. Hi, In my i need to aggrigate some fields.There are 4 fields are there in source .for that i am using aggregator stage.in this aggrigator stage i have to take like this Fields AAAAA Min(DATE) Min(BBBBB) Sum(CCCCC...

Hi, In my i need to aggrigate some fields.There are 4 fields are there in source .for that i am using aggregator stage.in this aggrigator stage i have to take like this Fields AAAAA Min(DATE) Min(BBBBB) Sum(CCCCC) Source have these 4 fields I created job but i am getting below error. Please help me....

I searched but i did not find any information.Please let me know if you have any idia about this.

DSguru2B wrote:Have you tried searching on error messages. I did a quick search and both your error returned results.

Hi, I designed one job.Job ran success.But i got the below warning messages. can any one help me about this warnings? 1. TARGET TABLE NAME: When checking operator: Column RCRD_CNT floating point decimal is not fully supported; adjusting the scale. 2. Target Seq.File: When checking operator: A sequen...

Hi,
Click on the properties tab and then click on options.you can find Available properties to add box on right side.

sshettar wrote:reddy12 , Could you please let me know where did you find the Filter command in the sequential file stage in PX

Thanks,DSguru2B.I got it.

reddy12 wrote:Could you please tell me where can i find filter command in sequential file stage? i am using DataStage 7.5.2

DSguru2B wrote:In the filter command of sequential file stage, put wc -l. Specify one column in the metadata. This will get your the row count of the file you specify.

Could you please tell me where can i find filter command in sequential file stage? i am using DataStage 7.5.2

DSguru2B wrote:In the filter command of sequential file stage, put wc -l. Specify one column in the metadata. This will get your the row count of the file you specify.

Hi I need to create one job.In that I need to calculate record count of the file. That count have to go to transformer stage.How can I create the job and calculate the count and need to send into next stage.Please give me suggestion Sequential file(Source)------->Transformer----->........(stages)