DSXchange

Searching for this.

One job to select data, do all the transformations and then load to 6 flat files, identical to your target tables.
A job for each table.
All together 7 jobs. Keep it modular. Will help in restartability. Also keeps the segments well defined.

Not tired but had a very busy week. One of our systems going into production, the other project is on the way, multi-tasking. Need the weekend to refresh.
Its Friday, leave me alone

Yes it would be. But as we are all in the mode of suggestions, I threw my poll ticket in as well.

Never mind the display property if you are able to view the complete data when you change datatypes. Display is next to the length in the column's tab. As the name suggest, it limits how much data you can view. But if you drag the column end, you can extend it. But as I said, that does'nt seem to be...

kumar_s wrote:That post was for OP. And I was referring to this.

I told you I am slow this morning

Maybe I am slow this morning, but I am not getting where you are going with this Kumar.

They dont... Huh !
Well I guess I have always fully qualified it and hence my rather wrong understanding. But it does'nt hurt to fully qualify the name. The OP should try it.

Agreed Ray ji. Hence, pre-process to attach a running number.

You sure they are missing or you dont have the 'Display' equal or more than the Length

Kill the perpetrator huh??? wow, I mean WOW

It should. And ORACLE_HOME in dsenv gives you the path for the client installation.

I have seen scripts being invoked from jobs as well. But these are mostly for reasons other than control. Otherwise the control becomes confusing and linked in various ways. I am not a big fan of that design.

.odbc.ini and uvodbc.config files are to be configured if your using an odbc handle to connect to the database. If your using native clients then you need to install clients at the server end. Set the variables associated. Thats it. Details can be found in DataStage manuals.

True, shells are written as part of the control process. Shells control jobs, not the other way around.