DSXchange

Thanks for the Reply, i will check it out by today.

Please forgive me If i am so dumb to understand the logic. Let me explain my doubt with some example Snapshot of my first 2 rows in Source Key1$Key2$EFF_DT DD$EE$01/01/2005 GG$HH$01/01/2005 Snapshot of my Hashed File DummyKey$SRCMATCH1$SRCMATCH2$LKPDESC$EFF_START_DT$EFF_END_DT 1$CC$DD$DESC1$01/01/20...

The post that you have referenced, read it carefully. In that you only specify the dummy column (running number) as the key and no other key. This way you will retain each and every row and not lose any. Then you can use my derivation to get the range lookup. If we match the @INROWNUM with dummy se...

Hi Love

I have already tried with universe stage and it doesnt improve the performance much.

Hi All I want to perform a date range lookup Something like Source.key1 = lkp.key1 and source.key2 = lkp.key2 and lkp.EFF_START_DT <= Source.EFF_DT and lkp.EFF_END_DT >= Source.EFF_DT Now we are doing a lookup directly with the database. But this affects the performance very much. we are getting 10+...

I hope DSJobStartTimestamp will do this. If not write a custom routine to return date and time, then call it in the sequencer and pass this value as a parameter to the server jobs.

Thanks Ray and Kim, it is working Fine as expected.

My requirement is to append a specific string with all the Jobnames and Hashedfile Names. Suppose if my jobname is like "Stage_Product", I want to rename it as "Stage_Product_Test". Like wise if my Hashed file name is "HASH_PRODUCT", I want to rename it as "HASH_PR...

Arndw,

Sorry for that. I read ur earlier post wrongly

you can't tell directly if a column is char or integer from the hashed file definition

I read it as You can, because i am desperately looking for the solution. Sorry for the confusion.

I will try to achive this by some other logic.

Hi Arndw,

Can You please show me , how to use this to identify the datatype of a column in the Hashed file

1. The format/justification such as "12L" or "4R", and
2. An attribute for a conversion such as "D4/E" or "MD2".

At sometimes, For Char values, we will be having 0. In that case , I want to return False.

Basically I want To return @TRUE or @FALSE, from the routine. I will explain some scenarios. Hashed File Name = Hash_TableName Col1 [Key] --> Datatype = Char Col2 --> Datatype = Integer The Values are like as Col1 = - Col2 = 0 In this case I want to return True. We may also have values like Col1 = a...

Hi Arndw,

I want to do this in a routine. My input to the routine will be the Hash file name and my output would be either True or False based upon the scenario i have explained.

I am having a Situation to retrive the datatype from the Hashed File. I will get Hashed filename as a Input, and I have to do a Select from the Hashed file. Let me give u a example Select Col1, '|' , Col2 From HashedFile. If Col1 is of Datatype Char and the corresponding Value is "-" and t...

Hi vijayindukuri, For the routine you have posted, there is some specific ways to write the Parameter File. If Var = 1 Or TrimF(TrimB(Field(EReplace(FileLine, '[',""),']',1))) = TrimF(TrimB(JobName)) Then Var = 1 If Var = 1 And TrimF(TrimB(Field(FileLine,"=",1))) = TrimF(TrimB(Pa...