DSXchange

OK. if you don't have access to the incoming schema and what you need could be pulled from what you just wrote to TableA could you do something like

Example:
UPDATE TableB SET MyField = (select MAX(ORCHESTRATE.ColumnA) from TableA)

What is the main difference in using the the user defined sql and a regular insert statement. I was debugging a job that wasn't working as expected and noticed that the developer had the write mode set to 'USER DEFINED SQL' for a very basic insert using job parameters. While using the same insert sq...

Is allowing the join to insert a tsort better or any worse than adding a sort stage yourself and then setting the partitioning to SAME in the join stage.

I have a rather elementary question. If a join expects sorted data and the data isn't sorted it adds a tsort. Is this correct? Also, if a sort stage is added before a join where the data isn't sorted will this make a join perform better?

Try to get it out of your head that everything must happen on a single node. Are you seeing something that leads you to believe these things are running on a single node? It is possible to force sequential behavior in a parallel job, but it's not often going to be desirable. I don't have it in my h...

Ok a join requires sorted input but does that mean if it's not sorted a sort is entered for you? Also does a join require that the sorted input be on a single node? In other words when a join happens does it get repartitioned to a single node?

You say "A Join stage requires sorted inputs. If the join inputs are DB2 ordered outputs, then you can set the properties to tell it don't sort; it's already sorted. " Ok a join requires sorted input but does that mean if it's not sorted a sort is entered for you? Also does a join require ...

I have some general questions regarding the sort stage the the collector sort properties of stages. Is it safe to assume that using the sort stage to sort on a key is equivalent to using the collector stable sort of lets say the transformer stage? What are the main differences/similarities of the tw...

I believe there's a shortcut for all stages inside the shared container. If you open the job properties and check or uncheck the option for RCP on new links it will prompt you at that time to apply the change to existing stages.

I have a generic question regarding parallel shared containers and runtime column propagation. Do all input columns that go into a shared container's input automatically get passed through to the shared container's output? Does RCP have to be enabled to make this happen? RCP can be enabled on the sh...

The first byte of the column in question has a binary indicator (description of the field), followed by a byte for the binary length of the data segment followed by the ebcdic data segment where the length byte tells the length.

No, the file isn't from a mainframe/

I'm saying that some fields are ascii and some are ebcdic, but there's one field that's a combination of ascii and ebcdic. The first byte is the description of the field followed by a length byte of the data followed by the data segment. The first two bytes are ascii and the data segment is ascii.

I'm using a column import that takes a schema file and reads in a file that's partially ascii and partially ebcdic. Most columns are either ascii or ebcdic and can be specified which in the schema file but I have one that consist of both ascii and ebcdic characters so I have to read it in that way. ...

Is it possible to call Trim using a list of characters to trim? I haven't been successfully parsing the Documentation.