DSXchange

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?

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

Hi Craig,
the job flow is like
RCP job and multiinstance,
sequential file ---> Transformer---> netezza table
(source) ( target)

Sorry for the confusion. What I meant is precision is 5 ( not negative)
I mean precision hyphen 5.

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

Used the UserVariable activity stage in Sequencer to get the current date as
Oconv(@DATE,'D-MDY[2,2,4]'). Called this Current Date as a parameter in the job to retrieve the data from URL.

The problem is solved.

Thanks Craig. I went through the documentation . But unable to find out. I will do testing based on trial and error methods.

Hi Craig,

It has 3 inputs and 2 outputs. Please let me know what I need to do.

Thanks.

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

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

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

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

thank you. I will try and get back to you

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

Thanks, Craig. I will try the methods suggested by you and keep you posted.