DSXchange

Profile Stage,Data Stage,Meta Stage,Quality Stage

Should be ProfileStage, DataStage, MetaStage, QualityStage .

You could use vi if you are on UNIX. UV.VI instead of ED. ED has help. Just type HELP or ?. It is like any line editor. Use I to insert until you type a blank line. C/KIM/KEN/99 Will change the first KIM on a line to KEN on the next 99 lines. EX Will exit. FI Will FILE or save your record. T Will go...

I have posted SQL and BASIC code which will show you the jobs within a sequence. All you need to do combine this with dsxeport.exe.

Exactly, there are no shortcuts for learning this properly. If I make a mistake at this level then I know how to fix it. You better do full exports before playing around at this level.

ED is a line editor. You have to learn this editor's commands. You can also use SETFILE.

You have to trick it. You have to create a q-pointer to access a repository table. This means you need to learn more about Universe. A q-pointer is a Universe equivalent of a synonym. It is a VOC entry. at TCL: ED VOC Q_DS_AUDIT 1: Q 2: 3: DS_AUDIT Should look like above. Once you have a q-pointer t...

Besides there is no way Dennis will ever make that much money or even recoop the money he has already spent on developing this site and maintaining it.

Craig

You did a search for sequencer. What was Ray's signature time before last?

But not Starbucks.

Yes, you always need the client loaded. The DataStage server becomes a client to the database during loading or retrieving data.

Thanks. I sure would like to know which one people use the most. I have changed almost all of them. When things slow down I will update my tips page. Still think we should give extra utilities to premium members. Let me know what you think. I sure will give a discount on my products. Should update ...

Balaji is correct you cannot assign a parameter in one job. You need to break this up into 2 jobs. Normally you would do this in a batch job. A batch job is one with only job control code. In 7.5.1 you can use a routine activity and return its arguments and assign them to variables. These can be use...

Are you calling a routine with a readu in it? If not then I would say it is in the transaction size or array size if those exist in a UV stage.

Why are you updating a UV stage? I can see a advantage of reading from a UV stage but not writing to one.

Select it into a hash file with a job. Use either UtilityHashRead or the get next surrogate key routine to develop your own routine.