DSXchange

ray.wurlod wrote:This question is unrelated to the thread that you've hijacked. Please begin a new thread. Or just consult the manuals.

Sorry.

I have started a new thread for this topic

Hi, We would like to use APT_TSORT_STRESS_BLOCKSIZE to increase the memory usage and hence performance. Can any one please tell us what is the default value,minimum and maximum values that we can assign for APT_TSORT_STRESS_BLOCKSIZE variable? i assume that the maximum value depends on the memory av...

Even so, your tsort operators will still be constrained by any limit set explicitly in the Sort stage or by APT_TSORT_STRESS_BLOCKSIZE environment variable. You will probably need to increase one of these also. Hi Ray, We want to use APT_TSORT_STRESS_BLOCKSIZE to increase the memory usage and hence...

Even so, your tsort operators will still be constrained by any limit set explicitly in the Sort stage or by APT_TSORT_STRESS_BLOCKSIZE environment variable. You will probably need to increase one of these also. Hi Ray, We want to use APT_TSORT_STRESS_BLOCKSIZE to increase the memory usage and hence...

Transaction Size is equivalent to the commit level, hence my answer. The Array Size is only applicable to the Upsert method and is an optional 'sub-property' of the Insert SQL property. Thanks for the reply I think my explanation of question has gone wrong. My requirement is to set the number of re...

Search here for "APT_ORAUPSERT" and you'll find the two environment variables that control that for the OE stage. Craig, Thanks for the reply. i found 2 environment variables APT_ORAUPSERT_COMMIT_ROW_INTERVAL APT_ORAUPSERT_COMMIT_TIME_INTERVAL. But these are for commit interval.please cor...

If i have set array size=20 and transaction size=13 after how many records would the insert commit? if i have set array size=13 and transaction size=13 after how many records would the insert commit? Hi, Can you please tell me how to set the transaction size in oracle enterprise stage? and also i h...

Craig, My problem is resolved. sysdate was a custom routine.We have not included read only objects while exporting from other environment which is protected environment.so the sysdate routine was missing in the new environment Now we have included readonly objects in the export and hence we got cust...

Not strange at all. :wink: Any routine that is reference by a transform is trumped by that transform's definition and thus only shows up in that list. You'll need to check under the 'DS Transforms' link instead when trying to use it in a job. Thanks craig, i was able to find DateGenericToTimeStamp ...

We got a strange problem when we exported and imported whole project from one environment to other environment. This is a problem with DateGenericToTimeStamp routine we are able to see this routine in Routines/sdk/Date/DateGenericToTimeStamp in repository. but when we try to use that routine in job ...

Datastage version : 7.5.1.1 Hi ! I have some questions about calling an oracle stored proc from datastage - 1. I have the Stored procedure stage(STP) installed. But it is grayed out for server job. Is this how it is supposed to be ? The documentation for STP does not mention that. Please note that t...

Hi, I am getting Phantom error in the server job as shown below. DataStage Job 1414 Phantom 28898 Program "JOB.1923272856.DT.1482858810.TRANS4": Line 679, Nonnumeric data when numeric required. Zero used. DataStage Phantom Finished As the members suggested,I went in to the project director...

Hi,

you are cutting wrong positions.


try with

DSLink2.VISIONDATA[38,7], then it will give 0077700 for VarChar.

if you want decimals, you can change that based on your requirement.

hope it helps

It's there, but may be disabled (greyed out). In that case you need to enable display of generated OSH using the Administrator client. I manage to get that thing activated... and here is the OSH ################################################################# #### STAGE: Lkp_StmCAtGrp_PtyNA ## Ope...

ray.wurlod wrote:No. And I did not ask for the job log, I asked for the generated OSH, and only for a portion thereof. You will find this in the job properties, on the Generated OSH tab.

When I looked for Generated OSH in job property I did not find any Generated OSH Tab. Is there any other way we can get that?