DSXchange

SQL Server Profiler is a tool that comes with SQL Server. You can read more here: http://technet.microsoft.com/en-us/library/ms181091.aspx You will need to have it installed locally on your workstation or in the target machine where SQL Server is running. Just keep in mind that you can easily bring ...

Hi,

What are you using to execute the stored procedure? Can you execute another stored procedure?

To debug this issue you can use the SQL Server Profiler which will allow you to inspect the SQL queries send from DataStage to the SQL Server. This should give you a clue whats wrong.

OK, I have managed to resolve it. The issue described in the last post was due to wrong invocation of the APT_DEFINE_OSH_NAME macro.

If anyone is interested I have summarized the experience here: http://szahariev.blogspot.com/2013/09/C ... Howto.html

Hi, Do you have grid enabled? This hang could be due to the scheduling software is unable to find a free node to run your job. If this is not the case, then you will need to have a closer look at the director log messages (including warning and information) to get a clue about the potential problem....

Hello and thank you for the responses. I'm happy to say that I have made progress on this... For a future reference if somebody wants to compile the code from the IBM artcile mentioned in the first post, here is what needs to be done: 1) the following code needs to be removed from src/myhelloworld.c...

Sorry, did not noticed that you are running the job under Unix. The sqlcmd is a windows command.

Have no experience accessing the SQL Server from the Unix shell but this could work: http://www.sqsh.org/

Hi, You can create a sequence to invoke the job and afterwards use the "Execute Command" to run the stored procedure using the sqlcmd command. Alternatively you can create after job subroutine to invoke the same stored procedure using the sqlcmd. My personal preference goes to the first so...

Hi, I need to build a custom operator that should run under DataStage 9.1 and RedHat Linux 5 (64 bit). There is an introduction on the IBM site how to build custom operators for the Windows platform here: http://www.ibm.com/developerworks/data/tutorials/dm0702chard/ I was trying to find something si...

Hi, I'm building an open source tool ( http://dscop.codeplex.com/ ) that should analyze DataStage jobs and outline some potential pitfalls or pinpoint a design that should be avoided. To do it I'm reading the XML job export. Up to now I have managed to reverse engineer part of the XML structure but ...