DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 53 matches
Author Message
 Topic: Run VBS file from Datastage Or Fix excel read issues
sarathchandrakt

Replies: 1
Views: 79

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Jan 03, 2021 11:43 pm   Subject: Run VBS file from Datastage Or Fix excel read issues
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,

I am trying to read an excel file using unstructured data stage but the values that are retrieved are coming with exponential values instead of Integer. Changing the data to "General" format in ...
Resolved
 Topic: Routines to do EReplace Function
sarathchandrakt

Replies: 7
Views: 1931

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Feb 06, 2020 10:54 am   Subject: Routines to do EReplace Function
Used Convert and it worked. Then I came here to mention same and it was already in replies. Appreciate the help guys.
Resolved
 Topic: Routines to do EReplace Function
sarathchandrakt

Replies: 7
Views: 1931

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Feb 04, 2020 7:42 am   Subject: Routines to do EReplace Function
Unfortunately, after a second look, Routines might not be the option we are looking for at this point in time. From what I understand, if we take Parallel Routine path, we should make some changes in ...
Resolved
 Topic: Routines to do EReplace Function
sarathchandrakt

Replies: 7
Views: 1931

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Feb 04, 2020 4:31 am   Subject: Routines to do EReplace Function
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,

I have a requirement to convert all alphabets in a field to convert to symbols. Right now, I am using EReplace to do this in a transformer. But this requirement is getting extended to multiple ...
 Topic: How to Convert Formulas to Values in XLSX and CSV file
sarathchandrakt

Replies: 3
Views: 1755

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 09, 2019 11:50 am   Subject: How to Convert Formulas to Values in XLSX and CSV file
Hi Chulett, thank you for the response. Yes, it is not XSV, it is CSV. Sorry about that. I am not converting spreadsheet to csv. My source is a DB. I am manually writing formulas in transformer. But w ...
 Topic: How to Convert Formulas to Values in XLSX and CSV file
sarathchandrakt

Replies: 3
Views: 1755

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Oct 08, 2019 7:46 am   Subject: How to Convert Formulas to Values in XLSX and CSV file
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,

I have a scenario where I need to perform some estimations by picking data from different rows in a file.

For example,
I have 100 rows. I have to use data from rows 1 to 10 to determine val ...
Resolved
 Topic: Remove Carriage Return in Sequential Stage Filter
sarathchandrakt

Replies: 10
Views: 2590

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue May 21, 2019 9:31 pm   Subject: Remove Carriage Return in Sequential Stage Filter
The reason why we didn't run unix commands in sequence job is sometimes, we will be asked to process just a single file and running the sequence will trigger multiple jobs. So, we decided to keep the ...
 Topic: How to connect and read a SAS dataset in Datastage
sarathchandrakt

Replies: 1
Views: 1121

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon May 13, 2019 1:15 am   Subject: How to connect and read a SAS dataset in Datastage
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,

So far we were downloading SAS datasets manually and using them as input in Datastage jobs. Going forward we have to connect to SAS server and pull data from Datasets directly. There is very li ...
Resolved
 Topic: Remove Carriage Return in Sequential Stage Filter
sarathchandrakt

Replies: 10
Views: 2590

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon May 13, 2019 1:05 am   Subject: Remove Carriage Return in Sequential Stage Filter
Thank you everyone for the responses. I am getting extra CRs in file that we get from third party source. We figured it would be easy to fix it from our end.

I used TR in before job sub routineto r ...
Resolved
 Topic: Remove Carriage Return in Sequential Stage Filter
sarathchandrakt

Replies: 10
Views: 2590

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 08, 2019 10:46 pm   Subject: Remove Carriage Return in Sequential Stage Filter
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,

I am already using sed '1d;$d' to remove first and last line of the file. Now I have to remove carriage return from the file too. I have commands that can do both tasks separately. But I'm tryi ...
 Topic: How to Read a SAS file in Datastage
sarathchandrakt

Replies: 4
Views: 1703

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 23, 2019 2:47 am   Subject: How to Read a SAS file in Datastage
Yes. We were miss communicated that SAS is installed on the DS Server. It was not installed and the Admin's are working on it now.

Also, is there a way/code where we can access the SAS Dataset dire ...
 Topic: How to Read a SAS file in Datastage
sarathchandrakt

Replies: 4
Views: 1703

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 17, 2019 8:28 pm   Subject: How to Read a SAS file in Datastage
I do have SAS Stage and SAS Parellel Dataset stage. Though, Looks like Parellel Dataset stage accepts only .ds files.

I downloaded the SAS file and placed it on Datastage server and copied the code ...
 Topic: How to Read a SAS file in Datastage
sarathchandrakt

Replies: 4
Views: 1703

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 17, 2019 8:36 am   Subject: How to Read a SAS file in Datastage
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,

I have never worked on SAS and now we have a requirement to read data from SAS dataset. There is not much online that could help. I got access to SAS datasets using the SAS Enterprise Guide. He ...
 Topic: Write to excel using Unstructured Data stage
sarathchandrakt

Replies: 1
Views: 1105

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jan 03, 2019 5:11 am   Subject: Write to excel using Unstructured Data stage
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
I came across a page in IBM KC website which explains how to write data to Excel files and these are the first three steps mentioned.

1. Double-click Unstructured Data stage to open the stage prope ...
 Topic: How to generate warnings when rows rejected
sarathchandrakt

Replies: 4
Views: 1618

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri May 04, 2018 6:37 am   Subject: How to generate warnings when rows rejected
I tried that. Below is the Info generated on DB2 Connector and Reject Sequential File.

"db2Connector_OUT,2: Number of rows rejected: 64"

"seq_Rejects,0: Export complete; 127 records exported suc ...
 

 Jump to:   



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