DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 55 matches
Author Message
Resolved
 Topic: Get data from URL based sysdate-1
Vrisha

Replies: 6
Views: 342

PostForum: General   Posted: Wed Sep 27, 2017 10:54 am   Subject: Get data from URL based sysdate-1
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 prob ...
 Topic: Calling Stored Procedure in Datastage
Vrisha

Replies: 4
Views: 238

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Sep 22, 2017 9:24 am   Subject: Calling Stored Procedure in Datastage
Thanks Craig. I went through the documentation . But unable to find out. I will do testing based on trial and error methods.
 Topic: Calling Stored Procedure in Datastage
Vrisha

Replies: 4
Views: 238

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Sep 22, 2017 6:36 am   Subject: Calling Stored Procedure in Datastage
Hi Craig,

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

Thanks.
 Topic: Calling Stored Procedure in Datastage
Vrisha

Replies: 4
Views: 238

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Sep 21, 2017 10:37 am   Subject: Calling Stored Procedure in Datastage
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
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_GR ...
Resolved
 Topic: Calculate Previous Month with year
Vrisha

Replies: 1
Views: 215

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Sep 20, 2017 1:09 pm   Subject: Calculate Previous Month with year
Resolved the problem

Steps:
Stage variables
MonthFromDate(CurrentDate())-1=svPrevMonth-varchar

If Len(svPrevMonth)=1 then '0':svPrevMonth else svPrevMonth=svConMonth-varchar

YearFromDate(Cu ...
Resolved
 Topic: Calculate Previous Month with year
Vrisha

Replies: 1
Views: 215

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Sep 20, 2017 10:13 am   Subject: Calculate Previous Month with year
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
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 ...
Resolved
 Topic: Subtract Timestamp
Vrisha

Replies: 4
Views: 293

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Sep 15, 2017 6:57 am   Subject: Subtract Timestamp
The problem got resolved.

As you said, I tried

TimeFromMidnightSeconds(SecondsSinceFromTimestamp2(CurrentTimestamp(),DSJobStartTimestamp)) = PROCESS_DURATION in transformer

Input -

9/15/ ...
Resolved
 Topic: Subtract Timestamp
Vrisha

Replies: 4
Views: 293

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Sep 14, 2017 2:40 pm   Subject: Subtract Timestamp
thank you. I will try and get back to you
Resolved
 Topic: Subtract Timestamp
Vrisha

Replies: 4
Views: 293

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Sep 14, 2017 1:09 pm   Subject: Subtract Timestamp
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
I have a requirement to subtract two timestamps and store the value in output field

Output
Process_duration - Varchar(20)

Formula-
CurrentTimestamp()-DsJobStartTimestamp

CurrentTimestamp() ...
 Topic: ETL Job rowcount and other details
Vrisha

Replies: 8
Views: 427

PostForum: General   Posted: Wed Sep 13, 2017 2:16 pm   Subject: ETL Job rowcount and other details
Thanks, Craig. I will try the methods suggested by you and keep you posted.
 Topic: ETL Job rowcount and other details
Vrisha

Replies: 8
Views: 427

PostForum: General   Posted: Wed Sep 13, 2017 8:59 am   Subject: ETL Job rowcount and other details
Hi Craig / Mike/ Paul,

I went through the documentation, it was very useful. But in our environment they didn't build/configured the DSODB database and not ready to do so.

Is there any other way ...
 Topic: ETL Job rowcount and other details
Vrisha

Replies: 8
Views: 427

PostForum: General   Posted: Wed Sep 13, 2017 6:45 am   Subject: ETL Job rowcount and other details
Thanks, Craig. I will look into it.
 Topic: ETL Job rowcount and other details
Vrisha

Replies: 8
Views: 427

PostForum: General   Posted: Wed Sep 13, 2017 6:33 am   Subject: ETL Job rowcount and other details
Thanks for your reply, Mike. As you said, I went through this website 'https://www-304.ibm.com/support/docview.wss?uid=swg21509567' and I checked the file 'D:\IBM\InformationServer\Server\DSODB\logs\ ...
 Topic: ETL Job rowcount and other details
Vrisha

Replies: 8
Views: 427

PostForum: General   Posted: Tue Sep 12, 2017 2:43 pm   Subject: ETL Job rowcount and other details
DataStage® Release: 11x
Job Type: Parallel
OS: Windows
I have a requirement that once the job got finished, it should populate the
JOB_NAME,
PROCESS_EXECUTION_ID,
PROCESS_START_DATE,
PROCESS_END_DATE,
PROCESS_DURATION,
ROWCOUNT_EXTRACTED,
ROW ...
Resolved
 Topic: Remove multiple Ascii characters from input data
Vrisha

Replies: 7
Views: 539

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Sep 07, 2017 1:06 pm   Subject: Remove multiple Ascii characters from input data
Thank you UCDI for your valuable suggestion.
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours