DSXchange

Launch install.exe from client folder of the SAP R/3 PACK for DataStage

Well I got help from Ascential support. Figured out dsidoc.dll depends on the existence of dsrpc32u.dll and dssapucum.dll which were not registered on my machine
Once I registered them, the jobs ran fine

I have WAS and IIS/DataStage on one server. The metadata repository is on SQL server 2005 and this resides on a different server. Will that be a cause? Operating system is Windows 2003 server for both the server machines.

Thanks

When I connect to Designer /Adminstrator or any DS client on 8.0.1, it takes a few minutes to autherniticate It is frustrating sometimes and we are not able to figure out why this takes a long time. This was not the case with 7.5 or earlier versions. We even tried turning off the virus check just to...

Setting up a user in DataStage 8.0.1 involves the following 4 steps: (1) On the IIS Admin console, set the Suite Role for the user(eg Suite Administrator/ Suite User) as appropriate (2) On the IIS Admin console, set the Component Role for the user(eg DataStage and QualityStage User/Administrator etc...

Hi: I have installed SAP PACK for R/3 for IIS 8.0.1 I have a job which reads from iDoc and writes to a sequential file The connection details to SAP are tested since I am able to fetch the metadata for iDoc However, When I run the job, I get the following error ds_loadlibrary: Win32 error in LoadLib...

Which type of User registry are you using to authenticate - Internal User Registry/ OS Registry / LDAP ?

I used Internal User registry and had no problems loggin in. Did you configure the user through the IIS Admin console with the required privileges/ roles?


IHTH

Hi: I am having problems configuring IIS to use LDAP registry. I have been following the Admin guide in setting this up. While install, the user registry is chosen to be OS registry. Then I configured LDAP security at the WAS administration console. I set up an user as Administrator, Confirgurator, ...

Thanks chulett! I am using a Row merger stage in the job. Figured out just now that this is where the quote character was getting inserted. Instead of the default quote character " in the Format tab of Row merger, I now gave 000. And the hash file does not get any double quotes in the data. Tha...

Yes, I compared using View Data option and I could see double quotes enclosing the varchar data (key) fields

Thanks for the quick response! I am creating the hash file from a SQL 2000 table. There are a couple of active stages inbetween - Row merger and transformer. In the transformer, I use CRC32 function on the incoming record and load the keys and output of CRC32 function into the hash file. CRC32 colum...

Hi I have created a hash file with 6 columns as keys, 5 of them are of Varchar and 1 SmallInt. When I try to do the lookup using the hashfile, the lookup doesnt return any records even though there is a match from the source. I compared the data between the source sequential file and hash file. The ...

Hi DSGuru2B. Can you please elaborate on your reply on having ADAM as "stand-alone" ?

Thanks DSGuru2B for researching on this. I came to know we can do writes using ADAM. I am yet to read about it fully though.

I am not even sure right now if I can use SQL queries with ADAM or use command line functions to work. Has anyone come across this?

Appreciate any clue on this!

Thanks

Hi: I read DataStage 8.0 services provides complete connectivity to LDAP http://www.dsxchange.com/viewtopic.php?t=96758&highlight=ldap Can someone please elaborate on that? Right now I am able to read data from LDAP. We are also looking at insert/updates on LDAP using DataStage. I still havent f...