DSXchange

I think the key point here is, that if we want to rollback the entire transaction, we should make the job abort. However, doing this will sometimes make things in confusion because we need to take into account job reset and job restart.

You are right. Setting rows per transaction to be zero cannot resolve the problem. I used your method that is to set abort job after 1 warning and it worked. However, I really don't think it is a good method because some warnings are not related to database issue. :? Do you have any better idea? Can...

Hi, I am testing transaction handling feature in DS. The database is SQL Server. My test is very simple. I just want to import 2 rows of records from a text file into SQL Server. These 2 rows of records are duplicated in the text file and I have specified unique constraint on SQL Server side. I have...

Does anyone know how to invoke the documentation tool in a command line? We don't want to run Manager every time to run the documentation tool.

Thank you.

Hi Ray, could you please tell me more information about RedBack? I have no idea about this at all. In addition, I have another idea that is to use uvsh to connect to the remote Universe server and do some query to tables like DS_JOBS. The web application fetches and analizes the output then returns ...

You could do this in a shell or perl script. You could uv, uvsh, ds or dssh to execute SQL to retrieve information. You could also use dsjob. What exactly do you want? We want to set up a web application for people to browse metadata of a specified DS server. The application could be J2EE or .NET a...

AFAIK there never was an ODBC driver supplied to talk to UniVerse, because DataStage could use BCI/UCI and not need a driver. IBM do not market a UNIX-based ODBC driver for UniVerse but there are third-party ones out there. Hi Ray, do you have any idea that if we want to write a Web based applicati...

Dear all,

Is there any Universe ODBC driver for download? I want to use the driver to connect to DataStage Universe database to perform some query.

Any help is appreciated, thanks!

Gordon

I am using BAPI stage to load data from SAP. I notice that there are three kinds of parameters for a remote function written on the SAP side. They are Import paramter, Table input parameter and Table output parameter. I can pass import parameters to BAPI through the input text. However, I don't know...

I am using BAPI stage to load data from SAP. I notice that there are three kinds of parameters for a remote function written on the SAP side. There are Import paramter, Table input parameter and Table output parameter. I can pass import parameters to BAPI through the input text. However, I don't kno...

Sainath.Srinivasan wrote:ABAP is simple and straight-forward.

BAPI involves SAP side knowledge and development.

Thank you, but our customer is more concerned with the performance of these two stages. Which one do you think is more faster than another?

Best Regards,
Gordon

Apart from that, if you use ABAP stage I believe you can easily pass the job paramaters and debugging the code is also lot transparent. Thank you. Your post reminds me another problem, that is how to pass table parameters to BAPI RFC? Can I still use a input file? If yes, what's the proper format f...

Hi All, I am using the DataStage Extract Pack for SAP R/3. I know from the help document of this pack that there are at least two methods to extract data from SAP: one is ABAP stage, the other is BAPI stage. I have tested BAPI stage and it works fine. But the performance is not so good. I tested ABA...

Hi All, Has any one used ABAP stage in DataStage Extract Pack for SAP R/3 to extract data from SAP? I have created an ABAP stage according to the handbook instructions. After that, I validated the stage and it's OK. But when I tried to run the job, the following error message occured: Test2..ABAP_EX...

I think that the problem may, indeed, be a bug. OCONV could be being called by DSD.BCIOpenR (which opens the connection for reading). With the ODBC stage, if a data element is set to Date or Time, then an "implicit" conversion is performed - it's most likely that this uses Oconv (or Iconv...