DSXchange

Greetings!

If I understand the question correctly, the main difference is the fact that you write the 'Job Control Routine' code by hand and the Sequence Jobs are built using the GUI interface much like a Server job and (in a sense) write themselves.

Does that help?

Actually Vince, much as I'd like to take credit for something like that, it was posted by Michael Hester. The Proud Papa of the routine Michael Hester, in fact.

Here's a direct link to the correct section of the Library, assuming you are an ADN member.

I am trying to create a generic job that loads the data without the need to build 200 jobs, each having it's own table definition. The files & respective tables are 1 to 1. But two Oracle tables doesn't have common set of field & I am going to truncate the tables before loading ,so there is no chan...

What about the metadata for the 200 flat files and tables? Are they similar in all but name? That's the only way you're going to create one job that takes Job Parameters and updates 200 tables from 200 files. Unless the Oracle tables have a common set of fields and those fields are the only fields t...

If you really don't want to Abort the job (which would be the 'normal' way to stop something part way through - if you can call that normal) try setting up a boolean Stage Variable and use it as an output constraint. Start it off with a value of @TRUE and when your conditions say 'stop' set it to @F...

Ok. Sounds like you are in for some fun if this is virgin territory for you. The scripts need to check, as much as possible, that the correct values have been passed in. Sometimes all that means is the correct number of values has been passed in and I'd suggest you do that at a minimum. Then, as muc...

I'm not sure what you are asking... I suggested you fully path your script so that there are no issues with it not being able to find it to run it. One thing you'll quickly learn is the environment that scripts run under when executed via DataStage is very different from your command line - even whe...

How can I send these values from a Job control routine? Simplest thing is to create a 'command string' that looks pretty much just like you were running the script from the command line, but fully path the script. Do this by concatenating together the static bits and the parameters: UnixCmd = "...

Well, then it looks like I misunderstood your needs, but it sure seemed to me like you were looking for a horizontal pivot. Sorry. If you are trying to turn one row into many, than the Pivot stage should work for you. If you are trying to collapse may rows into one, then you'll need to take a differ...

That's certainly one way. You can also handle it at the target side by using Custom Sql, leaving the target field out of the column list and using 'SYSDATE' as its value in the SQL. You'll find this Forum has quite a bit of information in it. Between it and the Oliver archives that are hosted here, ...

Yes, the Pivot Stage turns one row into many rows while maintaining 'key' fields across the many, so it would do what you need it to do. As to the how, I'd suggest reading the pdf documentation for the stage. It should be installed in a docs folder under your client install. If you can't find it the...

The machine we installed AIX 5.2 64-bit OS is IBM p690. As I was told that AIX 64-bit on IBM 690 cannot run 32-bit application without re-installing the OS to 32-bit, I need to verify if DataStage 7.0 works with 32-bit DB client library only. I'd be surprised if that were true. I used to be involve...

Welcome! :D Configuration issues like this are usually covered pretty well in the Server 'readme' and the Installation Guide pdf. If you are sure you've got the environment variables setup correctly in dsenv and you've restarted DataStage after making the changes, then perhaps it is a 64 versus 32 b...

Kindly let me know cause many times this problem occurs and i have to go for other alternative. I hope you had a conversation with your System Admin, it really shouldn't be a DBA issue - unless they are pulling double-duty. Your best alternative would be to contact Ascential Support, if that's an o...

Check this post and scroll down to Ray's entry - you'll find answer #9 discusses the VOC hash file.