DSXchange

Yes , I did

Hi, I have done some research to increase T30FILE size in uvconfig file but when I am trying to run uvregen, i am getting this error .uvconfig: No such file or directory uvregen: error during regen, process aborted I also tried to run using uv -admin -regen , and this runs without any warnings/error...

It worked just fine

Thanks a lot guys

I tried

NullToEmpty(lkp_CRC.CRC) or NullToEmpty(CRC) <> NullToEmpty(lkp_CRC.CRC)
OR
NullToEmpty(lkp_CRC1.CRC) or NullToEmpty(CRC) <> NullToEmpty(lkp_CRC1.CRC)

but its not working too

I am trying to implement this in constraint

Hi, I have tried various logocs,but all in vein.I am sure one of you gurus can really help me out. I want to implement a lookup in the transformer,which if met, should not bring that rows in the hashed file. IsNull(lkp_CRC.CRC) or CRC <> lkp_CRC.CRC OR IsNull(lkp_CRC1.CRC) or CRC <> lkp_CRC1.CRC I a...

Thanks Keshav,

It worked liked a charm

Really appreciate your help.

Hi,

When I am using NOT LIKE in a transformation, DS is throwing error : error compiling sub routine for stage.

If there any other function for accomplish following task:

IF DRS_PS_D_PRJ.PROJECT_ID LIKE '8%' Then 'Y' Else 'N'

Thanks

Thanks for the quick reply.

I want to use this in a derivation column of dynamic DRS database.

Hi, This should be a pretty stright forward question to all you gurus. I have a field which is storing date in the format like(TIME_STAMP) : 2009-04-15 00:00:00 1900-01-01 00:00:00 2009-02-26 00:00:00 What will be the function to replace the dates "1900-01-01 00:00:00" to NULL.I wrote this...

Thanks Chulett,

Just found the solution

chulett wrote:Been discussed here alot, search for "Computed blink" to find the conversations. ...

HI, Can some one tell me what is this warning about? We are getting this for inserting data into HASH file. Computed blink of 0x890 does not match expected blink of 0x0! Detected within group starting at address 0x80300000! File 'G:\\DS_Projects\\EPM9KLS/HASH_CRC_ACTIVITY_LOG/DATA.30': Computed blin...

ray.wurlod wrote:You can copy blocks of lines from one DSParams file to another. Try to preserve alphabetical order within sections in the new DSParams file. ...

Thanks .. issue resolved

Thanks a lot again

Hi,

We have created a new project and obviously environment parameters are empty right now in Data stage Administrator.

Is there is way to import Environment variable from DSParam file directly, or do we have to manually write all the environmental parameters in DS Administrator?

Thanks

Hi,

Whats the best way to create a new project from a existing project .

It is on the same box.

Thanks