DSXchange

Logged in as that used, you type 'groups' - the first one listed is their primary group. Or you can check /etc/passwd and /etc/groups directly.

Does it really matter what they are? Why not just always use A,B,C,D or 1,2,3,4 for the four invocation ids? Or if you feel you need distinct invocation ids, perhaps pass in the loop counter and then compute the invocation id: "job_number+(4*(loop-1))" for example.

Have your loop run a 'regular' Sequence job that takes as parameters everything it would need to run your MI job 4 times. Then have that Sequence job run the MI job four times with different invocation ids without a link between them so they all run 'at the same time'. Exit when all four are complet...

Sorry, but you've actually posted this in the wrong forum. There is a dedicated TX forum and you'd need to post there to get any answers.

No - just that it may need to be separate files for it to be valid XML. Tell us why you think you need it to look like this? It's sometimes best to explain what your end goal is, what you are trying to accomplish rather than what you think you need. What you end up needing may actually turn out to b...

You don't need a function in Server, simply 'move' the string to an integer field. And all of the functions are in the online help, search for BASIC.

First generate sql to get the syntax right, then tweak from there. For example 'Replace existing rows completely' includes a delete. I'll let others chime in on the space issue but I don't believe deletes like this will actually get you any space back. Not sure because I've never had a need to do th...

elias.shaik wrote:And changing the files into some other files like CSV or text file is not preferred.

You may want to reconsider that preference.

What backup would that be?

Describe your job design - where exactly are you calling the proc?

Another thought - why not logically delete the records? Rather than futz with all this, add a column and update it for the 'deleted' records. Check for the flag whenever you access the hashed file, treat it like a hashed miss when you find that it is set. That will keep your account based hashed fil...

Your hashed file must be pathed, i.e. created in a directory. In that case you'd need to create a VOC record pointer to it before you can use a UV stage over the hashed file.

No fair, you're one day ahead.

Wow... I wonder why they would care? We have multiple clients installed on our DataStage server, heck most database servers here have multiple client versions. One is of ETL and the others are for all of the other knuckleheads on the box with Special Needs. [shrug]

Oh well.

All in but nothing out = bad / improper XPath Expressions.