DSXchange

This isn't that difficult. They don't need the table metadata to run the jobs. However, if you want to include it, export them one at a time to the same .dsx and choose the 'Append' option. Your friend is incorrect about 'the other table will automatically exported', it won't. Same goes for any cust...

So export the job design. Follow that with exports of any components they'd need to be able to compile it there, appending them to the export file: Custom Routines Custom Transforms Shared Containers As noted, you need to know what you need to include, it won't fish them out for you automagically. I...

Ok, now I'm lost... how is the second post related to your original question? You first ask how to get log information from a job's log. Then you post a routine that interogates a job itself for stages and link row counts. What are you trying to accomplish here? Fix the routine or write a new one t...

You don't need 'Universe tables' for this, per se. Write your routines using the appropriate DSGetLog functions:

DSGetLogNewestId
DSGetLogEntry

The online help for the latter has an good example on how to do exactly that.

And would it be OK to assume that it is the same thing when we reset the Job Sequence status?. For instance, If the underlying job aborts for some reason, the sequence will also abort. In this situation, if I just modify the job, recompile it and reset the status of the Job sequence it should be ru...

... and the job parameters remain unchanged.

In other words, some of the "junk" values you removed were the legitimate EOR values - CR/LF pairs for a DOS file. Don't do that.

It's been mentioned before, I believe. What are you searching for? Narrow your search criteria down a notch or two, you are returning too many results.

karthikgk0705 wrote:If I import the XSD through file option,the output is not coming out correctly.

What's 'not correct' about it, because that's the right option to use for this.

DSguru2B wrote:Lets think outside of DataStage shall we.

Ha! What do you think this is... AwkXchange?

The reject link handles only failures reported by the database. Only if you code it as such. If all you do is mark a link as a Reject link, it will capture any record, 'good' or 'bad', that hasn't gone down a link before it got there based on link ordering. You can easily have two 'reject' links fr...

Specifically:

DSGetNewestLogId
DSGetLogEntry

The online help for the latter actually shows how to use the two together to get what you want.

I have tried it. It's working fine. But... In other words, it's not working fine. Let me be the first to admit I've never actually used the Folder stage as a target, never had a need to. But I seem to recall others using it here and reporting success, hence the recommendation. The docs say the firs...

Did you look in the Server Jobs Developer's Guide pdf as I mentioned? In my 7.5.1A version, Chapter 11 is dedicated to the Folder stage and the Folder Stage Input Data section tells you what you need to know to use the folder stage to write multiple files into a directory and how you can control the...

Hmmm... those requirements sound really familiar... let's see. Two people with the same interesting requirements. What are the odds?