Search found 5 matches

by DamienF
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: 2623

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...
by DamienF
Thu Mar 14, 2019 10:00 pm
Forum: General
Topic: DStageWrapper for extracting user/role/project
Replies: 2
Views: 2873

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...
by DamienF
Wed Mar 13, 2019 4:23 am
Forum: General
Topic: DStageWrapper for extracting user/role/project
Replies: 2
Views: 2873

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...
by DamienF
Fri Oct 12, 2018 1:23 am
Forum: General
Topic: Performance monitoring through dsjob command
Replies: 1
Views: 2215

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...
by DamienF
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: 2730

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...