DSXchange

Yes . I have done like below as you said " if Biseps_Retailer.BISEPS_RETAILER = -1 then @NULL else if Biseps_Retailer.BISEPS_RETAILER > 0 then hash_Biseps_Retailer.AD_COMPANY:",": NullToEmpty(hash_Biseps_Retailer.AD_BRANCH):",": NullToEmpty(hash_Biseps_Retailer.AD_STREET):&q...

If I know definitely which field is coming null, I can give Nulltoempty(). Please can you explain further with my example itself.

I am having the following setup Input BISEPS_RETAILER 1 2 3 LOOKUP HASH(7 columns) AD_ID | COMPANY |SUBURB|POSTCODE|FIRSTNAME|SURNAME|TELEPHONE condition is if input.biseps_retailer is matching with ad_id in lookup hash then I need to concatenate company+suburb+postcode+firstname+surname+telephone. ...

Thank you so much, Ray. It worked when I gave the command like below

if( lookup_AS_ANCESTOR1.NOTFOUND) AND (Reject_As_Ancestor.AS_ANCESTOR>0) then "R" else Reject_As_Ancestor.PROCESS_RECORD

The problem got resolved.

Hi Ray, I tried like below now using NOTFOUND for the stage variable(vRecordStatus) in transfomer, it is not accepting (HIGHLIGHTING IN RED) if (Reject_As_Ancestor.AS_ANCESTOR.NOTFOUND) AND (Reject_As_Ancestor.AS_ANCESTOR>0) then "R" else Reject_As_Ancestor.PROCESS_RECORD. Please let me kn...

Hi Ray,

I tried like below it is not working.
if (NOT(Reject_As_Ancestor.AS_ANCESTOR=lookup_AS_ANCESTOR1.BISEPS_MI_ID)) AND (Reject_As_Ancestor.AS_ANCESTOR>0) then "R" else Reject_As_Ancestor.PROCESS_RECORD

Please let me know how to do it.

Ray,
Please let me know how to use the NOTFOUND variable.

My lookup is a hash file.

INPUT COLUMN AS_ANCESTOR PROCESS_RECORD 0 0 131 141 151 LOOKUP TABLE BISEPS_MI_ID 6 7 8 131 My job has to populate "Y" for the Process_record column for the below condition if Reject_As_Ancestor.AS_ANCESTOR>0 AND Reject_As_Ancestor.AS_ANCESTOR=lookup_AS_ANCESTOR1.BISEPS_MI_ID) then "Y...

The problem got resolved after exporting(backup) the jobs using proxy server. I don't know what happened. The problem got rectified by itself.Now I am able to compile and run the jobs and it didn't throw any error.

In other projects also, same problem persists.

Yes. I asked everyone to log off from Datastage designer, director and manager and then ran the 'DS.REINDEX ALL' command from Datastage administrator. But it didn't worked.

In datastage director, I am unable to see the any of the jobs and I think the director lost the connection or logs might have got deleted.

Hi Ray,

Other jobs on the same server also giving the same error while compiling hence my administrator stopped and restarted the server. Still the problem persists.

I tried running the command ' DS.REINDEX ALL' in datastage administrator. After this also, I am getting the same error.