DSXchange

Hello,

I am looking for the uvodbc.config- file to add the universe connection to be able to look into hashfiles through the universe stage (i already added the VOC pointer).
Where can i find the file when datastage is installed on unix? (i might have access to the file myself)

Greetings, Roy

If you are working on a network environment you have an alternative in logging on to another workstation (WS2) with your current workstation (WS1) still active. On WS2 you still have the file toolbar because your settings are saved when closing down your workstation. So after you're logged on to WS2...

DSguru2B wrote:Stick in a semicolon at the end of the command. Also try with call instead of exec.

With the call-statement it works now (the semicolon isn't nessacary).
Thanks for the quick response.

I want to use the statement: exec dbms_mview.refresh('testroy_mview', 'F') in my after sql statement of an oracle stage (or in a new stage after the oracle stage). The error i get is that my sql statement is invalid although i can run the statement in sql. what's the easiest way to execute such a st...

If your MV is set to refresh on every commit, then don't issue intermediate commits. Leave the Transaction Size at its default of zero, which means only commit once at the end. Doesn't sound like making it a 'manual' step is an option for you. You must commit the changes in your job which will then...

I am about to use materialized views in Oracle. A property is to refresh the view when a commit is given on the master table of the view (or on demand). If i have a datastage job which gives a commit after each 1000 rows on this master table, is this going to give me problems with the view? If so i ...

i have 190 jobs for all i have to modify or any other way .... i heared that one korean characters will stored in two bytes, i our case the call centre people they are copy pasting the descrtiopns in the front ent applications at that time some korean characters are storing half byte only i want to...

make sure the oracle column type = varchar2 (char) instead of varchar2 (byte)

import the table definition again and see that the length in datastage is 4 times the lenght of the column in oracle (use this new length in your stages)

I added a hash file between the oracle lookup stage and the transformer. The performance statistics in the jobdesigner made it look like that the problem was on inserting and updating the table (the same table as the lookup) but the problem was the lookup. In the lookup stage i said to read only the...

Thanks everyone for your tips. Writing to a file to see whether the problem was in the stage was very usefull as well as the tip to drop the indexes before and add them after the inserts and updates. I also added a hash file to make sure the table I was looking up on had no conflict with the table I...

do you have an index on the table. Why do you use only on field in Oracle and not many. What do you means in such a kind of scenario by "Update" I do have indexes on the table and the table contains more columns (only one of them is varchar2 (4000)). Inserting in the table just becomes ve...

When starting a job it starts to run at a 86 rows per second. When inserting en updating more and more data to a oracle table the performance slowly decreases from 86 rows to eventually a 3/1 rows per second. The job doesn't give warnings so the problem isn't the size of the logfile. The table does ...

In a server job separate the date and time portions, subtract one day from the day portion, then re-assemble the timestamp. Oconv(Iconv(Field(InLink.TheTimestamp, " ", 1, 1), "DYMD") - 1, "D-YMD[4,2,2]") : " " : Field(InLink.TheTimestamp, " ", 2, 3)...

if you are able to define the format of the field in the flat file, use YYYY-MM-DD HH:MM:SS this is the format that datastage automtically recognizes for timestamp fiels. The field in the oracle database can be date (which also accepts time-indications). You don't have to specify any formats using t...

I think my question is not so difficult to answer but can anybody tell me the easiest way to subtract one day from a timestamp value?

being a little oracle minded i tried just adding -1 to the deriviation but when running the job, the job aborts.