DSXchange

Probably, but you're not allowed to download any external applications.

You will need DSGetJobInfo() function. The InfoType argument for end date and time is DSJ.JOBLASTTIMESTAMP

Can you connect to these data sources using an ODBC Connector in a DataStage job?

Can they be written to a text file? If so, I suspect that the user does not have INSERT privilege to this particular Oracle table.

Your example does not match your problem. How are you doing the Lookup? Are you using a conditional lookup based on the parameter having the value 1? Please provide more detail of your design.

First off, remember that counting is zero based, so field 2 is actually the third field. What is the value in the third field and what is its data type as recorded (a) in your metadata and (b) in the Data Set? Note that the error is from getInputFieldAsString() function.

Download ETLstats (for free) from Kim Duke's website - it will do all that and more.

Just encountered this error on an 8.5 system. Turned out the underlying problem was the fact that the root file system had become full, because /tmp was mounted on / and developers had been using /tmp for all kinds of stuff, primarily the ODBC trace file (and didn't bother to switch tracing off). Al...

Agreed

There's no such thing as Integer(15) - the largest possible signed int32 only has 10 digits. Hence the recommendation to try BigInt. What happens in binary when you try to store too large an integer is that you get "arithmetic overflow". The most significant bit tends to be set, which sign...

Did you use -mode reset in your dsjob command? Was it the sequence that you ran that reset, or a subsequence run from it (and, if the latter, was the job activity than ran the subsequence set to "reset if required, then run")?

"1" is Char(49)

What is "union" in your job design?

There's no such thing as a "modifier" stage. A Modify stage can not do concatenation. End of story. You will need to use a Transformer stage (or an External Filter stage, which will be much slower, or a Build stage, for which you must write your own code).

&SAVEDLISTS& should not ordinarily be used by DataStage processes, unless you are interactively connected to the server (for example in telnet) and quit from that account (project). Even then, the behaviour of saving your command stack in &SAVEDLISTS& can be disabled via the VOC entr...

You can do "sparse lookups" using DB2 and Oracle only in parallel jobs. However, these are manifestly inefficient so that they are not, in general, recommended unless the reference data set is huge.