DSXchange

Hi all, requirement is like this, Unique numbers should be generated based upon the composite primary keys. for example, Inlink.Field1 Inlink.Field2 Inlink.Field3 Inlink.Field3 65465 'kjdjfsak' 5645 'kjdfoi' 68845 'doewlks' 8556 'dkgjioe' 65465 'eujdskd' 6455 'doewl' Outlink.Field1 Outlink.Field2 Ou...

Hi chulett, Thanks for your response, but I noticed that while executing query from a oracle its displaying like Inlink.Field1 2008-09-06-20.30.355465 what I had posted is not the one to be converted. I could not able to make a query in oracle itself. But while running the datastage job and populati...

Hi All, how to convert timestamp format Inlink.Field1 2008-09-06 20.30.156546 Outlink.Field1 2008-09-06 08:30:15 PM I had tried using Iconv and Oconv like.. Oconv(Iconv(Inlink.Field1,'D-YMD[4,2,2] MTS.'),'D-MYD[4,2,2] MTHS') the above derivation not returning any values to the Outlink.Field1 Any sug...

Hi Ray, I think, I am not guiding in different way. My doubt is that whether the non equality constraint can be used for date field. how to get the records that is greater than lk.latest_date? the job runs successfully for equality case. since Hash file will work for equality constraint (as you clar...

Hi Ray, that particular field is NOT NULL so its working for the equality constraint. Inlink.EffDate field will not be NULL. so its working for the equality constraint. As you said Hash file will work for equality constraint only can you suggest which will be used for non-equality constraint. Thanks...

Hi all, I have an issue, when stoping and starting the datastage server. After following the procedure in administrator to stop the datastage for few hours and then starting the datastage server. I could not login in to the datastage designer. Its showing the following message... Failed to authentic...

Hi Ray,

I am using lk.latest_date as the key column and the format is same for both input and lookup. that is, yyyy-mm-dd format.

whether odbc stage could be the alternate for lookup hashfile to implement the logic

Hi all, I want only the updated records to be inserted into the target table in oracle. I am having date field with that I am taking latest date to a hash file and looking up in a transformer. In a transformer constraint if i am using lk.latest_date = inlink.EffDate, its working fine but the same is...

Hi all,

We have to stop the datastage service and after some database process again we have to start the service.

where can i find these details for SUN SOLARIS operating system?

any suggestions will be most welcome

thanks in advance

Hi all,

I had gone through the posts, one of the post having functions used like,..

"userstatus(DSLink113.COUNT ) "

where to find for the userstatus function, I could not able to locate it in server 8.0.1, any one can help me by sending me the location of that function

thanks in advance

thanks ray and chulett

I had designed the new job, its working for the same constraint

hope I can now guess these things

in Hash file I had only one value so that I can equate to that value only.
secondly, I had made some of the fields wrongly mapped

thanks for your patience and suggestions

If I am comparing the dates as it is, i.e 'Mar 08' , its returning the values like alphabetical order comparision. i.e., for the logic Inlink.Field1< Lkuplink.Field1 where Inlink.Field1 has values like('Jan 08','Feb 08','Mar 08','Apr 08','May 08','Jun 08') and Lkuplink.Field1 has 'Mar 08' but the ro...

yep, its been identical. even i modified the query to get only the month. i.e like Oconv(Iconv(Inlink.Field1,'D MY[A3,2]'),'D M[2]') its output came as 03 02 05 and same modification in lookup also Oconv(Iconv(Lkuplink.Field1,'D MY[A3,2]'),'D M[2]') output as 03 even then the comparision doesnot work

Put your expression in a 'test harness' (a small routine) then test to ensure you are getting what you think you are getting from it: Ans=Oconv(Iconv(Arg1,'D MY[A3,2]'),'D-YMD') I have checked the above expression, it's working fine. Its giving output as expected i.e 2008-03-01 I am also getting th...

or my doubt is whether DATE field can be equated or not, if yes how can get the rows greater than the particular date eg: Inlink.Field1 Inlink.Field2 Inlink.Field3 2008-03-01 hafjkdhk djflsdkf 2008-02-01 gijdjgdkl kkdfds 2008-05-01 adfklsdf kfdslfds In look up hash file, I am getting the date in Lku...