DSXchange

Can someone please help me with this? I am being told by Ascential support that calling a Stored Proc (SQLServer 2000) through and ODBC stage and returning data to a sequential file is NOT SUPPORTED. Can this possibly be true? Support told me that the only way Stored Procs are supported is if you ar...

Actually, you can use the commonDSA tables and some custom queries on the metadata OCE connection to access metadata from MetaStage and pass it to Brio (6.6 and 8 or any other). We are currently supporting a DataStage 7, MetaStage 7, Brio 8, ER/Studio 6 toolset. We are able to access the MetaData we...

I would go with Peytot's suggestion. That pesky position column always causes problems.

Good luck!

Aaron

Thanks for the prompt replies. First, would you suggest that I not use the CompileAll utility to compile jobs on DS7? Second, if I can use it on DS7, where can I get it?

Again, thansk for the help.

Aaron

Tunde, Ahhh... Restartability, not something easily achieved, but definately something you can do if you put some thought into your overall sequence structure, dependancies, what makes a job fail or what makes an entire sequence fail. First, I will answer the question as to why the sequence showed a...

Is this even possible?? I can get the sequence job names and status' in a routine, but I can't find a way to force a compile on these jobs. The 'Compile Multiple Jobs' functionality is nice, but adding sequences to the mix would really help.

Thanks!

Aaron

Rahul, I would use an ODBC stage along with custom SQL or a stored proc to return only the records you want to lookup against. For example: SELECT t.col1, t2.col2 FROM (SELECT DISTINCT col1 FROM table) AS t LEFT OUTER JOIN table AS t2 ON t.col1 = t2.col1 AND t2.col2 IS NOT NULL This code will give y...

All, I am using an ODBC stage to call a Stored Procudure in SQL server 2000. The proc does a bunch of updates to a temp table and then returns all the results back to the job. The problem: The proc executes fine when executed in Query Analyzer (runs in about 50 seconds), however, when the proc is ex...

Looks good now!!!

Thanks!

Aaron

I'm getting JavaScript Errors on every page I visit on this forum. Anyone else having this issue this morning?

Thanks!

Aaron

Kim, Thanks for the reply, I had searched the archives and hadn't found that post. One additional question, this code seems to work well for what ever job or sequence you pass to it, however, I need to add a recursive aspect to it, I need it to cruise through all the jobs below the master and return...

Hello all, Any help resolving this issue would be great. I want to create a routine that can check the status of a particular sequence and all the sequences and jobs that are part of that sequence and return a 0 if all ore OK or a 1 if ANY have failed or aborted. Example: Sequence 1 Sequence 1.1 Job...

We moved to DataStage 7.0 shortly after it was released and we have been using it a lot since then. Overall, I am impressed. So far, the product has been stable and error free, the usability additions are great and everything is much more customizeable. During our implementation of 7.0 we had a cons...

Version 7.0 has a rowmerger stage and a rowspliter stage, these should accomplish this nicely.

Aaron

Kevin,

Thanks for the replys, I'm going to see if having the ER/Studio API on the Box doing the importing makes any difference. This may help.

Aaron