DSXchange

OK, hold on... is this a Server job as posted? If so, my bad, lost track of what forum we were in - that function is a Parallel function, which would be why it would not be "accepted". You'd either need to work with IConv/OConv or just substring it apart and put it back together in the for...

Classic problem - the format mask you use in the function needs to match the format of the incoming string, not any perceived output format. Timestamps don't have an internal format so it just needs to know how to parse the string to turn it into a timetamp.

The "timestamp" part is the important part, not the specific format you posted. Have you tried using the StringToTimestamp function? What issues are you facing?

Oh yes... a very special prize. <wink,wink>

... or we could just continue to guess based on the wonderful example data.

It looks to be losing the entire time portion, hence the default to midnight. Clarify for us exactly how your target column is defined in Oracle and how you are "loading" it in the job.

Too complex? Really? What I'm remembering is a list of jobs from the Sequence and their status - Ran OK, Aborted, etc. And from what I recall the problem child is the last one in the list. But... ok.

No such equivalent in the 7.5 world.

Move of a Tivoli than DataStage problem I would imagine and it depends on how Tivoli controls / initiates / monitors DataStage jobs. I'm assuming that would be part of the "job stream code" that was requested.

In other words, you have no issue and it is doing exactly what it should be doing. Another alternative is to convert it back to a char when you select it from the DB2 table if that leading zero is needed / significant.

Technically, it seems to me that any stage with only an input link would be a target and thus considered as a 'last link'. And I believe that a call to DSGetStageInfo() would return that when using DSJ_LINKTYPES as the Info_Type.

32 characters? If so then yes, best assumption would be MD5. If it's important to know for certain, ask your official support provider... then let us know!

I don't see anything in the documentation that calls that out. What does it output as the 'checksum' - a string or a number? If it is the former then I'd assume it is an MD5 hash, for the latter I'd assume a CRC32 value.

It is worth noting (again) that the filename property is required. So rather than putting something meaningless in there, understand that the stage will automatically combine it with the filter command to produce the stream of data that the stage will read. Meaning, you should be able to put your pa...

HemaV wrote:i'm not sure on approach. trying to see anything can be done

Fine. Again - what are your Business Requirements / transformation rules? Explain in words how to perform the splitting of the two columns so that people can stop guessing what you need done.