DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 44 matches
Author Message
 Topic: Server Jobs Deprecated
DSUser2000

Replies: 3
Views: 1038

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Sun Aug 02, 2020 3:26 am   Subject: Server Jobs Deprecated
This is weird, especially as there is no real substition for the "UserStatus" (afaik) apart from manually reading in the file in the sequence.

From the text in the changes I cannot see that it will ...
 Topic: Best way to handle password parameters
DSUser2000

Replies: 9
Views: 2109

PostForum: General   Posted: Thu Jun 28, 2018 8:18 am   Subject: Best way to handle password parameters
Maybe it is really a bug...at our site, it works totally flawlessly. We did it like that:
- In Administrator, define separate project variables for database user, password, schema etc.
- Create a "D ...
 Topic: Best way to handle password parameters
DSUser2000

Replies: 9
Views: 2109

PostForum: General   Posted: Wed Jun 27, 2018 10:37 am   Subject: Best way to handle password parameters
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Additional info: Security Best Practices
NOTE: Split off from The security group is pushing to revoke any database privilege that smells like it could be elevated, as well as pushing changes that would force us to change database passwords o ...
 Topic: Reading a character using the correct charset
DSUser2000

Replies: 2
Views: 1967

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 27, 2018 10:07 am   Subject: Reading a character using the correct charset
You need to use "ustring" in your schema file, so a unicode string. Then it should work fine. You can even define the charset per column like this:
(
Field1:ustring[10]{charset= ...
 Topic: Connecting to Designer/Director from command line
DSUser2000

Replies: 6
Views: 1584

PostForum: General   Posted: Mon Apr 16, 2018 9:45 am   Subject: Connecting to Designer/Director from command line
Datastage Designer does have command line parameters so that you can start without any interaction:
dsdesign.exe /H=<host> /D=<domain> /U=<user> /P=<password <project>
By ...
 Topic: Email Notification activity sending AT000001.txt
DSUser2000

Replies: 4
Views: 1540

PostForum: General   Posted: Mon Apr 16, 2018 9:34 am   Subject: Email Notification activity sending AT000001.txt
In your Server/Projects/<Projectname> folder, you will find a file called "dssendmail_template.txt" (you should call it "dssendmail.txt" when you use it so that it survives patches/upgrades). Th ...
 Topic: Adding new empty parameter to a heavy-used sequence
DSUser2000

Replies: 3
Views: 1737

PostForum: General   Posted: Mon Sep 14, 2015 2:16 pm   Subject: Adding new empty parameter to a heavy-used sequence
I think it would probably work but in accordance with the coding standards here we are not allowed to create project level parameters on our one. These parameters are only allowed to be defined for re ...
 Topic: Adding new empty parameter to a heavy-used sequence
DSUser2000

Replies: 3
Views: 1737

PostForum: General   Posted: Mon Sep 14, 2015 7:36 am   Subject: Adding new empty parameter to a heavy-used sequence
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
I have a sequence which is used in many other sequences. I now want to add a new string parameter to it because a few calling sequences need a "special logic".
The parameter should be empty as a defa ...
 Topic: Reading binary data as string in parallel job with schema?
DSUser2000

Replies: 1
Views: 1228

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jun 18, 2015 11:41 am   Subject: Reading binary data as string in parallel job with schema?
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
I have a file with some hex strings in it like the following three bytes: x'43 x'56 x'78
I want to read that into datastage within a sequential file stage using a schema file and get a string that ha ...
 Topic: Change default parameter values of stage?
DSUser2000

Replies: 3
Views: 1078

PostForum: General   Posted: Thu Feb 06, 2014 4:37 am   Subject: Change default parameter values of stage?
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Is it possible to somehow change the default values that are in a stage when you take it from the design canvas? We need to do some settings over and over again in the DB2 Connector stages and some de ...
 Topic: XML stage is very slow?
DSUser2000

Replies: 1
Views: 1165

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Oct 14, 2013 2:29 am   Subject: XML stage is very slow?
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
We are using Datastage 8.7 and we try to use the new XML stage instead of a server job with the XML input stage. For a test, we tried to parse the XML joblogs (a few thousand) that Datastage can produ ...
 Topic: Alpha characters in Decimal Field
DSUser2000

Replies: 12
Views: 3939

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Jul 13, 2013 12:41 pm   Subject: Alpha characters in Decimal Field
I'm also wondering why you don't get a warning about unsuccessful conversion (I'm talking about a warning and not an explicit error; warnings don't lead to aborts if you didn't specify to "abort after ...
 Topic: Question on Uninstalling Infosphere 8.7
DSUser2000

Replies: 4
Views: 1486

PostForum: General   Posted: Sat Jul 13, 2013 11:31 am   Subject: Question on Uninstalling Infosphere 8.7
Wasn't 9.1 advertised with having an in-place-upgrade from 8.7? Or is that just working when you don't have FP2 installed?
Resolved
 Topic: Double to decimal conversion using modify stage
DSUser2000

Replies: 4
Views: 4909

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Jul 13, 2013 3:21 am   Subject: Double to decimal conversion using modify stage
You can also tell your Aggregator to directly output decimal values by adding the "Decimal Output" property under the "Sum Output Column"! This would be the preferred solution in my eyes. Otherwise, I ...
 Topic: Long login times from command line when using credentials
DSUser2000

Replies: 0
Views: 701

PostForum: General   Posted: Sat Jul 13, 2013 3:08 am   Subject: Long login times from command line when using credentials
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
We are starting our sequences from AIX command line via dsjob under 7.5. Under Datastage 8.7 we now noticed that dsjob command seems to have a very large startup time (5s even for a simple -lprojects) ...
 

 Jump to:   



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