DSXchange

Hi ,

I am looking for the enviroment variable names where compiler and linker options will be given for the particular unix flavour like AIX or HP-UX. I remember that APT_COMPILER is one. For linker what is the variable name.

Regards,
Suman

Hello, I am trying to load data into SAP via SAP plug-in stage. Currently, I am calling BAPI with the required import, export parameters, etc. and loading successfully. In some cases I also call IDOC and load successfully. However, I am unsure if this can give me good performance with huge volume of...

Hi All, I am using Change Capture stage for comparing previous and new records. The volume of records is 0.7 millions and the lenghth of a single record is 4750 char with some numeric fields in between.The job is taking 39-40 mins to complete. Also the records are sorted on both links with the chang...

I am able to run my C program after changing the file name in the program with the full path. I was not using this forum for a while and I am back now.Thanks to all of you.

Suman

Yes. You are correct. Its just a function. You can have a main and do the testing from command line, but once all the testing is done, you need to remove the main() function. Also make sure that no input arguments of the C function are defined as const. It does not work with datastage. I have made ...

Yes. You are correct. Its just a function. You can have a main and do the testing from command line, but once all the testing is done, you need to remove the main() function. Also make sure that no input arguments of the C function are defined as const. It does not work with datastage. I have made ...

In Datastage when I am trying to open the job properties or open transformer stage then I am getting the following error in an error window: (40503) A call to an OLE server failed,or a runtime error occurred within the OLE server itself. Also windows installer is running whenever I am clicking any s...

ray.wurlod wrote:A parallel routine (a C function) does NOT have a main() entrypoint. ...

If I am correct you mean main() is not required and separate function name is required in C.

The C program is compiled with +z option.A parallel routine is also present in repository. Do I need to use any function inside the C program or only using main() is sufficient.

I have written the C program and created .o file . But during compilation I am getting the following errors in transformer: ##E TBLD 000000 02:19:10(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 256. ##E TFSR 000019 02:19:10(001) <main_program...

I did a quick search and you were using the correct syntax. Forget the exec and lets put call back. So now your OPEN statement should be call schemaname.storedprocedurename(). Try getting rid of the trailing semicolon. If that doesnt work get your dba involved, ask him to monitor if the stored proc...

DSguru2B wrote:Try it with exec schemaname.procedurename(). Also try without the trailing semicolon. We had different results on different versions in the recent past. ...

I have tried with exec without the semicolon. Still the procedure is not getting executed.We are using datstage version 7.5.2.

Suman

Open command is equivalent to 'Before Sql' in Server and Close command is equivalent to 'After Sql'. ... I have tried executing the command 'call schemaname.procedurename();' in Open command option. It is not exceuting the procedure and not giving any error message also. Is there any other way to c...

Server job now has to be converted to parallel job Why? If it isn't broken, don't fix it. ... Parallel job is required as I am converting all server jobs into parallel jobs to improve the performance of the whole process. The output of the existing server job is a hash file which is used for lookup...

If you don't have statistics how can you assert that "it reduces performance a lot"?! Depending on the data volumes it may be better (easier) to use a server job. Are you sure that the server ro ... Server job is already existing and taking around 17-20 secs. There is no parallel job. Ser...