DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 1020 matches
Author Message
 Topic: Creating packages for objects with istool
Mike

Replies: 6
Views: 190

PostForum: General   Posted: Tue Mar 19, 2019 4:08 am   Subject: Creating packages for objects with istool
I haven't used the istool command line in the most recent versions, but is "create package" an option now? Or perhaps the OP meant "build package"?

When using the IS Manager GUI, creating a package ...
 Topic: Value for parameter could not be read using default value
Mike

Replies: 2
Views: 271

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Mar 15, 2019 1:39 pm   Subject: Value for parameter could not be read using default value
I think you are a bit confused on how parameter sets and their values files are stored on the engine server.

Your job design may be updating a file called param.txt, but I'll wager it is not the pa ...
 Topic: Need to get Object list from Package (.pkg) file
Mike

Replies: 6
Views: 503

PostForum: General   Posted: Thu Feb 07, 2019 7:47 am   Subject: Need to get Object list from Package (.pkg) file
Totally unsupported hack...

But the .pkg package file actually contains an XML document for the build manifest.

In case you care to pursue using that build manifest...

The .pkg file is simply ...
Resolved
 Topic: Set Parameter Value with Data Item
Mike

Replies: 5
Views: 2026

PostForum: Cognos (IBM BI)   Posted: Tue Jul 03, 2018 3:32 pm   Subject: Set Parameter Value with Data Item
Sorry. My bad. Didn't notice the forum.

Mike
 Topic: Best way to handle password parameters
Mike

Replies: 9
Views: 917

PostForum: General   Posted: Mon Jul 02, 2018 4:45 pm   Subject: Best way to handle password parameters
As UCDI says, you can't prevent someone with the DataStage Developer role from hacking your passwords.

In a project where there is no DataStage Developer role allowed (i.e. you can't create and com ...
Resolved
 Topic: Set Parameter Value with Data Item
Mike

Replies: 5
Views: 2026

PostForum: Cognos (IBM BI)   Posted: Mon Jul 02, 2018 4:26 pm   Subject: Set Parameter Value with Data Item
A job can not modify its own parameters. They are set when the job begins executing. The usual technique is to use a separate job/routine/command to derive the required parameters and then pass them t ...
 Topic: Duplicate Key values in CDC Stage
Mike

Replies: 7
Views: 1459

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Jun 08, 2018 4:23 pm   Subject: Duplicate Key values in CDC Stage
I'm not sure if this is documented or if it is just something I know from experience.

The change capture stage requires unique keys on its inputs.

This makes perfect sense if you think about the ...
Resolved
 Topic: Server Routine causing Exception Handler to trigger
Mike

Replies: 3
Views: 1006

PostForum: General   Posted: Wed Jan 03, 2018 1:43 pm   Subject: Server Routine causing Exception Handler to trigger
A routine activity must return 0 (reply=0) or it will trigger the exception handler.

I suggest calling your routine from a user variable.

A routine that returns anything besides zero requires a ...
Resolved
 Topic: How to solve below scenario using loop in tfm or otherway
Mike

Replies: 4
Views: 1072

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Fri Dec 29, 2017 1:18 pm   Subject: How to solve below scenario using loop in tfm or otherway
I don't see any need for transformer looping. It looks to me like you can do everything with stage variables and output constraints.

Mike
 Topic: Comparison logic not working
Mike

Replies: 3
Views: 1788

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Thu Nov 30, 2017 11:18 am   Subject: Comparison logic not working
If by CDC you mean the Change Capture stage, then be aware that it requires unique keys on both input links. You can see the result you describe when there are duplicate keys.

Mike
Resolved
 Topic: Passing and Calulating Expression Dynamically
Mike

Replies: 5
Views: 1478

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Sep 13, 2017 3:27 pm   Subject: Passing and Calulating Expression Dynamically
Bunch of nested if-then-else:

If Client = "A" Then Client A logic
Else If Client = "B" Then Client B logic
Else If Client = "C" Then Client C logic
...

Not at all flexible since you will have ...
Resolved
 Topic: Passing and Calulating Expression Dynamically
Mike

Replies: 5
Views: 1478

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Sep 13, 2017 7:53 am   Subject: Passing and Calulating Expression Dynamically
The transformer stage doesn't support dynamic derivation expressions. The design-time derivation expression is compiled into the executable code.

If you have a reasonable number of clients that won ...
 Topic: Challange in using dsjob -linkinfo feature
Mike

Replies: 7
Views: 2242

PostForum: General   Posted: Wed Sep 13, 2017 6:48 am   Subject: Challange in using dsjob -linkinfo feature
DSODB is way too valuable a resource to be locked away. All developers should have read access. Take it up with your admin folks.

Mike
 Topic: ETL Job rowcount and other details
Mike

Replies: 8
Views: 2717

PostForum: General   Posted: Tue Sep 12, 2017 4:21 pm   Subject: ETL Job rowcount and other details
Why reinvent a redundant wheel? Everything you need is already available in DSODB.

Mike
 Topic: Unicode with RCP?
Mike

Replies: 11
Views: 3662

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Sep 11, 2017 4:26 pm   Subject: Unicode with RCP?
You could experiment with the NLS Code page at the job and stage levels. See if UTF-16 will help.

Mike
 

 Jump to:   



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