DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 131 matches
Author Message
 Topic: Any way to export rules to Excel?
boxtoby

Replies: 6
Views: 150

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Thu Jan 18, 2018 7:50 am   Subject: Any way to export rules to Excel?
You can use the api to extract almost anything from IA including the data rules and data rule definitions to xml and in some cases csv as well.

Here's the link:

https://www.ibm.com/support/know ...
Resolved
 Topic: Select rows from table and use results as parameter to job
boxtoby

Replies: 6
Views: 230

PostForum: General   Posted: Thu Jan 04, 2018 10:14 am   Subject: Select rows from table and use results as parameter to job
If I understand correctly you want to run a job once per employee/date combination and pass the results on to the next process. I don't know if that will be quicker as you hope, but here's how I have ...
 Topic: Import rule definition using API loses description
boxtoby

Replies: 3
Views: 231

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Thu Nov 30, 2017 5:03 am   Subject: Import rule definition using API loses description
Many thanks. Very Happy
Resolved
 Topic: Slow DataStage performance
boxtoby

Replies: 15
Views: 847

PostForum: General   Posted: Wed Nov 29, 2017 10:38 am   Subject: Slow DataStage performance
Hi
I have had scenario 1 when working from home and the connection not as good as in the office. I found that turning off "show performance statistics" in designer helped a lot.

Hope that helps, ...
 Topic: Import rule definition using API loses description
boxtoby

Replies: 3
Views: 231

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Wed Nov 29, 2017 9:03 am   Subject: Import rule definition using API loses description
Sorry, the second xml piece should have been titled:

and here's an xml file where the description is NOT imported:

(Main Subsidiary Group and COMMERCIAL GRP not imported)

etc
etc
 Topic: Import rule definition using API loses description
boxtoby

Replies: 3
Views: 231

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Wed Nov 29, 2017 9:01 am   Subject: Import rule definition using API loses description
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
I wonder if anyone can help me with some apparently inconsistent behaviour when importing a data rule definition using the api?

Here's the api command I'm using:

CreateCmd=`$IAAdminPath/IAAdmin. ...
 Topic: Generate sequence number using parallel job
boxtoby

Replies: 6
Views: 1118

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jun 22, 2017 5:45 am   Subject: Generate sequence number using parallel job
Hi,

You weren't far out with your original idea.

Here's what I use: (@PARTITIONNUM+1)*10 : @OUTROWNUM

Use @OUTROWNUM rather than @INROWNUM to aviod problems with funnel stages etc.

Hope th ...
 Topic: Paralle routine to count num bytes
boxtoby

Replies: 12
Views: 1605

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Mar 10, 2017 7:34 am   Subject: Paralle routine to count num bytes
As it's a unix flat file would the unix command "wc" not suffice?
 Topic: User inserted sort
boxtoby

Replies: 1
Views: 640

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Mar 01, 2017 10:52 am   Subject: User inserted sort
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hello,

I have a job which is identical in development and production.

In production it works because the partitioning behaves correctly on the two join stages in the job.

In development the j ...
Resolved
 Topic: Server Routine
boxtoby

Replies: 18
Views: 3142

PostForum: General   Posted: Mon Dec 19, 2016 10:44 am   Subject: Server Routine
You ask "3) Any other feasible way...."

If you mean is there any other way of retreiving job stats you could look at the database XMETA.DSODB which contains all this information. DSODB is quite ea ...
Resolved
 Topic: Importing sequential file with double quotes in data
boxtoby

Replies: 2
Views: 809

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Nov 28, 2016 10:48 am   Subject: Importing sequential file with double quotes in data
Hi Guicar,

I have seen this sort of problem before, even to the extent that there were 4, 5 or even 6 double characters in the data!

I solved the problem by using the sed command:

sed s/'"";' ...
 Topic: AVI Country Validation
boxtoby

Replies: 4
Views: 3523

PostForum: IBM QualityStage   Posted: Tue Nov 22, 2016 6:39 am   Subject: AVI Country Validation
Hi dj,

I haven't used qsav for a while, but my recollections are that the results differ depending how you pass the data in to qsav.

If you send in distinct street, city, state, zip country colu ...
 Topic: Dual monitor losing Designer panels
boxtoby

Replies: 2
Views: 792

PostForum: General   Posted: Wed Oct 19, 2016 5:14 am   Subject: Dual monitor losing Designer panels
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi Guys,

I think this is actually a windows problem, but I'm wondering if anyone else has come across this problem and knows how to get out of it.

I am using a laptop with a second monitor conne ...
Resolved
 Topic: Run Column Analysis from the api
boxtoby

Replies: 2
Views: 2742

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Tue Jan 12, 2016 3:19 am   Subject: Run Column Analysis from the api
Hi Robert,

Perfect!

Many thanks.

Bob.
Resolved
 Topic: Run Column Analysis from the api
boxtoby

Replies: 2
Views: 2742

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Mon Jan 11, 2016 11:01 am   Subject: Run Column Analysis from the api
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hello,

I am wondering if anyone has successfully used the IA API to run column analysis?

I have used it successfully to run DQ rules and extract the results, but I am struggling to use it for ru ...
 

 Jump to:   



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