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
Search found 4605 matches
- Tue Jun 10, 2003 7:19 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Round Decimal
- Replies: 6
- Views: 2446
- Thu Jun 05, 2003 11:12 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How do I access Job Parameters from Subroutine
- Replies: 16
- Views: 4502
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...
- Wed Jun 04, 2003 10:37 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error in pulling Data in SAP BW
- Replies: 4
- Views: 1097
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 ...
- Tue Jun 03, 2003 8:38 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how to limit a column in transfer?
- Replies: 3
- Views: 2059
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
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
- Fri May 30, 2003 1:23 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Partition
- Replies: 1
- Views: 1063
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...
- Fri May 30, 2003 1:18 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Using Truncate command in OCI8 stage
- Replies: 1
- Views: 1604
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...
- Thu May 29, 2003 2:02 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Report Assistant
- Replies: 3
- Views: 2661
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...
- Wed May 28, 2003 10:58 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Job Template
- Replies: 7
- Views: 4101
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
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
- Wed May 28, 2003 10:55 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Migration from DS 4 to 5, ORABULK Problem
- Replies: 1
- Views: 1367
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
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
- Wed May 28, 2003 10:43 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: SQL Type (Meta-data columns definition)
- Replies: 2
- Views: 1469
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. ...
- Wed May 28, 2003 10:04 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Global variable
- Replies: 19
- Views: 5094
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...
- Wed May 28, 2003 9:56 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Controlling the quantity of jobs running
- Replies: 10
- Views: 4719
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...
- Wed May 28, 2003 9:50 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: permanent hashed file management when job changes
- Replies: 8
- Views: 2867
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...
- Wed May 28, 2003 9:43 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Performance
- Replies: 3
- Views: 2290
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...
- Wed May 28, 2003 9:35 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage Clients
- Replies: 3
- Views: 2385
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....