DSXchange

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 already be removed from the Datastage Designer (only no improvements anymore), right? Maybe ...

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 "DB" parameter set out of those parameters and set them to value=$PROJDEF - Add the "DB&q...

NOTE: Split off from this topic after a change in subject. 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 on application/system IDs that were already exempted to be non-...

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="windows-1252"}; ) If all does not work: Use iconv to convert to Unicode and read this with an "Ex...

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 this, you only need to check if it opened and then close it. It could also be enough if you check other things which are fully co...

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). This is the script that is called by datastage when a mail is sent. It is more or less a...

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 really global variables...

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 default (so not blank but really an empty string). However, I didn't find a way to do this with...

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 has "435678" in it. Is that possible and if yes, how? Background: I want to generate the sche...

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 developers then forget them...

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 produce (DSJobReport). The job in both cases only does the import and peeks out data so it is for sure on...

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 1 warning" in the job run options). What datastage version do you use? Apart from that yo...

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?

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 would do such conversions just in a transformer and not a modify stage.

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) and the dsjob process consumes a whole Power7 CPU core during this when used with user/password in ...