DSXchange

Hi, I am getting an error while installing DS7x in Microsoft Vista OS in local PC.The error is "Setup failed to apply license information.Check uvregen-output.log".That file mentions that "Must be root or base administrator to run this process.Verify DSHOME setting." I found the ...

Hi Guru,
Thanks for the idea.It works with some extension of that.In the selct query, I put a space after the comma and then put 0.0.
Ex:select x,y, 0.0 from a; where there is a space after the comma (which is there in the suffix of y).
Awkward.Right?
Thanks again
Poornima.

Hi, In the source DRS, I am doing a UNION of 2 queries.In the first query, I have 3 decimal fields which are not there in the second query.So to compensate that in the second query, I placed 0 in their places.It works fine in Oracle.But in OS390, it fails giving the message "An unexpected token...

Try running the Job with Array Size and Transaction size as 1. :D

Hi Ramesh,
Yes I am using create table option inuniverse.I have already checked the "Create table in target Database" option.

While using a Universe and trying to create a table through th universe in run time, I am getting an error like "DSD.BCIOpenW call to SQLExecDirect failed. Caret tabel......SQLSTATE=S1000, DBMS.CODE=950302 [DataStage][SQL Client][UNIVERSE]DataStage/SQL: unexpected" The datasourcename I had...

Hi, Can anyone please tell me what 'privileges' a user needs to have in order to create tables within the Ascential Universe? When I run a Job which uses Universe Stage, (after logging inside as a normal user) the create common inside the Universe fails giving an error "User aa is not an SQL us...

Hi,
After setting up a new Server in Windows, when I try to run a Job, it is giving an error "Could not load drsoci.dll". Can anyone tell me what settings I have to make?
Poornima

Ray, I using a normal DRS and my Job should work independent of the databases(Oracle/DB2/SQL Server).The issues I quoted is DB2 specific and there the undelying datatype is Date.But while passing the value to the target, the DRS automatically takes the time part.That is why I am using the Metatag an...

Hi Andal,
This is because my target accepts only the Date and not the DateTime. If you use the Generated one, it will automatically append the Time part also to the Date which I am passing since DataStage will convert into that format.That is why I used the Userdefined one.

Hi, When I converted my target DRS to a userdefined SQL and when I used %DateIn to a Date field, Data Stage is not taking the same. If I use a %Substring, it is taking. This issue occurs in DB2 OS390. If I won't use this ,Datastage is giving an error Inserted value too larger for the column since th...

The error is no way related to a particular Job.So I don't think it is pertaining to variable of a particular projecr. The error remains the same whatever Job I run in the project. I feel it is some way related to some settings only.

I have a Job which loads a Hash File from a DRS.The job aborts with an Abnormal termination.The project is set newly.All jobs under this category have this error.Can anyone please help? From the reset this is what is returned under previous run: 1st entry: From previous run DataStage Job 1512 Phanto...

Hi Ray/Amsh.Thanks. Even still the error persists.For a safer side, I put Substrings( DSJobStartDate:' ':Substring(datefield,12,9) ,1,19) Still it remain the same. As I mentioned, this work if I hardcode '00:00:00' for that last part instead of substring.But then my requirement is failing. Thanks, P...

Hi,
My datetime field in the target is of the format 1900-01-01 00:00:00.