DSXchange

Can you explain what "alignment is all messed up" means? Example? You understand that the problem with the FTP stage is that it is metadata driven, yes? You can use it to manipulate a file's structure during transfer but that also means that you can hork it up as well if you don't get everything exa...

ORA-03135: connection lost contact Cause: 1) Server unexpectedly terminated or was forced to terminate. 2) Server timed out the connection. Action: 1) Check if the server session was terminated. 2) Check if the timeout parameters are set properly in sqlnet.ora. Your DBA should be able to trace the ...

Excellent! Thanks for the detailed solution.

ArndW wrote:I though Oracle SQL needs you to specify the keyword "as"?

Nope, optional. Besides, the column names selected don't matter as they are assigned to the stage columns positionally... unless PX changes that?

According to our moderator Roy, it's now "InfoSphere":

roy wrote:InfoSphere Information Server 8.1 was released on Sep 30th (for windows and linux)

Sorry, out of ammo in this gunfight. Not a big fan of stored procedures so only really use them to call the built-in database procs we need, otherwise their logic gets encapsulated in the job. Hopefully someone else will be able to, or perhaps check with your support provider and see if they can she...

Maybe my memory is faulty... I thought the whole set in the sdk was for converting from COMP. I don't remember a set for converting to COMP. Well, maybe it's my memory that's faulty then. I know there are conversion routines out there, let me check... ack, you are correct. From is the supplied dire...

There ya go!

Sheesh... don't people 'preview' what they are going to post? ASCII art requires the "diagram" be enclosed in code tags to retain all of that loverly whitespace so the picture makes some sense.

Mike wrote:Nobody here can help you unless you post the code of your site-specific custom routine: ConvertToDataTypePicComp. That's not a routine that ships with the product.

Sure it is, it's included in the sdk along with a number of other similar conversions.

Worth a shot. Add a transformer before the SP stage, give it a dummy stage variable and set the contraint to @OUTROWNUM=1 so it only generates one record for you.

Hmmm... a type of 'Transform' means it expects input and output links. With your design, it should be set to 'Source' instead. Not sure that's the sum total of your problem, but wanted to point that out.

Would certainly seem to be. Report the problem to your support provider and see if this is a known issue.

Command editor? If that means command line:

http://www.dsxchange.com/viewtopic.php?t=122717

Next time, know that you can always delete your own post as long as there are no replies to it. So when this happens to me, I start from the bottom and delete the extra ones. Too late now, though.