DSXchange

ray.wurlod wrote:Have you checked the DB2 environment variables, such as DB2INSTANCE, to make sure these are correctly set for the user executing the DataStage job? They need to be set in the $DSHOME/dsenv script. ...

i did check the dsenv file and the DB2INSTANCE already set there..

Hi chong, A search gave me this result : http://www.dsxchange.com/viewtopic.php?t=105703&highlight=SQLSTATE%3D08001 IHTH sam Thanks for the link :) i had search through the forum before i post up my problem here and i had tried the solution give by the link above as well.. however it's still no...

if that is the case, make sure you have given these 5 parameters correctly Client Instance name <DB2 iinstance name> Database Name <DB2 server name> Password <password> server <datastage server name> user <Datastage user name> thanks for the prompt reply :) May i know where can i find the Client In...

It is evident with the error messages that the password is wrong. following could be some of the scenarios for the same You have given the correct password but for a different server name. or correct server name but the wrong password. Please make sure that you are using both appropriate once. fina...

anyone?

hi, i had created a simple job that loads the records from DB2/UDB Enterprise to sequential file. however when i try to view the record in the DB2 stage, i'm getting the following error: >DB2 Driver Embedded SQL message: SQL30082N Attempt to establish connection failed with security reason "3&q...

ray.wurlod wrote:Corporate discounts are available. There's a link from the DSXchange home page to information about these. Premium membership money is entirely consumed helping to pay for the bandwidth costs of DSXchange.

yup, i will ask my company whether can register the premium membership for me or not

kumar_s wrote:May be less than 3cents a day. Sometimes you may find it more helpful for your professional life to get a quick solution. ...

i'll think about it, thanks

kumar_s wrote:But its easy to get the membership. By that you can help Dsxchange to help you. ...

need to pay USD99 a yr in order to get the membership...

ray.wurlod wrote:The stage variable could have been more simply derived as

Code: Select all

 Source.Rng >= LookupData.Rng1 And Source.Rng <= LookupData.Rng2 

If expression Then @TRUE Else @FALSE is redundant becau ...

mm... i dont have the premium membership so not able to read your reply

Yes, there could be several method to solve this. Do you mind sharing the method you have chosen. So that it can be useful for further searchers, somtimes you may bet better advise as well. And you can mark the topic as resolved as well. of course i don't mind sharing my method :wink: i use merge s...

Edwink wrote:hope merge stage can slove this issue

thanks for the reply

i guess i know how to do already..

hi, i'm facing problem of doing range lookup for hash file. below is my source and lookup data Source ID Rng 1 156 Lookup Data ID Rng1 Rng2 1 100 150 1 151 200 2 100 200 I need to lookup the ID and the Rng should be between Rng1 and Rng2. Both the Source and Lookup data are .csv file. I had loaded L...

The discrepancy is so large (71 against 6) that you've got to believe there's a bug in the buffering mechanism. Aileen, please report this through your support provider - it simply shouldn't work like this. That said, it was an interesting bit of detective work to eliminate all other possibilities....

I vaguely remember a similar problem in a previous project and, from memory, the problem disappeared when we put an IPC stage between the active stages. Hi all, Thanks for the replies! Yeah I have found out that row buffer is the culprit... Just noticed that although I turned it off in Administrato...