DSXchange

ray.wurlod wrote:That looks OK. I presume SQL Server is listening on port 1433?

That's right. SQL Server is listening on port 1433

Hello Ray, I have checked the entry in both these files. Please find the entry for your reference also. 1. Entry in uvodbc.config <RECON> DBMSTYPE = ODBC 2. Entry in .odbc.ini [RECON] [SQLServer Wire Protocol] Driver=/u01/app/datastage/product/Ascential/DataStage/branded_odbc/lib/VMmsss18.so Descrip...

Please suggest me how to solve this problem of connecting to SQL Server. I guess i have already given the required details.

Hi

I guess the problem is of semaphore initialization. I don't have much idea.

Please correct me if i am wrong.

You don't indicate what hardware / operating system you are using, which can be important in cases like this. Also, in the readme for your server install, is the SQL Server Wire Driver you are trying to use supported on your platform? The details are 1. 880R, 4-CPU, 80 GB RAM.Solaris 2. SQL Server ...

Hello Mukund, The cache size setting can be used for configuring the size of the read and write caches. When a Hashed File stage writes records to a hashed file, this can be written to cached rather than writing to the hashed file immediately. Similarly, when a Hashed File stage is reading a hashed ...

Just correcting the previous message. I want to derive wekk of the Year from the date. How to go abt it.

Hi all,

i want to derive Week of the Day from Date. Is there any way by which i can acheive this.

Hello Kenneth, I am not questining ur design but splitting of the files i have already done. Besides i have used 11 sortcl scripts for aggregation the Records in the next job. The speed which i am getting for buckting is aby 3500 rows/sec as i have many others buckets also in this application. If i ...

Hi all, Ray, i tried the solution suggested by u but that is not what i want. I want specifically the value of duration in the proper bucket if the condition is satisfied. Kenneth Bland, thanx a lot for the solution but it is taking more time then the earlier design. My only problem is the performan...

Hi, I have to create a Job in which Buckets are created on the basis of the value of input column. for eg,i have one Column Say Duration, the values are Duration 2 7 10 18 33 49 99 125 185 308 700 Now In the output i want Duration_0_5 Duration_6_15 Duration_16_30 Duration_31_45 Duration_46_60 Durati...

Hello All,

I want to extract Lotus Domino Data. Can anyone suggest me how to go about it.

Hi Ariel, I have a solution for ur problem. U do not need to use Folder stage at all. U will be creating a file with the names of the folders u want and then reading that file. the Implementation should be as follow 1. In before Job subroutine execute DOS. The command is dir /b #PathName# > #PathNam...

Hi all, I have a job which uses orabulk stage (sqlldr) for loading the data into the table. yesterday something went wrong with the database and thus the database server was restarted. The loading job was running at that point of time. Using uvsh i cleared the staus of the job and then restarted the...

Coming back to my question, How to acheive the desired output then which is mentioned in my first mail