DSXchange

Can you please post some examples of the full values being passed as Arg1 here, ideally ones that work and ones that don't.

Edited to add: Never mind - "but if we give 45e45 then it doesnt identify it as varchar". That's because 45e45 is a number - in scientific notation.

FYI - always use the "Code" tags when posting code or anything else that requires the preservation of whitespace, otherwise the forum software will automatically collapse it down. Helps make it actually readable, assuming there was proper indentation done in the first place, that is. Hi i ...

WHERE LST_UPDT_DTTM <= TO_DATE('#pDATE#','YYYY-MM-DD HH24:MI:SS')

Try an exact search for "system table".

Aborts how?

If nothing there helps, come back and tell us what you tried and how (if any) the behaviour of the problem changed... and we'll see where we go from there.

First suggestion - try searching the forums for a common (non-unique) portion of your error message. For example, an exact search for "When checking operator: Defaulting" found 31 matches.

Interesting... I'd never seen that syntax until you posted it but on digging back through all of the pdf documents, most of the database stages mention it: If your entry begins with {FILE}, the remaining text is interpreted as a pathname, and the contents of the file supplies the text for the query....

Searching for "ParamValue/Limitvalue is not appropriate" would have answered all of your questions as you are not the first to encounter it.

Didn't mean it was an O/S command. You'd either need to run it from a dssh 'session' or leverage dssh to run it directly. For example:

viewtopic.php?t=124090

That way is fine. Another way is to leverage the USERSTATUS area rather than an intermediate file.

The UNIX 'at' is not quite the same as the Windows 'at'... and yes, the latter is what does all the scheduling when DataStage is installed on Windows.

For completeness, DataStage leverages cron for recurring schedules and at for 'one off' schedules - so you may need to check both to see everything.

Several problems. An unmatched #, lack of quotes around the pDate parameter and the use of TO_CHAR() when you should be using TO_DATE() and that only on the 'right-hand side' of the expression.

Oddly enough, that is the command you would use.