DSXchange

I know this has been "on the table" for some time now but I don't believe the site owner has anyone able to do tasks of that nature right now and hasn't for some time. I've also heard rumors of a whole new site / redesign coming but no clue whatever happened with that.

Hmmm... guessing you'll need to involve your official support provider on that one. Are you using the DB2 Connector?

For grins, can you confirm for us what 'action' you are using Before Job to run this command - ExecSH? I assume so but it would be good to explicitly state it.

Welcome aboard.

Since this is a new problem, I split your issue out from the (somewhat) related post you found and put it in this forum. For reference, that older post was this one.

Heavy emphasis on the if all dates are from 2000 part. Or you can use the year_cutoff option to handle it properly. For example: DateToString(StringToDate(DSLink6.DischargeDate,"%dd/%mm/%1930yy"),"%yyyy-%mm-%dd") From the documentation: The year_cutoff is the year defining the b...

It's all documented so there's really no reason for someone to list "all of the steps" here. This is a good place to start, other official resources exist online as well. Then feel free to come back for help if you have any specific questions or issues.

Only if you write one.

Guessing they're not starting in the correct column number for COBOL metadata, which is what.... 7? 10?

(think I've lost most of those brain cells)

Sorry, no time to post specifics right at this point but you have a "century pivot" issue where it is using 1900 rather than 2000 for the century when going from YY to YYYY. An exact search for that phrase here should help.

Details please. Which connector stage is this? Is this actually a Server job or is it a Parallel job? I can make an educated guess from the error message but always best to post specifics. Also, that SQL doesn't make much sense to me at first glance as you seem to be selecting the same value you alr...

ray.wurlod wrote:Fair enough.

Thanks... didn't want to put words in your mouth and knew you could explain how you saw this playing out for those of us a little behind the curve. That and I didn't have any kind of time for a proper reply.

Ray, I think the confusion is around the "SUBROUTINE ParseTimeString" that you posted. It writes its output to a sequential file and Sam is looking to leverage it in a Transformer derivation, thinking it should pass the parsed data back to the caller. At least that's what I think I'm readi...

<split you out to your own topic, that one was 7 years old>

Confirm for us the exact version you are running and if your server is on Windows or UNIX, please.

Any chance you were given an xsd for that XML? If so you can import from that.