Yes, Ray. Prod is a protected project and I checked I am having 'Datastage and Quality Stage Super Operator' permissions.
Do I need to have a production manager permission , Ray?
Search found 59 matches
- Wed Nov 13, 2019 8:16 pm
- Forum: General
- Topic: Error while exporting from prod- using IBMifn Server Manager
- Replies: 5
- Views: 7114
- Wed Nov 06, 2019 9:00 am
- Forum: General
- Topic: Error while exporting from prod- using IBMifn Server Manager
- Replies: 5
- Views: 7114
Error while exporting from prod- using IBMifn Server Manager
I have a role as super operator.When I use IBM information server manager console to export 40 jobs from Prod - it failed with a message Failed - Error exporting design time data: Datastage user role is invalid for exporting Datastage objects But I am able to do from TEST to DEV. Do I have some othe...
- Thu May 02, 2019 3:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error while loading into Netezza table for Numeric column
- Replies: 6
- Views: 6134
- Mon Apr 29, 2019 10:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error while loading into Netezza table for Numeric column
- Replies: 6
- Views: 6134
- Mon Apr 29, 2019 10:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error while loading into Netezza table for Numeric column
- Replies: 6
- Views: 6134
Error while loading into Netezza table for Numeric column
source is a input file (.txt) with column (NQF) with value 0.0377000000000 Target database - Netezza Target column - NQF- has a datatype of Numeric ( precision -5; scale 4) with Nullability - Yes When job runs, it is throwing this error FILE_NM FROM EXTERNAL '/is/isdata/tmp/cbi-etl-prd_34144274_nzw...
- Wed Sep 27, 2017 10:54 am
- Forum: General
- Topic: Get data from URL based sysdate-1
- Replies: 6
- Views: 4331
- Fri Sep 22, 2017 9:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Calling Stored Procedure in Datastage
- Replies: 4
- Views: 6450
- Fri Sep 22, 2017 6:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Calling Stored Procedure in Datastage
- Replies: 4
- Views: 6450
- Thu Sep 21, 2017 10:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Calling Stored Procedure in Datastage
- Replies: 4
- Views: 6450
Calling Stored Procedure in Datastage
I need to call the stored procedure in datastage , get the data and populate in to another table Stored procedure is below CREATE OR REPLACE PROCEDURE GET_JOB_CONTROL_DAILY_DATES( varPROCESS_GROUP_ID VARCHAR2, varJOB_NAME VARCHAR2, dtRUN_DATE DATE, dtDATA_START_DATE OUT DATE, dtDATA_END_DATE OUT DAT...
- Wed Sep 20, 2017 1:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Calculate Previous Month with year
- Replies: 1
- Views: 2666
Resolved the problem Steps: Stage variables MonthFromDate(CurrentDate())-1=svPrevMonth-varchar If Len(svPrevMonth)=1 then '0':svPrevMonth else svPrevMonth=svConMonth-varchar YearFromDate(CurrentDate())=svYear-Varchar YearFromDate(CurrentDate())-1=svYearCheck-varchar If svConMonth=12 then svYearcheck...
- Wed Sep 20, 2017 10:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Calculate Previous Month with year
- Replies: 1
- Views: 2666
Calculate Previous Month with year
I have requirement where I need to populate the Column 'BK' with previous month with year. Column - BK - Datatype - Number(6)- Format -YYYYMM Current month, the job should run for previous month data based on the BK. I tried the option MonthFromDate(CurrentDate())-1 ---> it is giving '8' for today. ...
- Fri Sep 15, 2017 6:57 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Subtract Timestamp
- Replies: 4
- Views: 3936
The problem got resolved. As you said, I tried TimeFromMidnightSeconds(SecondsSinceFromTimestamp2(CurrentTimestamp(),DSJobStartTimestamp)) = PROCESS_DURATION in transformer Input - 9/15/2017 7:49:57 AM---DSJobStartTimestamp 9/15/2017 7:50:09 AM--CurrentTimestamp() Output is 00:00:12 Thank you so muc...
- Thu Sep 14, 2017 2:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Subtract Timestamp
- Replies: 4
- Views: 3936
- Thu Sep 14, 2017 1:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Subtract Timestamp
- Replies: 4
- Views: 3936
Subtract Timestamp
I have a requirement to subtract two timestamps and store the value in output field Output Process_duration - Varchar(20) Formula- CurrentTimestamp()-DsJobStartTimestamp CurrentTimestamp() - 2017-09-14 08:37:59 DsJobStartTimestamp=2017-09-14 08:37:42 Output should be 00:00:17 I tried this option Tim...
- Wed Sep 13, 2017 2:16 pm
- Forum: General
- Topic: ETL Job rowcount and other details
- Replies: 8
- Views: 7206