DSXchange

Nothing all that Premium about it, so it's unmarked now. And yes, there are issues with being able to send email - but your post does go through. All you get if you go back and hit Submit again is the error again and multiple copies of your post. Read the Site forum, there are some posts there about...

Well, here's a crazy thought - why not use Tivoli to actually schedule and run your DataStage jobs rather than cron? Isn't that why you have it? With something like Tivoli or Control-M there's no "need" for cron, it should only be what you use when you have no other choice - when you don't have some...

I'm not all that familiar with the CFF stage, but from what I recall declaring something a BINARY would be equivalent to a COBOL COMP-1 field, not a COMP-3. Seems like there would be a different choice you should make for COMP-3 - something like Packed or Packed Decimal perhaps?

Search the forums for 64BIT to get the information you seek.

Now my new requirement is to send the status of SEQ01 to Tivoli. For this I have designed a routine to read the status of this SEQ01 after it has finished Ok or Finished with Warnings or Aborted/Restartable... Is there something magical about Tivoli that requires anything 'extra' be done for it to ...

Keep in mind the fact that, if no 'bad' data is generated, the bad file will not be created so there won't be anything to find.

Does it count if I post the same reply 10,000 times?

kduke wrote:How about a poll on how bad Craig's jokes are getting.

Hey - it was way past my bedtime, what do you expect?

It requires SELECT privileges on some DBA views so it can function properly. Nothing more. There's no reasonable "security reason" that should disallow that.

How many times are you going to post this problem, Suman?

No, it means you need to look into issuing 'remote shell' commands.

And yes, DataStage has support for SOA, like web services, etc.

Yes, and this option will only appear if the Reference Link originates from a UV or ODBC stage.

Define exactly what "parse out info from each column" means. What does the output need to look like? You know, ETL tools were not built to read or create reports. You can do it, it's a PITA but there are other BI tools specifically created to fill that niche. Monarch springs to mind as one of the lo...

Because you are exporting the final 'command string' not actually executing it.

Change:


To:

and see if that works more better.

If your data is sorted, you can increment a stage variable every time a new value is seen. Pretty standard variation of the 'group change dectection' game. Or perhaps an Aggregator could be used...