DSXchange

Right, it's not about the metadata but the actual contents of the field.

Yes, but perfectly relevant in Boise, Idaho.

Ah... no, I do not believe so. For the future ICE man then.

15 minutes? What is your setup? I'm guessing you are not local to the DataStage server that hosts these projects, eh?

Suggest you look into a Citrix based solution, it won't matter where you actually are and cut your VC times down to seconds.

You have to start at 'the end' and work your way back to the beginning with that particular option.

I am now able to run two instances of VC sharing different repositories from the same client. Since VC wasn't designed to do this in the first place, does anyone know if it is safe to go down that route? Why do you think you need to do this? I have four different 'Version Control repositories' and ...

rodre wrote:The box shows up after the last row on a new line.

That's because it is an 'EOF' marker, a.k.a a Control-Z if I remembers me DOS days. Should be a way to transfer the file without that little booger.

Cool, good to know.

I was going to give the same answers for #1 and #2 but didn't think that would be valid for PX jobs. Other than in a BASIC transformer, that is.

There are APT variables that control both the Oracle commit level and frequency, but don't remember their exact name off the top of my head. I'm sure a search of the documentation or this forum will turn them up.

Yes, you can - a combination of IConv and the Status function.

After job, DSGetLinkInfo with DSJ.LINKROWCOUNT as the InfoType.

May I know how to cat the files to be large file in DS version 4.0? You don't do it in DataStage, you do it in your operating system. Not positive on the DOS syntax, but think you can use either the type command or the copy command with a plus sign (+) to indicate concatenation. Check the help for ...

Well then, just how many warnings did these 10 rows produce?

More of an informational post than anything else.

Whichever you prefer... either of the first or last choices are valid approaches. I haven't used the 'Ora 7 bulk loader' so can't comment on that. Besides, there's a '7' in it.