DSXchange

I found the floowing out during testing jobs when upgrading from DS 6.0.1 to DS 7.1r1 : DS 7.1 handles Varchars that are empty strings differently to DS 6.0.1 When outputting to an AS400 DB2 target file, DS 6.x treats Varchar empty strings as an empty string, whereas DS 7.1 outputs these as NULLS. I...

No problem, glad to be of assistance!

No problem, glad to be of assistance!

I created a test job for this problem after testing my logic in a routine. I simply had a text file which contained the numbers in your example, applied my routine to them in a transformer, and then output to a DB2 table containing one field of type TIME. You must output the data in the DS internal ...

Sorry, this is cleaner:

Zeros = FMT(Arg1,"6'0'R")
Ans = Iconv(Zeros[1,2]:":":Zeros[3,2]:":":Zeros[5,2],"MTS")

This should work as a routine:

Zeros = FMT(Arg1,"6'0'R")
Ans = Iconv(Oconv(Zeros[1,2]:":":Zeros[3,2]:":":Zeros[5,2],"MTS"),"MTS")

An update: This is no longer a problem. I haven't change anything, and I have been told by the Unix admin guys that nothing has been tampered with on the server!? :? I still plan to upgrade to version 7.1 r1 very soon. I'm interested to know what caused this, but I fear that I would waste a lot of t...

Ray, I have tested what you suggested, and I've not noticed anything wrong in the tracing logs. I can happily view transformer stage properties, it's when right clicking and selecting a transform or Routine etc, in a column derivation or constraint, that the pc hangs. As I'm currently in a very quie...

Hi Ray and Roy Firstly, thanks very much for your help and advice. I should mention that we are running an unsupported combination of AIX 5.2 and DataStage 6.0.1 , Ascential support advise that we upgrade to 7.1. This is something that I have wanted for some time, but management desicions get in the...

Hi everyone. While in a Transformer: When defining output derivations for a column, or when defining a constraint, right clicking and selecting any of the following options: macro, function, constant, routine, and transforms causes my pc to lock up (mouse does not work, and I cannot use any keys). O...