DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 161 matches
Author Message
 Topic: How to read hashed file in basic
igorbmartins

Replies: 10
Views: 6051

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Tue Sep 27, 2016 5:20 am   Subject: How to read hashed file in basic
Thank you everybody. I will check all alternatives and I will post here the results.
 Topic: How to read hashed file in basic
igorbmartins

Replies: 10
Views: 6051

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon Sep 26, 2016 10:24 am   Subject: How to read hashed file in basic
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hello, anyone knows how to read hashed file in basic? I know how to read text file, but not hashed. Let me be more specific. I need to create a job control to read some columns from a hashed file and ...
Resolved
 Topic: Unstructured Data with big number
igorbmartins

Replies: 9
Views: 5226

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jul 21, 2016 5:21 am   Subject: Unstructured Data with big number
Hello intelcom, I did it and it solve my problem. Thanks.
Resolved
 Topic: Unstructured Data with big number
igorbmartins

Replies: 9
Views: 5226

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jul 13, 2016 4:48 am   Subject: Unstructured Data with big number
Hi UCDI, unfortunately I can’t do it, because the column has many data types numbers and leters and abut read the file as CSV I can’t do it too because the file has ‘;’ and ENTER. Yesterday I opened I ...
Resolved
 Topic: Unstructured Data with big number
igorbmartins

Replies: 9
Views: 5226

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jul 12, 2016 11:35 am   Subject: Unstructured Data with big number
Hello chulett, thank you for your reply. I tried to find here the solution before I posted this question, but in my case, I cannot create a calculation because in this column I have numbers, date, str ...
Resolved
 Topic: Unstructured Data with big number
igorbmartins

Replies: 9
Views: 5226

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Jul 12, 2016 9:06 am   Subject: Unstructured Data with big number
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hello everybody, I am facing a problem with the Unstructured Data stage. I am trying to read an excel file. The problem is when I am reading a column with unknown data type like:

COLUMN
1017830006 ...
Resolved
 Topic: PAL - How to pick up the text between the brackets []
igorbmartins

Replies: 6
Views: 5885

PostForum: IBM QualityStage   Posted: Tue Jun 21, 2016 10:26 am   Subject: PAL - How to pick up the text between the brackets []
Hello Ray, because of that I decided to use this rule. In my data base there are rows with:

bla bla [0001]
bla bla {0002}
bla bla (0003)
bla bla [0004}
bla bla [0005)
bla bla {0006)

Thanks, ...
Resolved
 Topic: PAL - How to pick up the text between the brackets []
igorbmartins

Replies: 6
Views: 5885

PostForum: IBM QualityStage   Posted: Mon Jun 20, 2016 8:34 am   Subject: PAL - How to pick up the text between the brackets []
Hello, on the weekend I didiscovered how to do it in a single rule.

*& | & =" | ** | & ="]",")","}" | $ ;LIGACLIP CLIP TIT M BRANCO[200]
COPY [3] {CodigoRef}
RETYPE [2] 0
RETYPE [3] ...
Resolved
 Topic: PAL - How to pick up the text between the brackets []
igorbmartins

Replies: 6
Views: 5885

PostForum: IBM QualityStage   Posted: Fri Jun 17, 2016 12:53 pm   Subject: PAL - How to pick up the text between the brackets []
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi guys,
I am trying to create a Standardization Rules, but I am facing some problems. The objective is to pick up the text between the brackets only if is in the end of the string such as:

• LIG ...
Workaround Reported
 Topic: How to create this PIVOT
igorbmartins

Replies: 3
Views: 2214

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Oct 27, 2014 8:14 am   Subject: How to create this PIVOT
Yes, but my version does not support loop.

Thanks, to solve this problem I decided do that in SQL.

Thanks.
Workaround Reported
 Topic: How to create this PIVOT
igorbmartins

Replies: 3
Views: 2214

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Oct 27, 2014 5:38 am   Subject: How to create this PIVOT
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Hello everybody, I would like to create a pivot, but I don’t know how to do that and if it is possible or not.
I will try to explain what I want. I have a single table in my input

KEY_01;KEY_02;DE ...
 Topic: Job run *FAILURE* in 1440 minute(s) 2 seconds
igorbmartins

Replies: 6
Views: 3820

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Mon Jul 21, 2014 1:42 pm   Subject: Job run *FAILURE* in 1440 minute(s) 2 seconds
This is the IA Log the DataStage director log is very large. If you want I can put here.

IA Job Status
--------------------------------------------------------------------------
| Job Execution ...
 Topic: Job run *FAILURE* in 1440 minute(s) 2 seconds
igorbmartins

Replies: 6
Views: 3820

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Mon Jul 21, 2014 11:36 am   Subject: Job run *FAILURE* in 1440 minute(s) 2 seconds
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Hello, I am analyzing a very huge table and after 24 hours, it is failing with timeout error.

Job run *FAILURE* in 1440 minute(s) 2 seconds.

This error occur in more than one column, and always ...
 Topic: How to clean the IADB
igorbmartins

Replies: 2
Views: 2912

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Fri Jul 18, 2014 12:36 pm   Subject: How to clean the IADB
Thank you, I will check this right now.

Thanks,
Igor Bastos Martins
 Topic: How to clean the IADB
igorbmartins

Replies: 2
Views: 2912

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Fri Jul 18, 2014 5:14 am   Subject: How to clean the IADB
DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Hello everybody, I am here aging needing help, this time with the Information Analyse.

This week I am creating many analyses column from my tables and then I am creating 3 reports for each table a ...
 

 Jump to:   



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