DSXchange

Read the control record in one job. A server job is best for processing one row, as is has much lower startup cost. Write this to the server job's user status area or a file. Run the second job, supplying that value as a job parameter that you use in the WHERE clause of the SQL in the Oracle stage. ...

There is a routine that can dump into a CSV format.

Care to explain how?

Any job parameters must be in the parameters field.

Command: chmod

Parameters: 774 #$ScriptPath#/#FileName#.KSH; #$ScriptPath#/#FileName#.KSH

You could load all the searchable strings into a key-only UV table (= hashed file) and use user-defined SQL SELECT key FROM table WHERE EVAL "Index(?, key, 1)" > 0; It's ugly, it's slow, but it will work. I can't at the moment think of a better way. To populate a UV table you need ...

Prediction: user requirement will change once they start getting lakhs of emails from this process.

Two in one job might be tricky, since environment variables such as ORACLE_HOME can only have one value at a time. But you should be able to run different clients from different jobs, by making the Oracle environment variables job parameters. Just make sure you account for all the variables needed, ...

It would still be premium content were I to re-post. Do purchase premium membership. It's not expensive, at less than 30c per day, all of which is devoted to defraying the hosting and bandwidth charges incurred by DSXchange. By taking premium membership you are not only getting the benefits thereof,...

Please try to keep up. If expression Then @TRUE Else @FALSE is superfluous. It is sufficient to use ( expression ) alone. If the value of expression is "" or 0 (or anything equal to 0) then the result of expression in a Boolean (logical) context is @FALSE. Any other non-null value is regarded as @TR...

Why? It's what the ODBC driver retrieves from Oracle when it requests column data types.

Fix? A better ODBC driver. Or write your own. Or import metadata using the orchdbutil facility if you have Enterprise edition.

What you're seeing in Toad is the first few rows to be returned. What's your Toad display limit - something like 250 rows? Of course it will appear to finish - it only has to finish 250 rows. If you limit DataStage to 250 rows it will probably finish in about the same amount of time. Manage your exp...

Processes with no pids may be owners of locks that have ceased to be logged-in processes - that is, defunct processes or zombies.

Record 0 is line number 0 in the file. Since everything is written in C (or C++) counting is always zero based. Please show us what's actually in the file - in particular what's in character position 17 (that's the 18th character) on the first line of the file (that's line number 0). Note that there...

OK so you can just re-run the server installation - it will go into maintenance mode and you can re-license then.

I believe it's also possible to (re-)license any component using the uvregen tool.

Set up NLS_LANG in dsenv or in the Administrator client if you want different per-project settings.