DSXchange

If BizDate is an actual date it is NOT coming in that format - it's a binary value. Create a new parameter, say jpBizDateLastWeek and do the arithmetic when providing that parameter value.

You can not supply NULL as the value of a date/time/timestamp parameter.
You need to think of an in-band null equivalent (e.g. 9999-12-31).

Single quotes, surely?

Any comma in the data in row #16? Are the last fields in row #16 empty?

Does your Transformer stage include any constraint expressions? Use Monitor to verify that all nodes processed the same number of rows.

Depends mainly on where the database is.

Within the transformer stage it's a simple If..Then..Else test with a binary condition (date >= fouryearsago And date <= currentdate)

The .odbc.ini file is read first, to determine which ODBC driver to load into memory. It is the ODBC driver for Oracle that needs to consult tnsnames.ora.

If the most recent run has not been successful, but a successful run continues to exist in the job log, then you might use DSGetNewestLogId() to find it. If the log has been purged the information has gone forever.

I think the requirement is to read from the DBF files directly, rather than through FoxPro. There are Google articles about how to program this using languages like C# or VB that you may be able to adapt into, say, a DataStage routine.

Use a database stage (eg ODBC stage) to service the reference link, and use user-defined SQL that specifies the BETWEEN condition. You can generate the two dates using SQL functions.

%ss.6

My bad. 4am start today, it's now 8:30pm. Yes, it's a vertical pivot. Search DSXchange to find out how to do it. It's been explained many times.

In DataStage Director client choose Schedule View. On the toolbar there are Add To Schedule and Reschedule tools. You can right-click any job and remove it from the schedule.

Why can't you get the PDF? It's part of the standard documentation set. Start > All Programs > IBM Information Server > Documentation will take you to the bookshelf.