DSXchange

I am getting below mentioned error while running the DS sequence that runs several jobs: main_program: Fatal Error: There are irreconcilable constraints on the number of partitions of an operator: parallel APT_DBExportOperator in ORDER_NW_roe. The number of partitions is already constrained to 4, bu...

Thank you very much.

I got it!!

Hi All, I am doing certain validation in Data stage transformer. I need to check whether the value in the input string is case sensitive or not. Actually in one of our validation, we have to reject the input string if it is in the Lower case. Can you please tell me how can i do that. Is there any fu...

I m using sequential file and trying to process volume of data using transformer and inserting the processed data into various datasets.

But it is giving me this error "buffer overrun"

Hi, My DS job aborts with an error " Input buffer overrun at field "desk_rcvd_ts" " when i am trying to run my Parallel job. What exactly is that error and how i goona fix it?? When i ran the job for the first time on the volume of data ,it ran fine. Now i am trying to run it aga...

I truned off the operator combination and again ran the job on 3.5 million records. Again in the end it aborts with the below erroe message. order_nw_stg,0: ERROR: Attribute 'c0' not found order_nw_stg,0: Failure during execution of operator logic. There is nothing as 'c0' in my Job.I checked again ...

chr() is also there in parallel jobs but ascii() function is not there in parallel jobs.

But i am not sure how to check for an control character within a string using chr() function.

ALNum() function checks only for alpha numeric character in the string.

But i actually wanna check .... whatever string i am using should have ASCII characters between 32 and 127.If any of the character is outside this range,it should reject that string.

Hi, I am running a job that process 3.5 millions rows ,reading from a file and after processing inserting to DB tables. When i run that Job with Node 1 then its is running fine but when i try to run it either by Node2 or Node 4 then it aborts with an error message: Message: APT_CombinedOperatorContr...

Hi,

I want to check whether the string contain control character /Unprintable character in it.

How do i check in the transformer stage .

Is there any function is there to check the same??

Can i check by their Ascii values ??? But how in DS.

Regards
~Nirmal

But cant we use IsValid function to validate the format of timestamp??
Also i want to check this in the transformer stage ( I mean if the timestamp is of valid formet specified by me then fine otherwise reject the record.

Actually its a string like "20071229000000" and before converting this string into timestamp field by StringToTimestamp() function,i want to validate that this should be in "yyyymmddhhnnss" format otherwise reject that record.

So how do i do that?

Hi, I want to check whether the timestamp field is of valid format specified by the user or not. Eg. How to check whether user_ts is of format yyyymmddhhnnss in transformer stage. I used IsValid() function but this function always return false in my case. Can somebdy tell me how to use IsValid() fun...

I have created a simple job using Column Import stage to imports data from a single column and outputs it to one or more columns. I used Sequential file to read data,Column Import Stage to import data from 1 column to multiple column and Target database. But when i run the job it gives me an error:&...