DSXchange

That's really all you needed to confirm, that the field is set to hold 5 bytes. The other is CHAR semantics. Lots of articles out there in the wild on the difference, for example here or you should be able to have a chat with your DBA on the subject.

You already know the precison - a VARCHAR2(5) has a precision of 5. However, it would be good to know if that is 5 bytes or 5 characters and that depends on the "semantics" used. Toad will show that as VARCHAR2(5) BYTES but you can always check with your DBA. Sounds like you have a charact...

You don't need an "exact post". You have Pivot stages to work with and now you know this is called a "vertical" pivot - a.k.a. rows to columns. You'll find a full discussion of this in the product documentation or online here.

So, two different tables and one throws the truncation error or two different jobs selecting from the same table where one works and one doesn't? Assuming the former, do your table have any "unbound" numbers (without a precision specified) or LOB columns? Those are typically involved in a ...

Ok... not really sure what might be wrong. Is DataStage running on that same drive letter, E: ?

If you really want to be able to support your client across old DS client versions like that, I would suggest you either dual-boot to XP or if you have Windows 7 Professional, Ultimate or Enterprise you can download Windows XP Mode for free. Of course, you could always just try it and see if you hav...

:!: Guys, please stop with the constant "Reply with quote" action. Save it for when it actually serves a purpose, otherwise please use the perfectly lovely Reply to topic link that doesn't repeat everything from the previous post. And that also saves me from having to run around and clean ...

Correct, it does become false in that scenario. DataStage is fully aware of these "process breaks" and the dependancies on both sides of them. So all writes to a passive stage would need to complete before reading from that same passive stage would be able to start - unless something speci...

What are you running in the Execute Command stage and what does it return? What compile options have you enabled in the Sequence?

Short answer? Yes!

Again, how are you "calling" the batch file? Using the Execute Command stage in a Sequence job?

Your XML is being parsed correctly so the full pathname must be coming in from the ESS correctly or the XML Input stage wouldn't be reading it. I suspect this bit: Transformer : 2 fields , 1 input file_name(getting from ESS) and 2nd getting only filename(created in transformer) I would take a hard l...

You shouldn't have any issues with a 30MB file... I only started having problems with the old stages around the 200-300MB size range. The new stage being (from what I understand) a streaming stage should not have any such issues. And by "issues" I mean of the "fall over dead" var...

That is the way. Your only "alternative" is to contact your official support provider and get their help in re-syncing your repositories.

I'm curious, does the Server job use four links to a single target?