DSXchange

Hi Prasson,
I don't think that they use the IIS Manager for the migration. They export the jobs in .dsx format and then import this package in the Production server.

Hi Experts ! We work in an environment which is owned by another company and hence, do not have admin access to the application. As a result, we have to ask them to migrate our jobs and sequences from one environment to another (Example: From Test to Production server). What is the best way of ensur...

Hi Experts !!
Is there a way in DataStage to compile a sequence recursively, i.e., all the jobs called within the sequence (either a sequence itself or a parallel job) are compiled in just one shot ?
Or do we have to do a multiple job compile and select these jobs manually ?

It is actually an issue with 2 things. 1. The first is that StringToDecimal() will automatically convert any string to a decimal (regardless of the format specified) if it CAN be converted. So, "1234 abc" will be converted to 1234 2. The second issue (and a bigger one) is with IsValid(). T...

Also I am pretty sure that the isvalid test won't actually test whether the input string has the relevant precision rather that it can be converted to the relevant precision. So 0123 and 0123.01 and 123.456 would all return true for the IsValid(Decimal) check You are right. This was a mistake on my...

I would suggest using the Num() or Alpha() functions to find those values which contain only numbers or alpha characters. But this won't help me check for the precision. I need to discard everything that has precision greater than 3. I mean we can ideally write a code that will check for the number...

Its actually the IsValid test that is not working. If you were to pass your input un trimmed into the IsValid test you would probably find that it returns TRUE. I don't want to do that as my file may contain those junk spaces. Consider a scenario where the input is " 12" (or "<space>...

I did. And surprisingly, the output for the 3rd case is 123.000 ! Is this how TrimLeadingTrailing usually works ? Isn't it just supposed to remove the white spaces from the beginning and the end of the entire string ? Did you try outputting the return value of the trim function to see what was actua...

Hi Experts ! I have a parallel job that reads from a flat file and loads into a Netezza target. It has the following layout: File --> Transformer --> Netezza Target The transformer has a stage variable which checks whether a given column is Numeric or not. The derivation for this stage variable is a...

I tried what you suggested. In fact, I re-created this job from scratch. And it started working ! Now this is strange. I didn't make any change to the logic/properties/anything and still it started working on its own. Still not a solution though. I'll need to re-create all the jobs where I faced thi...

I am calculating the Checksum on 3 columns (2 VarChars and 1 Integer).

Is there any way of finding out what the error code 387 implies ?? Is there a documentation that lists down all possible errors returned by the Checksum.C code ?

Hi, I have a simple job with the following structure: Netezza Source -> Transfomer -> Checksum -> Netezza Target The Computation Mode for the Checksum is "Use all Columns except those specified" However, upon running this job, I get the following error: Checksum_Calculate,1: Internal Error...

There might be cases when you are using a Parameter Set in your project and suddenly start facing this error. The reason behind this will be that you have made some modification to your parameter set (added a parameter, deleted something, changed the name etc) and these changes have not yet been ref...

...another thought is...."is it really null" ....and....if so......"Does it matter?" Null is null...who cares how it is interpretted by a "display" tool.... does it satisfy true for isnull()? . ... at the back end... yes. but when i do a straight dump into a target, th...

It was changed in the database itself.

I haven't contacted the provider yet, but looks like that is the only thing that is left to do