DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 125 matches
Author Message
 Topic: Generate sequence number using parallel job
boxtoby

Replies: 6
Views: 580

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

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

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

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

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

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

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

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

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 ...
 Topic: Exporting IA rules with version number
boxtoby

Replies: 2
Views: 2240

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Mon Nov 30, 2015 11:21 am   Subject: Exporting IA rules with version number
Hi Robert,

I am exporting the Data Rule Definition and the Data Rule using the export and import option within IA on the Quality Console. I don't know of any other way, is there one?

For this p ...
 Topic: Exporting IA rules with version number
boxtoby

Replies: 2
Views: 2240

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Mon Nov 30, 2015 6:59 am   Subject: Exporting IA rules with version number
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,

I am having a couple of issues with data quality rules:

Firstly
=====

I have recently made some changes to a data quality rule:

Definition: DRD_CUSTOMER_NAME
Data Rule: DR_CUSTOMER ...
 Topic: Retrieving user role information from xmeta
boxtoby

Replies: 2
Views: 635

PostForum: General   Posted: Thu Oct 29, 2015 3:27 am   Subject: Retrieving user role information from xmeta
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hello,

I am trying to retrieve user role information such as "DataStage and QualityStage User" from xmeta because the reports don't appear to provide that level of information.

I can see some of ...
 Topic: Filter stage clarification
boxtoby

Replies: 3
Views: 1195

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Sep 11, 2015 2:33 am   Subject: Filter stage clarification
Might be for one of several reasons:

Your expression DeptNo=10 might need to be DeptNo="10" if the column is a varchar

There may be trailing/leading spaces in the column. Insert a transformer be ...
Workaround Reported
 Topic: Reading SQL Server XML data type
boxtoby

Replies: 8
Views: 4130

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Aug 28, 2015 2:37 am   Subject: Reading SQL Server XML data type
I have a job which reads an xml column from an SQL Server table successfully on Red Hat Linux.

However, I had to add the following environment variables to the job:

$APT_DEFAULT_TRANSPORT_BLOCK_ ...
 Topic: Restarting the sequence
boxtoby

Replies: 4
Views: 765

PostForum: General   Posted: Thu Aug 27, 2015 5:46 am   Subject: Restarting the sequence
Always restart the top level sequence only. It will work out which sequences and jobs need to be skipped or restarted.
 

 Jump to:   



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