I found working with date literal, when working with the Infosphere SFDC Connector soql, to be counterintuitive for me. At least as I, normally, as I use SQL. I spent a little time running trials in Workbench, before I finally locked on to the ‘where clause’ criteria data pattern. So, here a quick example.
SOQL DATE String Literals Where Clause Rules
Basically, the date pattern is straight forward. The basic rules are for a soql where clause:
No Casting function, or casting for the where soql where clause to read.
Example SOQL DATE String Literals
So, here are a couple of date string literal examples in SQL:
Example SQL with Date String Literal Where Clause
From Target_and_Segmentation__c t
where t.Target_Date__c > 2014-10-31
Salesforce Developer Documentation
Home, Developer Documentation, Force.com SOQL and SOSL Reference
Recently, I was asked to research if a Netezza Connector can be used in a server job. Basically, the answer is yes. The connector stage does exist and can be used. At least, I was able to make it work fine. However, a word of caution, the Netezza Connector stage, as of now, is not listed as a supported Server Edition stage in the IIS DataStage 11.5 ‘Parallel job stages and server job stages’ list page.
Parallel job stages and server job stages’ list page