Search found 7201 matches

by admin
Wed Dec 18, 2002 10:32 am
Forum: Archive of DataStage Users@Oliver.com
Topic: DataStage 6.0 - OCI8 versus OCI9
Replies: 5
Views: 1463

..sorry Craig.. I digit so quickly that sometimes I make a mistake.. ----- Original Message ----- From: "Riccardo Tani" To: Sent: Wednesday, December 18, 2002 10:56 AM Subject: Re: DataStage 6.0 - OCI8 versus OCI9 > Hi Graig, > I agree with you that going back and update your jobs is not a good thin...
by admin
Wed Dec 18, 2002 9:59 am
Forum: Archive of DataStage Users@Oliver.com
Topic: DataStage 6.0 - OCI8 versus OCI9
Replies: 5
Views: 1463

Have nt used the OCI9 plugin yet but we have just switched an OCI8 plugin accessing an 8i on Unix via an 8i client to accessing a 9i database on Windows 2000 via a 9i client. Have not done too much so far but no problems yet. Don Walkden TAH Ltd This e-mail and any files transmitted with it are conf...
by admin
Wed Dec 18, 2002 9:56 am
Forum: Archive of DataStage Users@Oliver.com
Topic: DataStage 6.0 - OCI8 versus OCI9
Replies: 5
Views: 1463

Hi Graig, I agree with you that going back and update your jobs is not a good thing. I think you can try to add Oracle lib to the LD_LIBRARY_PATH. (take a look to the Install and Upgrade Guide on page 5-19) Hope this will help you Riccardo ----- Original Message ----- From: To: Sent: Tuesday, Decemb...
by admin
Wed Dec 18, 2002 6:38 am
Forum: Archive of DataStage Users@Oliver.com
Topic: DataStage 6.0 - OCI8 versus OCI9
Replies: 5
Views: 1463

Craig, Sounds like you are ahead of the rest of us and therefore have some testing to do to tell us what can and cant be done. This much I can tell you. As you have discovered, - OCI8 plugin will quite happily access Oracle 9 via the Oracle 8i client - OCI8 plugin will not work with the Oracle 9 cli...
by admin
Wed Dec 18, 2002 6:06 am
Forum: Archive of DataStage Users@Oliver.com
Topic: DSSetParm from within a job
Replies: 10
Views: 1420

You cant change the parameter of the current job (DSJ.ME) even if you attach it and try to change it. Job parameters are set in concrete once the job is started. The ONLY time DSSetParam works is just before you run a Run Job command, it is used for a job that is about to be executed. Thats why we a...
by admin
Tue Dec 17, 2002 7:59 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: DataStage 6.0 - OCI8 versus OCI9
Replies: 5
Views: 1463

DataStage 6.0 - OCI8 versus OCI9

Ive been testing my installation of DataStage 6.0 and hadnt run into any issues - until this morning. We are in the process of migrating instances from 8.1.7.4 to 9i (9.2.0.1) and have had success continuing to access either 8i or 9i databases using the OCI8 plugin and the 8 Client installed on the ...
by admin
Tue Dec 17, 2002 4:50 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: DSSetParm from within a job
Replies: 10
Views: 1420

Hi, Feeling like a baby learning to take its first steps ) I made the routine start my jobs with the new job parameter values, and that now works. So i started with the next logical step, and tried to start a sequence instead... The sequence runs, but the jobs below the sequence doesnt inherit the j...
by admin
Tue Dec 17, 2002 3:37 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: DSSetParm from within a job
Replies: 10
Views: 1420

Hi Tom, You can never ever change a Parameter when your job is started. You can start Jobs from routines and pass Parameters. You can start Jobs from Batches and pass Parameters. Wolfgang -----Original Message----- From: tom.peter.nielsen@nordea.com [mailto:tom.peter.nielsen@nordea.com] Sent: Tuesda...
by admin
Tue Dec 17, 2002 3:31 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Hash File maximum size ?
Replies: 0
Views: 1490

What OS? This message usually means youre out of disk space. Unless youre on AIX, where I heard a rumor there was a bug that causes this message when the write-cache flushes but everything is still okay. Good luck! -Ken --- Rui Patricio wrote: > > Hi all, > > I4m using a type30(Dynamic) hash file to...
by admin
Tue Dec 17, 2002 3:28 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Ascential Partner list
Replies: 5
Views: 621

We are on the partner list in the USA. At 06:26 AM 12/17/2002 -0800, you wrote: >Many thanks to those that have replied! Sorry I wasnt specific on >the initial request - I am looking for a partner list or consulting >companies that specialize in Datastage and Integrity in the USA. > >Thanks! > >____...
by admin
Tue Dec 17, 2002 3:25 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: DSSetParm from within a job
Replies: 10
Views: 1420

Hi Vincent, It almost sounds to good to be true ;o) but my routine doesnt do it. $INCLUDE DSINCLUDE JOBCONTROL.H JobH = DSAttachJob(JobNameArg, DSJ.ERRNONE) tmp = DSSetParam(JobH, JobParamArg, ParamValueArg) err = DSDetachJob(JobH) Ans = tmp This is the rutine that i call from my transformation, als...
by admin
Tue Dec 17, 2002 2:26 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Ascential Partner list
Replies: 5
Views: 621

Many thanks to those that have replied! Sorry I wasnt specific on the initial request - I am looking for a partner list or consulting companies that specialize in Datastage and Integrity in the USA. Thanks! __________________________________________________ Do you Yahoo!? Yahoo! Mail Plus - Powerful...
by admin
Tue Dec 17, 2002 1:13 pm
Forum: Archive of DataStage Users@Oliver.com
Topic: Ascential Partner list
Replies: 5
Views: 621

Hi Stacy, We have consultants with Ascential Integrity experience. You can call me at 440-899-3296 x25. Thanks, Janet Dorenkott At 09:44 AM 12/16/2002 -0800, you wrote: >All > >Does anyone have a comprehensive list of Ascential Partners who >provide consulting services specifically relating to DataS...
by admin
Tue Dec 17, 2002 7:28 am
Forum: Archive of DataStage Users@Oliver.com
Topic: cannot open RT_CONFIG file
Replies: 1
Views: 557

Hi, maybe that you have an access right problem. The user who first/last designed the job is not the same user with whom you want to re-import ord delete the Job. There are two approaches: - use the other user - let administrator change the right of the files and directories, so that your user has t...
by admin
Tue Dec 17, 2002 4:45 am
Forum: Archive of DataStage Users@Oliver.com
Topic: cannot open RT_CONFIG file
Replies: 1
Views: 557

cannot open RT_CONFIG file

When i try to import or delete jobs, an error occurs called Cannot open
RT_CONFIGXXX. what is the way out?