Search found 5 matches
- Tue Sep 03, 2019 8:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Implicit rounding difference between 8.7 and 11.5
- Replies: 1
- Views: 2692
Implicit rounding difference between 8.7 and 11.5
Hello guys, I'm having an issue with a classic paralell job doing some calculation and then writing into an Oracle Database. At the end the calculation goes for 77.275 . When writing it into a text file, no issue. But when going into an Oracle Table into a NUMBER(10,2) the result goes for 77.28 with...
- Thu Mar 14, 2019 10:00 pm
- Forum: General
- Topic: DStageWrapper for extracting user/role/project
- Replies: 2
- Views: 2900
Thanks, i did not find one of those posts. This query : Query for user project permissions Code: select U.principalId, P.contextId, R.roleId from U in ASCLModel::User, RA in U->assignedBy_RoleAssignment, P in RA->has_RoleContext, R in RA->definedBy_SystemRole order by U.principalId,P.contextId,R.rol...
- Wed Mar 13, 2019 4:23 am
- Forum: General
- Topic: DStageWrapper for extracting user/role/project
- Replies: 2
- Views: 2900
DStageWrapper for extracting user/role/project
Hello, I'm currently trying to export witha command line the permissions of a project/list of projects. I found here a beautifull command line : DStageWrapper.sh -user myUser-password myPas -query "select x.principalId,a.contextId from x in ASCLModel::User, y in x->has_SystemRole, z in x->assig...
- Fri Oct 12, 2018 1:23 am
- Forum: General
- Topic: Performance monitoring through dsjob command
- Replies: 1
- Views: 2253
Performance monitoring through dsjob command
Hello, I'm currently having parallel performances issues on many parallel jobs. In order to understand what's going on i would like to monitor performances and system utilization . It's working when i'm checking the "Record job performance data" in designer execution options and running it...
- Thu May 18, 2017 1:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Webservice : "No support for attachments"
- Replies: 1
- Views: 2776
Webservice : "No support for attachments"
Hello, I'm facing a boring issue using webservice transformer in a PX job. When calling for the webservice i got the following warning : Web_Services_Transformer,0: Warning: job_PS9_Get_Status_Job.Web_Services_Transformer: 0047`:`com.ascentialsoftware.wsclient.ServiceInvocationException: Service inv...