DSGetCustInfo Usage

[karmadasai]

I would like to keep information about a ORAOCI Stage , I need the SQL string defined by the user.


Do you have exemples with the DS function :

Code: Select all

DSGetCustInfo(JobHandle, StageName, CustInfoName, InfoType)
* Possible Var InfoType tokens:
  Equ DSJ.CUSTINFOVALUE            To 1  ;* Cust Info value
  Equ DSJ.CUSTINFODESC             To 2  ;* Cust Info description
  Equ DSJ.CUSTINFOPERINST          To 3  ;* Is custinfo per instance

When I use it , the job never stop ....

[ray.wurlod]

DSGetCustInfo() is only for parallel jobs. You can get a list of the custom properties of a stage from DSGetStageInfo() - for a parallel job, of course - and then use DSGetCustInfo() to get the value and description of each.

Do not use DSGetCustInfo() with server jobs. They may enter an indefinite (infinite?) loop.

[karmadasai]

Do you have a solution for Server Job ?

DSGetCustInfo() is only for parallel jobs. You can get a list of the custom properties of a stage from DSGetStageInfo() - for a parallel job, of course - and then use DSGetCustInfo() to get the value ...

[DSguru2B]

DSGetStageInfo().

[ray.wurlod]

There is no equivalent for server jobs.

I don't believe DSGetStageInfo() can retrieve user-defined SQL.

You could, of course, retrieve the SQL from DS_JOBOBJECTS (a "hack") but I'd refrain from this approach because it ceases to work in version 8.0.

Probably easiest is to use DSGetLogSummary() function.

[DSguru2B]

I would like to keep information about a ORAOCI Stage , I need the SQL string defined by the user.

I missed out on that part.