DSXchange

What is the data type of the column P_ID in your target, and how you have defined in your job?

You can simply use the Sequence job, and set the property as "Reset If Required, then run", So if the was aborted in the previous run, it will reset and run the job. And if you want to get the status of the job, you can write a routine or Subroutine, something like FUNCTION GetJobStatus (J...

Try
Change the " " (Space) to your desired delimeter.

There is a way, to append all the jobs to a single dsx. Do it as like what you are doing now, and after each execution append the dsx to a different file. you need to do Some thing like ::****************Begin Export Loop For /F "tokens=1" %%i in (C:\export\DsxList.txt) do ( echo **** Expo...

Thanks , I understood it.

Ok , Thanks for the immediate reply Ray.

Is there any other way to enable it, by calling another job, wherein I can use OCI Stage ?

The topic is here The dynamic RDBMS Stage takes advantage of the native interface of the database. You can also load data in bulk mode. PeopleSoft's EPM delivers hundreds of jobs to move data from the ERP applications to the different layers of data warehouse. Only one version of each job is deliver...

In one of the post, i have read that we can enable bulk loading in DRS Stage also. Can you please explain , how to do it?

Ray,

Can you Share some examples related to writing "main" program?

You can create a dummy job and call the required routine, where you can pass the arguments as job parameters, and execute the job in command line. And set the output of the routine to UserStaus.

What Stage you are using for Selecting the rows from Database, and what is the exactr error you are getting?

Yes , you can do that. Define the first routine inside the second routine, by using DEFUN. DEFFUN FirstRoutine(Arg1) Calling "DSU.FirstRoutine" And then in your code, you can just get the values like TVar = FirstRoutine(SomeVal) Or If this doesnt solve your purpose, Ray Recently posted som...

Use KeyMgtNextValueConcurrent(YOURJOBNAME), so it will maintain sequence based on each job.

Yes, Your sequence number will start with 1, and for the next run also, it will give you the next max number. You dont have to do any extra settings for achieving this.

But when using, consider changing 'whateverstring' to some meaningful string.

While logging into the Datastage, are you using OMIT option,
If you are using OMIT, these type of problems occur. Log in by using proper credentials, and import the dsx.