DSXchange

gunabala,

the question is quite vague, which is why you haven't received a response yet. Could you be more specific in what you are trying to do? Is the mainframe data in sequential files on your DataStage server? What have you tried so far and what have been your problems?

That is a strange scenario. The array size should not have any knowledge of the data types, just the row and block sizes. Can you narrow down your error to a single column and perhaps even to a single value for that column?

Hello and welcome to DSXchange, Janakiram. If you browse the forums you will see that this site is a good place to get specific questions or problems answered but a bad one to get sample jobs and general explanations. The SCD stage is documented, at least in enough detail to experiment writing a job...

Hello and welcome to DSXchange, Janakiram. If you browse the forums you will see that this site is a good place to get specific questions or problems answered but a bad one to get sample jobs and general explanations. The SCD stage is documented, at least in enough detail to experiment writing a job...

Could you explain how you are calling DSSetParam() in a shell script and what your error message is?

Was the problem that your patch fixed related in any way to something that might affect your performance/timeouts?

The only real performance issue with a PX transform stage, in my opinion, is that it seems to take an eternity to compile; runtime performance is quite good as it is executing c++ code. Could you cite some specific examples of cases where people state that the PX transform is slow? PX has many stage...

I guess I did mean MCT. I wasn't sure which conversion it was, lacking the manuals, and actually had MCP down until I remembered that it didn't do what the poster requested.

Actually that number isn't fixed, it depends upon whether or not there is a leap year involved.

If you datatype is Date you can do a DateFromDaysSince() call, if the datatype is string you can also subract 3 years using a transform function such as In.Column[1,4]-3:In.Column[5,6] The program will do in implicit conversion from string to integer and then back to string.

Hello Sree and welcome to DSXChange. Almost all DataStage jobs can be exported at 7.0 and re-imported into 7.5 or 8.0 without any modifications whatsoever. Similarly, you can perform an upgrade from an old version to a new one with everything (or almost everything) converting without issues. There a...

The EE Engine doesn't have such a function. If performance is not a consideration then you can use a BASIC transformer stage in your job and do the conversion with OCONV(In.Column,'MCN'). Either that or write your own c++ function to do the initial caps and call that.

Are the columns nullable? If so, remove your population with CurrentDate and see if the error remains.

I just got back to a computer with the docs installed and couldn't find a string/conversion function that can be called in a modify stage; so you will need to use a transform stage to do this.

Search would have helped you, this was asked just a couple of days ago. Look at this thread.