DSXchange

The output schema is where you would specify all of the null handling. Is the output file fixed length or variable with field delimiters? If fixed length, you will need to specify the number of spaces to populate your "null" field. You don't necessarily need to do that for a variable leng...

Hi, I have sequential file as output and the all the columns (about 4000) are nullable = YES type columns. Now my questions are >> will the seq file can store null values as is? >>If I want to specify blanks/spaces (for both char and decimal columns) in case the coming value is NULL for that field,h...

But we have fields which have more than 19 bytes and one of the fields is 350 bytes in length.

ray.wurlod wrote:Enter the 19 spaces then select them. Press Ctrl-C. Then, for all the others, press Ctrl-V. It's a technique called copy-and-paste.

We have approx. 4000 decimal and char type columns in a Sequential writer. All the columns are Nullable. I need to define the "Null Field Value" for each column thru Edit Column Meta Data. Most of the char columns are more than 20 bytes long. Is there is shortest way to put the spaces rath...

We have approx. 4000 decimal and char type columns in a Sequential writer. All the columns are Nullable. I need to define the "Null Field Value" for each column thru Edit Column Meta Data. Most of the char columns are more than 20 bytes long. Is there is shortest way to put the spaces rath...

Hi,
I am having some decimal columns in my Source sequential file.
Whenever I get junk data for these(which is not decimal) I want to default them to NULLS.Please let us know if this can be done??

Please help me with this error.

ORCHESTRATE step execution terminating due to SIGINT

Hmm.. Thanks ArndW..I will take that suggestion.Will look into that and let you know if anything fruitful comes out. nynali - what platform are you on and which compiler are you using? Once you get that information find the relevant manual or web page and see if the compiler will allow that 32Kb val...

I was able to compile the job by splitting into 1000 columns each but when I try with 1500 or so it again fails.So I shortened my Column Names and the job went fine. So is there any method to increase the 32765 limit?? Well, lets try to confirm, that really is the issue here. Split the columns into ...

Hi Dsguru,
Is there any way to increase the string literal value more than 32765??

DSguru2B wrote:Well, that might be the problem. Test it out. Cut it into half and see if the job compiles. If to no avail, cut it into half again.

I have around 3800 columns as input to the transformer.So please let me know if this is causing a problem and if it is the case please let me know how to handle this?? It could be a missing quote character - 32KB is a heck of a long string literal - maybe the compiler is still searching for the clos...

Please help me with this warning.What settings need to be changed in the transformer.

"Input dataset 0 has a partitioning method other than entire specified;
disabling memory sharing."

Make the name of your stages shorter. I have made the the stage names shorter but I am still getting the same error , only change is the line number. "/data/ds/cl/int/projectlibs/dpr_cl_int/RT_BP1217.O/V97S5_djpCladdIntglogscope_nosplit_trxx.C", line 541.36: 1540-0872 (S) A string literal...

"/data/ds/cl/int/projectlibs/dpr_cl_int/RT_BP1217.O/V97S5_djpCladdIntglogscope_nosplit_Scp_ind_stage.C", line 3258.36: 1540-0872 (S) A string literal cannot be longer than 32765 characters.

Please help me with the above compilation error.

Hi, I am joining two datasets thro an inner join. These two datasets are previously sorted and partitioned on 3 keys in another job. In the INNER JOIN job I am doing some transformations to one of the dataset and then doing an inner join. I am now doing a join on 5 keys and the three keys(mentioned)...