DSXchange

Trim() won't help the test. If it's null, it's null. You can simpllfy your logic. Reversing the logic will remove the need for Not(). And you can be less specific about the format for Iconv(). If IsNull(Arg1) Then Ans = Oconv(Date(),'D4/MDY') End Else Ans = Oconv((Ico...

DataStage implicitly has the looping construct. Do your select from A, perform a range lookup against B, and use a constraint expression to determine whether row was returned from B (and therefore whether to send on to target). Table C is not required. If you need a multi-row return from B, you will...

That would be the best way to handle it! "They" have broken the rules for a well-formed CSV file.

Initial response is that it works in UniVerse/SQL. I will test using DataStage/SQL and let you know.

This error can also result from improper use of a non-opaque variable where an opaque variable (such as a file handle or a subroutine reference) is needed.

No. The logs of a job are kept in a table.

You can create your own; search the forum for information on how to do this.

To become a rich man you must have lakhs of lakhs of rupees.

The UVTEMP directory gets used by the Engine for: - temporary files when compiling sica constraints ('compconXXXX') as part of DataStage SQL security - temporary files used for sorting (partitions files that are then merged) 'sort'XXX') - temporary files for EXECUTE...CAPTURING ('captureXXX') which ...

What would it mean???

The Sequential File stage uses a C function to write to file. If the file is to be created, what gets created?

If the file doesn't have to be created, does it write to every file whose name matches the wildcard pattern? This is weird.

The solution is to get it right. It's possibly not in your SQL but in the other columns in the table not mentioned in the INSERT statement. One of them is numeric, and its default value (whatever that may be) is not a valid numeric value. That's all the error message has told you. But what may also ...

DataStage uses the directory mention in the UVTEMP parameter in the uvconfig file (rather than the directory referred to in $TMPDIR) for its temporary storage for server jobs. Its default value is /tmp. UniVerse best practice is to move this to somewhere else with lots more space, particularly on So...

Looks reasonable. At the risk of running in sequential mode, does it generate the warnings if you only use the built parameters? Can you post the message from the job log where the "$" characters have been converted to "_"? I haven't got a chance to investigate this this week but am beginning to sus...

The exception handler only fires if the job status is not handled. An "otherwise" trigger is deemed to have handled it in this context.

Common on the sub-continent (India, Sri Lanka, Pakistan, Bangla Desh). "Lakh" and "crore" are counting units, just like you use "thousands" and "millions"

One lakh = 100,000 (but usually written 1,00,000).

One crore = 100 lakh = 10 million (usually written 1,00,00,000)

Make a batch containing the job and its checker job. Always run the batch. That way the checker job will be as immediate as possible in version 4.x. Aborts are immediate; nothing else in the job can be started once an abort condition has been signalled.