DSXchange

There's no rule for how they 'need' to be set, it's up to you and how you want them set. Array Size controls how many records at a time are written to the database and Transaction Size controls ... I am not a premium member and so unable to see your full reply. Can you Please post that again so tha...

Hi, I m having a similar problem. The error i got was DataStage Job 870 Phantom 2765 Program "DSD.StageRun": Line 571, Incorrect VOC entry for 0. Program "DSD.StageRun": Line 571, Unable to load subroutine. Attempting to Cleanup after ABORT raised in stage Job1..Link_Partitioner_...

Hi ArndW i am not a premium member. So am not able to view ur reply. But from whatever u i got, i will have a link partitioner where i will be loading 5 seq. files at simultaneously(after enabling inter process row buffer) making few columns as the key so that all the seq. files have different data....

You asked what you should use to load 10 million records, I suggested 'sqlldr'. Sqlldr does not create data files nor did I imply that it did. DataStage creates both the file to be loaded (the .dat file) and the file that tells sqlldr how to load it (the .ctl file) and then you use sqlldr to do the...

How do you transfer files? Seriously? How would you do it if you didn't have DataStage? There's your answer. I dont think you understood me. I meant how will you transfer the dat files from DS server to Oracle server? And lastly, you should use sqlldr. No stage. SO you mean i should create my own d...

Short answer - yes. And you transfer both files if you are going to transfer anything at all. How do you transfer files? :) I'm going to go out on a limb here and disagree ( :shock: ) with 2004 Ken on this one point - the assertation that you must co-locate the load files with the instance to do a ...

Can You Please explain in detail how its happeing? Actually i have never used Manual option in Ora Bulk Load. But i have understood this much that when i give it as manual, it creates a dat(data) file and a ctl(control) file. This dat file is nothing but the sequential file(correct me if i am wrong)...

When i was thinking about running multiple instance of the job, i wd change my strategy to Insert Rows Without clearing. Sorry if i mislead u all. I will give the truncate command in the Before Job Subroutine. But the probelm is how to partition the incoming records into say 5 flat files? Is there a...

Hi All, i have to load some 10 million of recs into a table. Right now i am doing with Truncate and Load. but this job is taking 7 Hrs to complete. I switched to Ora Bulk Loader(automatic) Plus IPC but still it takes 3.5 Hrs. i read about multiple instances and now i am wondering whether i can use t...

Does DataStage 7.1 support Informix 7.3 & Informix 9.3 as Source & Target Databases.

I have a requirement to load data from Informix 7.3 to Informix 9.3. Is this possible in DataSatge 7.1

No, you cannot. If you need different column sets for insert versus update, you'll need two links. ... You can have different no. of columns in the Update and Insert Clause in a job. i tried and the job ran successfully. In my job i didnt want to update some of the columns But while inserting i wan...

Most of the Jobs having
Ora 9I -> Transformer -> Ora 9i.

Both target and source databases are Oracle. There will be some after sqls in the job. Datastage used is 7.0

My DS jobs in production are running very low. Very slow in the sense 1 row/sec also touched. It is fluctuating between 1- 10 rows/sec..

I dont feel there is a problem in Jobs. Can anyone suggest what to be done. Right now they are running like that.

I need to store Oracle Errors in an error table. By using DBMS code we can store the Oracle Error code. But i need to store the description of that code also. i.e if 0RA-0001 ERROR occurs, i need to store unique constraint error also. Is there any way to do this in Datastage

We are not setting any other environment variables there.

Also the stage ORAOCI7 is a plugin