DSXchange

Thanks. I expected the same. But now the job is aborting with error Using "null" conversion with non-nullable input APT_CombinedOperatorController(0),0: Null handling function called on a not nullable field. for the only column which is key and nullable is Yes and not for the rest of the k...

Can a key column be nullable (nullable =yes). In one of the jobs I can see this. More than one columns are key columns and out of those all are nullable =No, except one column, still the job is running fine. Want to understand how this is working. Also, can we apply a if 'isnull' function on the key...

One way can be to write a script and call it in a job, is there any other way of doing this.

Is it possible to do 'bcp out' which is similar to select *... from a sybase table to get its extract into a sequential file using any of the stages.

There is a BCP load stage for 'bcp in'.. but could not find anything similar for 'bcp in'.

Ray,

So if this stored proc is not mentioned in description is there no other way to find the jobs using this stored proc?

Is there anything available as 'grep' in unix which is powerful enough to search for any string inside the jobs? What does DataStage offer if we need to do this kind of a search

I have ODBC stages (both server and parallel jobs) and there are stored procedures being called in them. I want to use the search facility to find for a stored procedure used in these ODBC stages. The quick find or advanced search (if all types are selected) does not search and give the job/stage if...

There is a parallel routine (external function) which is a external C routine being called in a parallel transformer. I want to view its code. When I try to go to that routine and check the code behind it, I can see only 3 tabs- General, Creator and Arguments. Where can I see the code for this exter...

Yes Ray, no one is viewing the file. We are also planning to introduce a sleep and try out. This issue is facing only in prod and not able to replicate in any other environment. Another thing observed that this job has inter process buffering enabled as it uses a link collector stage and its a requi...

Hello, We are facing an issue where in after job subroutine script is getting executed before job completion. The job creates a header, detail and trailer and there is a DOS script called in after job subroutine to concat all three. There has been 2-3 instances when the file only contained Header an...

Its a Server job

This is not a query but wanted to share something which I was unaware of. One of my jobs use ODBC stage to connect to Sybase db. Here the table definition has been imported from prod environment database. But the Datasource name, user pwd which are required to be mentioned in the 'Stage' tab of ODBC...

Hi, My job has a ODBC stage which calls a Sybase stored procedure. The output from this stage is 0 records and it gives the message ' Process meta data not available in database'. When the same procedure is executed in the database, it does return some number of rows. I saw a post related to this: h...

Raised a PMR with IBM.. will update when I get some news.

Would that be a 'solution'?

Anyways will try it.

I have created a parameter set and added it to some of my jobs. Now I updated that parameter set with some default values. My query is; will the same be reflected in the jobs where this parameter set is already used without compiling the job again? As I have not modified any parameters, but only add...