DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 1224 matches
Author Message
 Topic: Uninstall Qualitystage alone
SURA

Replies: 1
Views: 32

PostForum: General   Posted: Sun Jun 25, 2017 10:11 pm   Subject: Uninstall Qualitystage alone
Hello All

I managed to uninstall the QualityStage alone.

I will update the steps here. So that it can help others.
 Topic: Uninstall Qualitystage alone
SURA

Replies: 1
Views: 32

PostForum: General   Posted: Sun Jun 25, 2017 5:36 pm   Subject: Uninstall Qualitystage alone
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Additional info: Windows / 8.7
Hi,

I am in a situation to uninstall the Qualitystage alone. I found the below link from IBM site.


https://www.ibm.com/support/knowledgecenter/SSZJPZ_8.7.0/com.ibm.swg.im.iis.productization.ii ...
Resolved
 Topic: Disable Quality stage alone
SURA

Replies: 2
Views: 86

PostForum: General   Posted: Thu Jun 22, 2017 3:17 pm   Subject: Disable Quality stage alone
Thanks Ray.
Resolved
 Topic: Disable Quality stage alone
SURA

Replies: 2
Views: 86

PostForum: General   Posted: Mon Jun 19, 2017 2:34 am   Subject: Disable Quality stage alone
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Additional info: Any impact?
Hi there

I am in a situation to disable the Quality stage. I am using Datastage 8.7 in Windows. I can use LicensingServiceAdmin option which I have found in the IBM site.

But I would like to kn ...
Workaround Reported
 Topic: How to read the space delimited file??
SURA

Replies: 9
Views: 639

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 18, 2017 9:15 pm   Subject: How to read the space delimited file??
Yes , i am marking this thread as Workaround.

Thanks to all for your time and help.
Workaround Reported
 Topic: How to read the space delimited file??
SURA

Replies: 9
Views: 639

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 18, 2017 5:57 pm   Subject: How to read the space delimited file??
The ideal "solution" is to push this back on whoever is responsible for .

You are 100% right.

The issue are...

1. When they gave the sample file, it wasn't that bad. Though the work is messy ...
Workaround Reported
 Topic: How to read the space delimited file??
SURA

Replies: 9
Views: 639

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 18, 2017 5:48 pm   Subject: Re: How to read the space delimited file??
I am thinking to use to string match and then find a way to load the data by using field function.
Or that string match followed by a substring. Once you find the position of an ...

Yes that exact ...
Workaround Reported
 Topic: How to read the space delimited file??
SURA

Replies: 9
Views: 639

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 18, 2017 5:47 pm   Subject: How to read the space delimited file??
Have you tried using a Sequential File stage with space (or 0x20) specified as the field delimiter character? If so, what was the result? ...

Ray

Yes i tried that option . The issue I have her ...
Workaround Reported
 Topic: How to read the space delimited file??
SURA

Replies: 9
Views: 639

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Apr 17, 2017 11:34 pm   Subject: How to read the space delimited file??
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Hi there


I need some suggestions to read this file using datastage. This is a log file data which need to be loaded into a table.

These all are the columns i am after:

DATE
TIME
Event
U ...
Resolved
 Topic: UTC to AEST
SURA

Replies: 9
Views: 920

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Feb 01, 2017 8:21 pm   Subject: UTC to AEST
Thanks Ray for cautioning.

In this office somehow a manual process has been implemented as someone who physically update the reference table to get the offset. This table will always (I wish alwa ...
Resolved
 Topic: UTC to AEST
SURA

Replies: 9
Views: 920

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jan 30, 2017 4:21 pm   Subject: UTC to AEST
It worked perfectly.

Thanks to all for your help.
Resolved
 Topic: UTC to AEST
SURA

Replies: 9
Views: 920

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jan 30, 2017 3:46 pm   Subject: UTC to AEST
Hi Chulett

DateOffsetByComponents(%basedate%,%yearoffset%,%monthoffset%,%dayoffset%)

This function doesn’t have time option, in such case how do i add 11 hours offset?

Am i missing so ...
Resolved
 Topic: UTC to AEST
SURA

Replies: 9
Views: 920

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jan 30, 2017 3:40 pm   Subject: UTC to AEST
Thanks chulett.

Yes it is.

I will check this.
Resolved
 Topic: UTC to AEST
SURA

Replies: 9
Views: 920

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jan 30, 2017 3:39 pm   Subject: UTC to AEST
Thanks Ray
Resolved
 Topic: UTC to AEST
SURA

Replies: 9
Views: 920

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Jan 29, 2017 10:47 pm   Subject: UTC to AEST
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Hello All

Source : File
Target : Table
UTC Time: Timestamp (yyyy-mm-dd hh:mm:ss)

I have a reference table where i can get the offset numbers such as 11 or 10 based on the range lookup with the ...
 

 Jump to:   



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