DSXchange

Why not give the Oracle Bulk Load stage a try? Pretty easy to use in 'Automatic' mode.

I want to know what 'dela logic' means, specifically. Examples of what you need to accomplish would be good.

Sounds like you need to reindex your project. Search for DS.REINDEX or DS.TOOLS for the appropriate conversations.

Because Server does not require an 'external' compiler, so we're all a little confused by your statement that you needed to do something for the XML stages. And the only thing that PX jobs need a C++ compiler for is when you add a Transformer stage to a job, otherwise the 'compile' step just generat...

And anyone who won't listen as well.

Ah... that makes sense.

And you (snt_ds) probably don't really want to select '*' from DS_JOBS, do you?

The XML 'Key' field is the repetition element and has no bearing on the Key fields in your target. Change your Key fields as needed in a transformer before the OCI stage.

It has Server, Enterprise (PX) and MVS changes in it from what I recall.

FAQ posted with the contents of the What's New in the 7.5 Release document.

Is your issue now resolved? If so, please mark the post as 'Resolved' otherwise let us know what issues remain.

First, define 'long time'. Secondly, try this as your first lines: DSHOME=<DataStage home directory> cd $DSHOME . ./dsenv Then this as your last line: $DSHOME/bin/uvsh "select * from DS_JOBS > jobname.txt;" Not sure if redirection is allowed here, if this still doesn't work you'll need to ...

What stage? User-defined sql? Please copy/paste the entire error message here and maybe even your sql too if user-defined.

That won't help.

Can others connect? If so, can you check with them to verify the host name they are using?

Of course, it would first truncate the table and then load everything. Then you have the standard APT environment variables to control the commit levels in Oracle.

You do know what 'truncate' does and the fact that it is... irreversible, yes?