DSXchange

Fully agree on the behaviour of dsjob and understand the special tokens as well. Perhaps I'm thinking of the 7.x version of the Job Activity stage as I've yet to see the 8.x one and I don't recall any "Set to Default" properties back in the day. What I remember is you simply left them empt...

I'm curious about something. While you are presented with all job parameters for the attached job in the Job Activity stage, you are not required to pass values to all of them. And when you do not pass a value, it should use the parameter's default / design time value. Are you saying that's not the ...

Ok, so "The above logic not working" eh? That's because you didn't explain the rules in your original post. Have you tried to modify what Arnd posted to take into account the rules you posted? Basically you can still use two stage variables, start the GroupNo off at 1 and then increment it...

ps. I would think some version of Arnd's logic could help here, but I for one can't tell what in the heck a "group" would be in this case and I'd rather not guess. Please explain to us the rules around your mystery number and when it should be incremented.

I would ask that you (and anyone else reading along) do a few things for us if you are going to be posting here. First, the subject of your post should be descriptive of the problem, not simply "need help". We are all here for help, so that doesn't really provide any value. Secondly, do no...

An exact search for "instant client" turned up some posts that say the answer is no.

I'll be the first to admit I've only used the Folder stage as a source & never as a target. If it works anything when writing as it does when reading, you may need to send the entire contents of the file at once to the non-key column. I'm not sure what to make of the documentation when it says: ...

OK. Let's keep the conversation here, please, no need to post it in multiple places.

What properties / settings do you have in the Folder stage?

OK... so there's more to come with the routine. I'm guessing the JOBNAME value you passed in is not valid or is not in the current project, which is why the handle attach failed. Add some helpful DSLogInfo() debug messages until you get it all working.

Let's not worry about what you are doing at the moment, let's start with asking what exactly are you trying to accomplish? Your routine will need to do more than simply attach to something and won't need a handle if the "svJOBNAME" value is the current job calling the routine.

This isn't PX so you don't really need to explicity convert it. You do, however, need that function if you have to remove "non-numeric" values from the string. It is the equivalent of the DIGITS transform.

<Moderator: split out to your own post, linked back>

Note I had to guess at your Release and OS so please let me know if those are wrong.

Also make sure you understand a couple of things: 1. The dashes in your desired output are not part of the actual XML but rather an artifact of your display tool - IE, I assume. 2. Do not worry about all of the formatting your example shows - you format ('pretty print') XML for peoples, not for cons...

I'm sure those steps are documented in the manuals. I'm curious how much XML experience you have, both in general and with DataStage in particular? It can get very... confusing... if this is your first exposure to the Wonderful World of XML.

First step would be to get your hands on an xsd and import that metadata so you can properly configure the XML Output stage.