DSXchange

Looks like you have have left 'Apple' unquoted, or quoted it with double quotes rather than single quotes, so that DB2 believes it to be a column name.

Well, you have 14 characters (" 206486993.752") but have specified a display size of 12; that might be it. Try making the display size 22 (the 20 significant digits plus decimal placeholder plus sign).

You'll need to check whether CASS includes COUNTY. (Being in Australia I don't use CASS all that much!).

Very few countries in the world divide their land by county, so I'd guess that GAV won't help here at all. But I'd be happy to be corrected on that.

Basically you are correct. A more rigorous description follows. The first Key column replaces the first placeholder in the WHERE clause, the second Key column replaces the second placeholder in the WHERE clause, and so on. The first non-Key column replaces the first placeholder in the VALUES or SET ...

Engage IBM Concierge Service (free). They will work with you to make sure that your installation checklist does not miss anything.

Code 11 is signal 11, also known as SIGSEGV, segmentation violation or access violation. It indicates an attempt to access a memory address that is not in the user's (process's) space.

Can you be a bit more specific about your requirement? String parameters can have a default of "" but using a default of "" for a Date parameter, for example, will lead to failure to start the job.

What does "not working" mean in this context? What exactly have you tried? (Share your command line, for example.)

Rounding only occurs when explicit or implicit conversion to a string data type is performed or when an arithmetic operation is effected.

Your main problem with this approach is that DataStage components can only run in a DataStage engine (parallel, server or mainframe engine), so your "generic" user would need to have purchased an appropriate DataStage licence (at considerable expense). Intellectual property rights would re...

I would suggest using a Loop in a Transformer stage, using the SaveInputRecord() and GetSavedInputRecord() functions to manipulate the stack of records, as well as LastRecordInGroup() with a dummy constant argument column to exit from the loop.

:D

Stuart, it seemed to me that counts were required. Otherwise your approach is valid.

Did you select the function from the list in the tabbed dialog on the right hand side? (Note, too, that CurrentDate() was only a guess - I don't have IA available right now.) I'm thinking that the function name may be case sensitive.

What is the log purge setting for this job?

Log purge based on runs is across all invocations. So, if you keep only one run, each instance will purge all other instances.