DSXchange

Then the key column you are selecting from in the lookup ( Reference Link) is set to Nullable NO. Please set it to Yes.

How did you determine that the output is blank and not null? Did you write to a File, dataset or table?.. Or the constraint set in a transformer/filter is not working as expected..

As search for

deadlock detected while waiting for resource

retruns 19 matches. See if any of those help you in resolving the issue.

If any of your three fields are NULL then your output is going to be NULL, bcause concatenation with NULL will result in a NULL. You will get the same length in the output only if your are concatenating CHAR fields. If you are concatenating varchar type fields then the length might differ. If the ab...

Thanks for the clarification.

IBM has given a patch to fix this issue.

Ray,

Wouldn't the Stable sort option in the Join stage do the same function?

Hello, Some jobs keep failing for the error below. I set the APT_DB2LOADER_TIMEOUT to 5000 and still no luck. The target is a DB2 table and the job is attempting to do a db2 load. Failed opening fifo /Scratch/ordb216303200189da23_.013 after 90 seconds: No such device or address. Please review DB2 lo...

I have not contacted them yet. Wanted to get some feedback before doing so.

Hello, If I set the APT_STRING_PADCHAR=0x20 then it pads spaces to the character and varchar type columns as well. This is causing quite a bit of issue, because I want only the character columns to be padded with spaces. The varchar type columns are long and consume lot of space if padded with space...

I did od -c on the file and found the corresponding ascii value (226). I used the convert function with char(226) but it still does not remove it.

Yes. It is actually one charater. Let me do some research on the od -h.

Thanks

Can we have DS 7.5 and DS 8.1 installed and running on the same Unix box?

Hello,

I am unable use the BigInt column type in the Stored procedure stage and get the right results. Is it a known bug in DS 7.5.1A? The BigInt column always gets set to the maximum 32-bit Integer value 2147483647.

Thanks

Hello, One of our jobs failed during a join because the scratch space defined on one of the nodes got filled up. The rest of the nodes did not even come close to filling up. If I define additional file systems for scratch in that failed node will it scale across the rest of the file systems and henc...