DSXchange

Tunde How did you write these records to this hash file? Send the field names in order written and key yes/no. If you wrote these in DataStage like this: Field Key CustId Yes State Yes Addr1 No City No If CustId = 111 and State = Tx then Key = 111 : @TM : Tx Thanks Kim. Kim Duke DwNav - Navigate ETL...

Has anyone used the routine with multiple columns match keys. I have tried passing in the values for the combination of keys in different format but it still did not return a record even though the values are correct. Here is an example of my input values: 5:@FM:30:@FM:10:@FM:I -- NO RECORD FOUND 5:...

I did copy it into a different folder. Now it does not give me the "Table NOT FOUND" MESSAGE ANYMORE BUT ITS GIVING RECORD NOT FOUND". I have checked out the records are they are there. im just wondering what i could be doing wrong. -----Original Message----- From: Kim Duke [mailto:Kim_G_Duke@Yahoo....

Tunde I would never change a routine that comes in the SDK. I would copy it to my own folder and name it something like PathHashFileLookup. When you upgrade you may lose changes to SDK routines because they should be overwritten. Thanks Kim. Kim Duke DwNav - Navigate ETL Business Rules www.Duke-Cons...

Tunde No spaces and you left off the last slash. Does this hash file exist? This will not create it. HashTable = "/apps/etl/Ascential/DataStage/Projects/td_edw/HASHFILES/" : Arg1 Thanks Kim. Kim Duke DwNav - Navigate ETL Business Rules www.Duke-Consulting.com -----Original Message----- From: Babatun...

Hendrik I would suggest a hard reboot. Backups always take a lot of CPU but that seems like your process table is confused. I have seen this on NT and older versions on UNIX. In UNIX you could kill those processes and maybe recover but it would be better if you power down even on UNIX. You have proc...

Hi All We are working on a site and some days we lose connection from server when we connect. The message is the same as when the network connection to the server is broken. When I investigated the server I found that their are lots of slave processes running, we stopped the services and no one was ...

Duke, thanks for your help. I made this changes to the code HashTable = "/apps/etl/Ascential/DataStage/Projects/td_edw/HASHFILES " : Arg1 and i passed in: Arg1 = DSLink6(Hashfilename), 5:@TM:29@TM:11:@TM:39 (Hashkey), 5(returncolumn) The result was still - Table Not found. what can i do differently....

You can use the odbc driver supplied with DataStage or even IBM. If you run version 5.2 or higher of the database you can use the db2 plug-in by installing the client access enablers. This will give you a better performance than odbc. -----Original Message----- From: Dale Lampe [mailto:dlampe@caribo...

Tunde The hash file is opened using: Open HashTable To FileHandles(POS) Then FilesOpened = HashTable There is an associated named common to store the opened file pointers so the files do not need to be reopend all the time. Using these statements: Common /HashLookup/ FileHandles(100), FilesOpened Yo...

I tried using a Hashfile but for some reason it could not find the file. How do i indicate where the file is? or is there a specific place the file should be placed? thanks for the help on this. -----Original Message----- From: Kim Duke [mailto:Kim_G_Duke@Yahoo.com] Sent: Tuesday, July 15, 2003 9:20...

Tunde It needs to be a filename not an account name or project name. Key fields are separated by text marks (@TM) and not field marks (@FM). Thanks Kim. Kim Duke DwNav - Navigate ETL Business Rules www.Duke-Consulting.com -----Original Message----- From: Babatunde.Ebohon [mailto:Babatunde.Ebohon@tar...

does it matter what kind of hashfile it is? if its a filename or Account name? -----Original Message----- From: wolfgang.huerter@gerling.de [mailto:wolfgang.huerter@gerling.de] Sent: Tuesday, July 15, 2003 8:54 AM To: datastage-users@oliver.com Subject: RE: HashFileLookup Utility Cocatenate all your...

Lisa, We are running v5.2 of DataStage on Unix Solaris and extracting from DB2 (v5r1) on the AS400. We use the DataDirect 4.10 DB2 Wire Protocol Driver - ivdb218.xx (ODBC) supplied by Ascential. We have had some issues with relatively slow extracts using the ODBC stage with this driver, but it is st...

Cocatenate all your fields in one field and seperate them by @FM So you have first Name: "John" Last Name: "Miller" you send "John:@FM:Miller" as Argument for the two key-fields. Wolfgang -----Original Message----- From: Babatunde.Ebohon [mailto:Babatunde.Ebohon@target.com] Sent: Tuesday, July 15, 2...