DSXchange

I believe ODBC or OCI are the only 2 ways to talk with ORACLE. Even if u want to use DS BASIC or shell script to read the data, they will be using the DSN you create using ODBC or native drivers ...

Care to share why ODBC is not option for you.

did ur idea work. U shld pass the number of rows from the Trans1 to Trans2 in ur approach. You can achieve this by writing the number of rows in Trans1 to a flat file and use that flat file in Trans2. Or why can't you just delete manually urself or use UNIX to do it. U can even do this using UNIX. j...

The RT_BP is usualy under the Parent/root directory of your project.

In your case if name of you project is 'test' then I guess the below path u mentioned is correct. Check it again with proper rights.

dir ./export/home/dsadm/Ascential/DataStage/Projects/test/XXXXXX: Permission denied

I just looked up Ascential website for course catalog.

http://www.nichewareinc.com/ascentiallm ... rseID=1617

Check the above link and they have a class in a week in Atlanta.

Good Luck ..

As you are on UNIX system, why don't you use the 'cp' command of UNIX and make the 2 files into 1(as u said they have same MetaData) and then do the Transformations on the file you have just created. You can run this 'cp' command as a before-job sub-routine from job properties. Well it worked for me...

See there we go ... now we have an authoritative answer to use DS export and import functionality.

Pinkesh, You can search on this forum for this. Logon to your DS Administrator and do CLEANUP and this will rebuild all the indexes and this might fix ur problem if your DS_JOBOBJECTS file is corrupted. See below posting for Ray's answer on a similar situation. http://www.dsxchange.com/viewtopic.php...

I would suggest the later... full project export and import on the another
machine ...


Happy Holidays !!

I have been waiting for Kenneth or Rau or Teej to answer this from the time you have posted. I guess they have already left for Christmas. But they haven't till now. So, I know this may not solve your problem... but just one thought ... did u try restarting the server. I know this may not be the sol...

If they are sequentially connected, they will be defenitely execute the order you have connected them. If you have them in parallel or in simple words if the source for the second transformer is independent of the first transformer, then both the transformers(1 & 2) will share your CPU time. Sou...

How exactly are you trying to achieve this without DS export and import?

interesting to know?

Can you actually post it here if possible Craig. Even I need something like that as we are having plans to move our Server from Windows to UNIX.

we need to call lot of func from other groups what other functions are you talking about. and for your primary question can we call DS jobs from other functions .. yes.. one way is to use command line for calling the jobs. you can write UNIX(whatever shell) scripts to call both stored procedures an...

there are many things that you need to keep in my nind before doing this. The new features/stages introduced in 6.2 and that were not in 5.2 would defenitely be a problem.

I assume you would have already thought about this. But worth mentioning I guess.

One way can be is write the Stage variable to a file and you can use that file as an input in the next stage.