DSXchange

Hi, I have a scenario where I have to run a job through sequence and the output of the job could be -1 0r 1.I need to abort my job if my job returns a value -1 and run it successfully if it returns 1. Can some one provide some suggestions in building up a sequence as per above scenario. Regards Kumar

Hi

I have a following warning in my job log which says
(null_field" length (4) must match field's fixed width (10)).

The warning is for a date column and the data type is date.Can some one explain me how to fix this warning


Regards

Kumar

Hi,

I have a scenario where i need to do a filter records from a particular column where it has value starts with 'zz'.Can some one explain how to acheive this.

Regards

kumar

Hi,

I am trying to load the data in to the oracle enterprise stage and i am getting the following error message

write() failed: Bad file descriptor

Can some one explain how to fix this issue.

Regards

Kumar

Hi I have a scenario where in I need to filter out all the records if I found the specific text any where in the record. for example I need to filter out all the records where they contain a value IBM.If IBM is part of any where within the record I need to filter out that record. Can some one please...

Hi

I fixed this issue by handling the spaces, when I am using Num function previously I was not taking care of spaces. So I did null to Empty(str) = ' ' then i replaced with some value.Hence the problem is solved.Thank you for all your inputs.

Regards

Kumar

I did handle the nulls by doing Null to Empty and used the Num function, it doesn't work.Still come up with warnings.The entire warning message is like null string arguments and I had some thousands of these warnings.

The data type for this field is coming as varchar and when I use Num(i/pcol)
it is giving me a warning message like null string argument.

Can someone tell me how to use the num function to find out if all the fields from the source are numeric

I have a filed called Phone_No where in I need to check whether the incoming data is numeric or not.Can some one let me know how to do this validation to find out if it is a numeric field or not.

Regards

Kumar

Hi There, I am running a parallel job where it's giving me a warning message like Implicit conversion from source type " "string" to result type "string[257]": Possible truncation of variable length string. I am not doing any unicode conversion it's just string to string.Any...

Hi,

How to set the extended property in for a column in DataStage?

Does sequential file have this property?

Regards

Kumar

Hi,

Can anyone tell me if there is a way we can populate milliseconds in Data Stage.

Regards

Kumar

Still an issue.

Regards

kumar

Hi,

I did replace that field names with column names and defined first line as column names.

Regards

Kumar