DSXchange

Sounds like a job interview question or a homework question. It is not a common practice here to answer questions to help someone get a job. If you have a legitimate need to know then please explain further.

If you run another script by using dot and a space then the path to the other shell script then it runs it as if it is a part of this script. This is called sourcing a script. If you just run the script then it runs as a child process. A child process can never change the value of a shell variable i...

It should work fine with all versions of Ds6 and Ds7. I have not tried it with Ds5. If you need it for version 5.x then let me know. It is accually sold through www.tools4datastage.com which is owned by the company which owns this site. There should be a link on there to request a trial version. If ...

You can do it if you have fixed number and type of columns. I do this in EtlStats. I always retunr one column and it is numeric. It is totally parameter driven. #SelectStmt# It outputs 3 columns #MeasureName# and the date. The table is call ETL_QA_RESULT. I do things like compare row counts in a sou...

Ray

All these files have dictionary items. I will post some more dictionary items to get the last version of a job. Craig can use this in a SQL DELETE to clean out what his does not want. I think this is very safe but I would back these files up at the OS level before running the DELETE.

ParameterNavigator is my product. There is a free trial version. It is describe on my web site below. It does just about anything you can think of with parameters. It has usage analysis. It copy groups of parameters to jobs like the 3 or 4 parameters to connect to a specific database. Maybe you have...

Ask Dennis.

Here is similar information on how parameters are applied in a sequence. INSERT INTO DICT DS_JOBOBJECTS ( FIELD, CODE, EXP, NAME, FORMAT, SM, ASSOC ) VALUES ( 'JobActParamNames', 'D', '20', 'JobActParamNames', '30L', 'M', 'MvJobAct' ) ; INSERT INTO DICT DS_JOBOBJECTS ( FIELD, COD...

Buy ParameterNavigator from me would save you lots of time and trouble. Parameters are simple. They are stored in the ROOT record of a job in DS_JOBOBJECTS. Here is some SQL to report on them and to list them. AttrNo 14. ParamNames 15. ParamDesc 16. ParamPrompt 17. ParamDefault 18. ParamHelpTxt 19. ...

If you have a job named XYZ then you cannot DSAttach to XYZ. A job cannot run itself. It will not allow this.

OPENSEQ PROJECT_HOME:'/seq/dbmbr.txt' TO F.SEQ ELSE Call DSLogInfo("Unable to open ":PROJECT_HOME:'/seq/dbmbr.txt',"Output") STOP END * TCL = 'LogTo ':FIELD(PROJECT_HOME,'/',5) * Call DSExecute("TCL", TCL, ScreenOutput, SystemReturnCode) Call DS...

EXECUTE 'CREATE.FILE DbMbrHash'

should be

EXECUTE 'CREATE.FILE DbMbrHash DYNAMIC'

You probably need to aggregate the threads spawned by a PX job. Vincent sent me the job to do this. He mdoified one of jobs in EtlStats. Very nice solution. Ask in this forum and he might send you a copy. I have it somewhere too but I still do not use PX so it is less important to me. Very cool stuf...

Maurik This is great advice. This is practical wisdom to help things run smooth. This is a great starting point. I think the theory in Kimball and Inmon go over the heads of most people. I think start small and build up to the big ideas. I would rather be street smart and book dumb than the other wa...

I think Ken is correct. A book is a good start especially this book. Mentoring from an experience pro is also good or even better. But if you cannot afford these then take the baby steps I talked about and build on it. Be consistent as a team of developers. I think outsourcing is a good example of w...