DSXchange

It seems the SDK routines are not catalogued in the standard way. The DEFFUN statement you need is DEFFUN UtilityRunJob(JobName, ParamList, RowLimit, WarnLimit) Using "DSX.UTILITYRUNJOB" Note that the catalog name is all upper case. -----Original Message----- From: Shrikanth Ramanathan [mailto:ar_sh...

The Oracle documentation suggests that when this error occurs, you should contact Oracle customer support. Have you done this yet? At least Oracle Support should be able to tell you under what situation this error occurs, which might help you in solving the problem. It is possible that the problem l...

I find it a very useful tool, using MS Access as the target. Have not had any problems except when I moved the Doc_Tool.mdb file and neglected to reconfigure the ODBC data source definition!

Hi, all One of my DS job aborted, with the error message: "FactXXX.CLARITY_LOOKUP: ORA-24371: data would not fit in current prefetch buffer" It seems an internal OCI error has occurred, after deleted all OCI lookup llinks of this job, the job works normally. I have a few similar job, they works just...

Has anyone used Reporting Assistant feature in DataStage?

Any comment regarding that feature, problem you faced etc.

regards


Rahim Ladha
e-mail : rahimladha@hotmail.com


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

As Ray notes, I usually stick to the base routines when using Job Control... however, the SDK routines are especially nice when you want to issue one of these commands from within a Transform.... in the depths of a job. Ernie -----Original Message----- From: Shrikanth Ramanathan [mailto:ar_shriks@ya...

I defined the function UtilityRunJob in my job control, as I would define any other user-defined function. i.e. DEFFUN UtilityRunJob(JobName, ParamList, RowLimit, WarnLimit) Using "DSU.UtilityRunJob" But on running the compiled job, it aborted with the following message: DataStage Job 235 Phantom 13...

In uvodbc.config file in the project directory on the server, change MAXFETCHBUFF to a larger value. Its default value is 8192; maybe double it. -----Original Message----- From: Roosa, Mike [mailto:Mike.Roosa@getronics.com] Sent: Sunday, 02 September 2001 14:38 To: datastage-users@oliver.com Subject...

If theyre transform functions (and everything under sdkUtility is), you can declare them as functions. For example: DEFFUN UtilityRunJob(Jname,Jparams,Rlimit,Wlimit) Calling "DSU.UtilityRunJob" The "DSU" prefix stands for "DataStage User-written". As to whether its a good practice, only you can make...

Hello, How do we call the sdk/Utility Transforms like UtilityRunJob, UtilityGetRunJobInfo etc. from our job control scripts? How do we define these functions in our job control scripts? Is it a good practise to use these utilities for running our jobs? Regards Shrikanth _____________________________...

Where do I go to increase the buffer size on the datastage server to correct this error:

SQLSTATE=S1000, DBMS.CODE=930122
[Ardent][SQL Client][UNIVERSE]UniVerse/SQL: Row length exceeds buffer size.

If you are running 4.1 or above you can use the server side Complex Flat File Stage I believe. -----Original Message----- From: Dan Paolini [mailto:daniel.paolini@oit.state.nj.us] Sent: Friday, August 31, 2001 2:11 AM To: datastage-users@oliver.com Subject: Re: PICS9 - COMP-3 Problems "Vincent, Brad...

You can download trial version of the driver from www.merant.com. However, the driver is not free and whats worse, as far as i had tried it, it seemed to be extremely slow. Btw. ask Merant for manual if you decide to install it, the driver requires some system changes on client as well as on the ser...

ptoneatto@diormail.com wrote: > COMP-3 fields cannot be converted from EBCDIC to ASCII since they are > not EBCDIC. They even not use an alphabet. COMP-3 fields need a > specific conversion. What you say is true. It isnt what we were asking. The Comp3 format was embedded in a file that otherwise was...

This is a topic for an orphaned message.