DSXchange

Hey, I just signed up for DeveloperWorks!!! I didn't have to use a serial number or anything. Does that mean that my former banishment from Ascential DeveloperNet is over? Yippeee! I can now see what I used to be able to see before I was kicked off! I win! I win! I win! I just had to wait long enoug...

If the target table is partitioned and you have global indexes (spans all partitions), you get into issues when multiple parallel loads are running against named partitions. Those loads are trying to manage the same index simultaneously and you get problems like you're having. Is your table partitio...

hmmm, I can't remember any switches in the ODBC stages that will work. Any reason you can't use the STP (Stored Procedure Stage), it has a lot of features in it?

I'm an idiot, never mind, it's only for Oracle. Can you verify your version doesn't have SQL-Server support?

RDBMS or DB2 stages are options if you aren't committed to using the ODBC stage. They do have before/after SQL tables where you can put these statements or stored procedure calls.

Something in the table is being locked, indexes, partitions, etc by someone other than you. Your load is using DML instead of sqlldr. If someone/something else is sqlldr'ing the table with DIRECT path loads or such you can experience these typs of errors.

Get your DBA involved.

To clear out the children, you're going to either: 1. Issue a command line statement to delete all rows (or import from /dev/null with the truncate syntax, or runs a stored procedure), possibilities include using a Before-job/stage routine call, a Command stage, a Routine stage, or a Batch job using...

Change the SQL option to User-Defined, then you take 100% responsibility for well-crafted SQL. But, your issue is referential integrity. If there's a child row, how do you propose to remote the parent first? You have to either decouple the child rows, drop RI, or remove the child rows. Pick your poi...

You could have done it the same way in DS by generating a sortcolumn in a transformer and deriving a value that maps the priority. Output to a Sort stage and use the sortcolumn as a sort key field.

14 minutes from first posted to a Premium Poster answer. There should be no complaints.

Notice I did answer the posters question and didn't mark it as premium? There's a "free" answer.

Thanks, This message board used to be free...?? It is free, how much did you pay to just get that answer? You only pay for answers from me or the other Premium Posters, all 6 of us. There's nothing to prevent any other Charter/Premium Member from paraphrasing one of our answers or supplying one of ...

Kindly refrain from doing what you just did. If you're going to give out that stuff, just do it in a private message.

Next thing we know you'll be downloading our streaming video and emailing them to your cohorts....


Honor system folks!

Hey!! Look who's a Charter Member!!!

Free wisdom, I caught that comment.

I don't have an answer to your query, I just thought I couldn't let it pass that you've joined us on the Dark Side.

Active stages "do" stuff -> change data, add columns, filter rows, summarize rows, etc. Passive stages read/write data -> files, datasets, tables.

For the right skills, experience, and professionalism, absolutely.