DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 1229 matches
Author Message
Workaround Reported
 Topic: Reading xls using Datastage
SURA

Replies: 7
Views: 770

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jul 19, 2017 3:39 pm   Subject: Reading xls using Datastage
I written a PowerShell script to store the data as csv and used Datastage to load.

Thanks to all for your help and suggestions.
Workaround Reported
 Topic: Reading xls using Datastage
SURA

Replies: 7
Views: 770

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jul 12, 2017 2:07 pm   Subject: Reading xls using Datastage
Thank you UCDI
Workaround Reported
 Topic: Reading xls using Datastage
SURA

Replies: 7
Views: 770

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jul 12, 2017 2:05 pm   Subject: Reading xls using Datastage
Oh, they are all possible but

Thank you so much for your reply.

Is that means in 8.7 we can do the range selection ?
Workaround Reported
 Topic: Reading xls using Datastage
SURA

Replies: 7
Views: 770

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jul 12, 2017 5:57 am   Subject: Reading xls using Datastage
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Additional info: 8.7
Hi

We have to start a new project to read the xls file and load the data into a sql server table .

The challenges I have is

1. ETL need to read the data from 3,4,5...N sheets in a file .
2. ...
Resolved
 Topic: Uninstall Qualitystage alone
SURA

Replies: 2
Views: 408

PostForum: General   Posted: Tue Jun 27, 2017 7:26 pm   Subject: Uninstall Qualitystage alone
Hello All

I did the below steps to uninstall the Quality Stage alone.


Please check the IBM website and follow the instructions as well as take the backup as much as you can.
Please take the ...
Resolved
 Topic: Uninstall Qualitystage alone
SURA

Replies: 2
Views: 408

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.
Resolved
 Topic: Uninstall Qualitystage alone
SURA

Replies: 2
Views: 408

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: 402

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: 402

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: 1102

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: 1102

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: 1102

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: 1102

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: 1102

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: 1568

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

 Jump to:   



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