DSXchange

c_wf, from experience:this is not as powerfull as it looks. It is quick and dumb partitioning. Example: if you extract from one table you mention the same table as partition table. Datastage will look for min and max rowid, split this up in even parts and then fire 4 queries with the added clause r...

If you do not specify the partition table, then your SELECT will operate in sequential mode. If there is an Oracle table that specifies that your CUSTOMER data can be read four-way parallel then naming that table will allow DataStage to take advantage of it. Hi Ray, you said SELECT will operate in ...

The following comes from Datastage EE's document: Partition Table. Specifies execution of the SELECT in parallel on the processing nodes containing a partition derived from the named table. If you do not specify this, the stage executes the query sequentially on a single node. Here is my question: S...

>SELECT @ID,NAME,PATH FROM UV.ACCOUNT; Account... Owner name...... NT pathname............. UV d:\ascential\Engine uv d:\ascential\Engine main DataStage\7.1\JACOB\123456 d:\ascential\Projects\main test1 DataStage\7.1\jacob\123457 d:\ascential\Projects\test1 t2 DataStage\7.1\JACOB\123456 d:\ascential...

SET-FILE old_project_name VOC REALVOC SELECT REALVOC WITH TYPE = "V" TO 1 SELECT VOC WITH TYPE = "V" TO 2 MERGE.LIST 1 DIFF 2 TO 0 COPYI FROM REALVOC TO VOC :D Thanks a lot! I have done whatever you said. But I got the following error message when I tried to log in: Failed to at...

Thanks, Arnd and Ray! 'SELECT NAME FROM UV.ACCOUNT', I got different name for different projects. Such as 'DataStage\7.1\hostname\123456' and 'DataStage\7.1\hostname\123456'. I don't know how DS assign that number. I inserted a new record with NAME = 'DataStage\7.1\hostname\123456'. After I assigned...

INSERT INTO UV.ACCOUNT(@ID, PATH) VALUES ('ProjectName', '/dir/dir/projecctdir'); You need to be in the UV account and in the dssh shell (uvsh shell) to execute this command. Wow, you must be a genius! Gee. I just inserted a record. But DS still can not recongnize this new project. By the way, do y...

I am bored to death

Wow, the following is what I have done: 1. Create a new folder 'test'; 2. Go to 'test' and enter 'UV' to create universe environment; 3. 'CREATE SCHEMA test'; 4. copy files from template folder; But I still do konw how to add a record into UV.ACCOUNT. Maybe that's the reason that DS can not recogniz...

I have thought DS_JOBOBJECTS just stores the compile object codes?:? But why the description field in DS_JOBOBJECTS is empty? I am wondering which table stores the pseudo codes(just like .dsx file)

Many thanks to you :D

Wow, what a story.........

DS will create a RT_CONFIG1 file when I create a job. But why there's no content in that table? I used "SELECT * FROM RT_CONFIG1;"

Thank you so much!

I just created a "test" uv account, and then copy all the files under Template into it. And then "CLEAR.ACCOUNT". But DS still can not recognize this "test" account..........

Thanks. I knew the ordinary ways to create and delete projects you have metioned in your reply. I just want to know more about the mechanism of DS. By the way, do you know which tables store the exact job source codes? Are they RT_CONFIG1...n, RT_LOG,RT_STATUS,RT_BP? If so, is that possible to expor...

Is there anyone who know how to use UV command or DSSH to create or clear DataStage project? I can create a universe account with uv, but I don't know how to let DataStage to recognize this account. And I can delete jobs in a project by "DELETE * FROM DS_JOBS", but I still don't know hot t...