DSXchange

Hi

I performing some calculations and I dont want the values to be rounded off

for example

a value such as 1997.899 after the calculation should be 1.997 and not 1.999

I want the fields to be stored in the database as right justified...how do i accomplish that throuhg datastage You threw me off with FMT reference, since that isn't applicable to "view data". You cannot right justify in that window, the only formatting DS really uses is the field width to ...

Yes using the View Data both in the designer and the DB2 Client it shows as left justified.

When I view the records in the database through datastage it seems all the fields are left justified...how could I left Justify non numeric fields and Right justify numeric fields....I used the FMT Function but I dont think I am doing it right ... Pls advice

The Condition for my lookup is if my input date is between the start date and end date then to retrieve the start and end date. The end date could have nulls ( to indicate that they do not expire ) My lookup table has a custom SQL like the following ? WHERE TBL_TEST.TEST_ID=? AND TBL_TEST.EFF_DATE<=...

I resolved the issue by using a custom SQL statement on the lookup Database:

SELECT START_DATE, END_DATE FROM YourHashedFileName WHERE START_DATE <=? AND END_DATE >=?;

(Used the above logic from a contributor )


Thanks a lot guys

In the Key expression editior how do I validate a column if I need to check the input date is after the lkp date

Hi, I am performing a lookup and the result I get is not the desired result. SrcTable:B,C LkpTable:A(Key),B,C,D The lookup is based on the Column B 1.I unchecked the key in Column A of the lkpTable 2.I connected the SrcTable Col B to LkpTable Col B My Objective is to obtain column D if the SrcTable....

Thanks a Lot guys

cosec wrote:ID=KeyMgtGetNextValue(JobName)

Will This routine create unique keys ??? everytime the job is run....

I will be inserting records to a target table and I don't want it to have the same ID...

Is this sufficient....??

Where is this Value stored ? Is there a table Datastage uses to store this value ? and is there a way to change this value ?

ID=KeyMgtGetNextValue(JobName)

Will This routine create unique keys ??? everytime the job is run....

I will be inserting records to a target table and I don't want it to have the same ID...

Is this sufficient....??

I am using the TIMESTAMPDIFF in my DB2stage to check the difference between the current timestamp and another timestamp....It seems that the result is only estimated as it considers the number of days a year as 365...Any other solution to this..? What about Days(ts1)- Days(ts2) ?

Is it better to use stage variables when you can do the same thing without using it ?

I want to do a lookup based on a stage variable and not based on any of the columns in the input link. Is it possible ?

No Matches....OK thanks

ArndW wrote:What happens when you manually enter the SQL with the appropriate key inside your favorite SQL query tool - do you get no matches or 82?

You can lookup on the database and hashing doesn't apply in this context in server jobs (is this a server job?)