DSXchange

Earlier when I did not give the NULL FIELD VALUE property, I got the following error: Sequential_File_3: When checking operator: When validating export schema: At field "FIELD_NAME": Exporting nullable field without null handling properties so the best way to get out of this situation is t...

The file is a pipeline delimted file. Let me give you a sample

0|44.65|0.00|44.65|44.65||

As you can see the last column doesn't have any value. Does that mean it is empty or is it null? I am not sure...

No, but this is the first column of the DECIMAL type which encounters a null value. Once I set a default value for this field, the same error crops for another column FIELD_2 with the same decimal datatype. I don't understand why this error should come up even after I have specified the NULL FIELD V...

The following error has already been discussed at length Field "FIELD_NAME" has import error and no default value; data: <empty>, at offset: 132 But I am having a peculiar case.I have over 80 columns where I haven't specified any default values. But Datastage is throwing up this error only...

Hi, I have over 100 columns in a sequential file of which about 80 are nullable. I want to set the null field values for all these columns. I know how to do this but I want to know if there is any way we can set default values for a particular datatype in one go. For example, I want to give a null f...

Is the error in the C routine compilation or somewhere else?

Hi, I initially tried out a simple C routine with main() function and it worked fine. So I removed the main function and renamed it and created a PX routine. I tried to call the routine in a transformer. The job compiles successfully but gets aborted when I run it. The following is the error I get i...

please guys...suggestions?

I have to pick the first record of a table. Then I need to compare a date field in the first record with the corresponding date field in the second record. Based on the comparison I will do some transformations. Then I will compare the first with the third, then the fourth and so on. At the end of c...

Hi, I need to do some date calculations based on the current system date. For that used the TimeDate() function. But since the result is in string format (ie. hh:mm:ss dd mon yyyy), I need to convert it to the required date format (dd-mm-yyyy). I tried using the StringToDate function, but the output...

i have a sequence of jobs starting from the hash load job. i have written a script through which i am passing the parameters to the job. i execute the script from a unix client. the parameters are passed properly, i have checked that. because when i run the job individually with the same parameters ...

I tried to create a hashed file using data from a table in an Oracle database. When I run the job individually, the file is created properly. But when I run it from a sequence, I get the Oracle error ORA-01017 stating that the username/password are invalid.

Please say what I need to check.

have tried that...still same problem

After compiling a job, I get the following error:

Error compiling generated subroutine for stage
JobName.TransformerName

What does this mean and how do I handle the error?

can someone explain what "Unable to return attached job" means?