Author |
Message |
Topic: Run VBS file from Datastage Or Fix excel read issues |
sarathchandrakt
Replies: 1
Views: 79
|
Forum: 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 ...
|
Topic: Routines to do EReplace Function |
sarathchandrakt
Replies: 7
Views: 1931
|
Forum: 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.
|
Topic: Routines to do EReplace Function |
sarathchandrakt
Replies: 7
Views: 1931
|
Forum: 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 ...
|
Topic: Routines to do EReplace Function |
sarathchandrakt
Replies: 7
Views: 1931
|
Forum: 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
|
Forum: 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
|
Forum: 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 ...
|
Topic: Remove Carriage Return in Sequential Stage Filter |
sarathchandrakt
Replies: 10
Views: 2590
|
Forum: 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
|
Forum: 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 ...
|
Topic: Remove Carriage Return in Sequential Stage Filter |
sarathchandrakt
Replies: 10
Views: 2590
|
Forum: 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 ...
|
Topic: Remove Carriage Return in Sequential Stage Filter |
sarathchandrakt
Replies: 10
Views: 2590
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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 ...
|
|