DSXchange

Hashfiles can be written by two ways:

(1) In the Project Repository (to read it use the OPEN-Statement)
(2) In a Path (to read it use the OPENPATH-Statement)

The use of both statements is explained in detail in the documentation-pdf.

Seting the UserStatus of the job runing to anything is possible within the Job. UserStatus is a clever element for to transfer certain information from one job to the other. One thing you don't know (directly) before a job ends is the after-run-job-Status. But through asking via other functions you ...

In the actual for DataStage licencend ODBC-Driver a routine including a ODBC-call doesn't work due to licence. So your only chace is a "before-Job"-Job.

Wolfgang

Difficult to answer without knowing precicely what you do and without knowing precicely how you messure your rownumbers.

with the KeyMgtGetNextValue you can generate Numbers, each time you call this function you get a number one number higher. Every key has to have a name. If you call your number Jack, each time calling Jack with this routine you get one more. There are functions to set Jack back to zero, You can have...

Use the OPEN or OPENPATH-Statement in your Routine for reading Hashfiles, with those you get a higher flexibilty in your routines.

Look in your Doku (PDF) that comes with DataStage, there you find all about it. And if you have after that question come and post them here.

Wolfgang

Try to restart DataStage if you can. Maybe that this will help. Wait 5 Minutes before restarting DataStage.

and beside that it is important, that for the DataStageEngine itsself you have a fourth or sixth group where all develepers of all projects belong to as their secondary group and as well the operators and the dsadm.

Wolfgang

Hi Byron, Spreadsheets are simple and flexible. This is good for newbies and freaks. If you want to use them for Database purpose you need 100 % of discipline. They kind of discipline a Bookkeeper has in his blood. If you have at least one person in your team with an other kind of blood you can get ...

If you want to write a routine with a total of 7 letters or digits and if your number is less then 7 and you want the rest to be filled with Zero you write the following code into your Routine: Ans=FMT(Arg1,"7'0'R") and if you want to have it flexible use a second Argument Arg2 pFormat=Arg...

There is no best of all solution. The special case has to be seen and sometimes it it good having something intermedium and sometimes not, specialy when you have staged into databases of your own kingdom. What we did for to be more sure and more transparent in our processes was: We added a field Pro...

Have you tried to write your data into a hash file and using the hashfile as lookup or to divide in Oracle the sting in a year, month and day part and then concatinating it.

I suppose you know, that if somebody is working with this job the Job isn't exported.

Hi John no,

I don't understand your problem.

You can feed an after-job-routine, after-stage-routine, before-job-routine and before-stage-routine with job parameters.

If you need them to feed with variables you have processed via your Job run you have to take common variables.

Wolfgang