DSXchange

Shiva

Ray's way will take 0 and make it 1. I don't think that is what you want.

Int(InLink.ColName+0.5)

I think is more like a round function. Try it.

Thanks Kim.


Kim Duke
DwNav - ETL Navigator
www.Duke-Consulting.com

Raggid Vincent is correct. You need to pass it as an argument. If I am reading your message correctly the problem may be that a parameter name should not have spaces in it. If you have a parameter named file path then change it to FilePath. Next call your routine like this MyRoutine(FilePath) in a d...

Abhishek If this file is created by another job then this is one of the short comings of DataStage. That is why I created DwNav. You can lookup the table name in the metadata section and it will tell you all the jobs that updated this table or hash file. It will also tell you all the jobs that read ...

Toly

That is what constraints are for. They are designed to limit what gets sent to the target.

Thanks Kim.


Kim Duke
DwNav - ETL Navigator
www.Duke-Consulting.com

Remar Sure in user defined sql you could put a parameter value with # around it. It could be a specific partition. Try your sql out first before you put it in DataStage. If it does not work within DataStage then email it to me. Test it in sql plus first with the parameter name filled out. #param# is...

Brad You can give truncate priveledes to an Oracle stored procedure. It can be limited within that proc to specific tables. The DBA can set that up. You do not need a new user. Within that procedure it could also limit it to the end of the month or whatever. Thanks Kim. Kim Duke DwNav - ETL Navigato...

MAT When you open the doc_tool.mdb hold down the shift key. This will give you the full Access menu. If you go to the Reports tab then DSJobs is the report you want. Double click on it. It will preview it. You need to customize your menu and add print preview menu so you can see the Word option. You...

David

I have BASIC code which will copy all the parameters from one job to another. Let me know if you want it.

Thanks Kim.


Kim Duke
DwNav - ETL Navigator
www.Duke-Consulting.com

Nicolas

I think I would try to export all the jobs and then fix it in the editor. Then import them back. I would make sure I backed up everything first including the dsx.

Thanks Kim.


Kim Duke
DwNav - ETL Navigator
www.Duke-Consulting.com

Luca When you use a sql type other than varchar then DataStage converts the field to that type internally. There is some overhead for this. When you are not doing math with a field then use varchar on both ends (input and output). This is the fastest. What is decimal is numeric in another database. ...

Yet another way is to use @USER0 or @USER1 ... etc. The USER# fields are available as long as the session is in effect. You can also use what is called named common. Named common is a Universe BASIC trick. You can look it up on IBM's website. If you have a problem then let me know. @USER1 = 'my valu...

gpbarsky If you are on UNIX then you can shell out and do a ps -ef | grep jobname if they are all the same job. This is a little tougher if you are on Windows. You could probably run a TCL command LIST.READU EVERY or PORT STATUS. If you need exact syntax then email me. Thanks Kim. Kim Duke DwNav - E...

luca Absolutely. You can add a column to the end of the list and it has no impact on the previous columns. Do not delete columns or insert it in the middle. The order of the columns needs to always be the same from job to job when reading the same hash file. You do not need to delete and recreate th...

Shiva Routines are not slow usually. Send me a copy of the routine and I will tell you what the problem is. Also send the export of the one job and I will be able to evaluate it better. Thanks Kim. quote: Originally posted by shiva459 [br]Hi All I am new to datastage.I've designed a job which popula...

Vincent You can download a copy of DsWebMon from the website and email me for an auth code. 30 day demo is free. I recently lowered the price too. It has never been tested with 4 and 6. It does work with 5 and 6 without changing anything but the login because 5 and 6 need to be on different servers....