DSXchange

Try emailing editor@dsxchange.com

Yes, from Director, schedule it 13 times.

Try Force Compile

You'll probably need a Modify stage to materialize the key column names.

For less than 30c per day you can get yourself a premium membership and then you would be able to. Premium memberships are how the hosting and bandwidth costs of DSXchange are met, so you'd be helping the site to live on. Did you notice the lack of ads? Details on/from the DSXchange home page.

Wrap the diff command.

Why are you using the Transformer stage? The PXPivot stage can do vertical pivoting such as you require with a lot less effort. Sure, it can be done with a Transformer stage, but why would you bother? If you insist on using a Transformer stage (it's a free country, or so we're assured, where you are...

Mike wrote:Be sure you don't miss the dot-space at the beginning.

You missed it.
It's

Some databases have a different privilege to permit bulk load.

Yes, it is a vertical, or reverse, pivot. This is described very clearly in the manual. What have you tried?

You would still get a list of projects, because that comes from the services tier. You may not be able to connect to a project because other services aren't running, but that would affect all users. Similarly, this particular user might not have rights in the project, but you tell us you're using cr...

Why do you think it's an issue?
Rolling back uncommitted transactions (for example when a session is disconnected) is a perfectly normal part of database operations.

Are you trying to overwrite /dev/null file? This will take an infinite amount of time. You should only ever append to /dev/null.

32KB is the block size used in a Data Set, whether virtual or physical. This is the smallest amount of data moved within a DataStage parallel job. Typically it's more - remember that the default buffer sizes are 3MB.

How have you set the Null Field Value and Default Value properties for this column?