DSXchange

I have not done this (yet?), so don't know if it will work. But I can tell you that SharePoint 2007 and 2010 both have many web services built in so you can interface with SharePoint to read various types of lists and more. In DataStage you can use the Web Services Client stage or the Web Services T...

I was just joking about the counter...

Constraint syntax expression should evaluate to true or false. You don't need the if/then/else wording in it. Some simple examples: This constraint would always be true: 1 = 1 This constraint would always be false: 1 = 0 You can compare a column: link.Column_A >= 2012 Etc. Try right-clicking when yo...

That's not too long of a contstraint. What have you tried to narrow down the problem?

Is there absolutely nothing in the job log at all after you start running the job?

Do you by chance have a database stage with a query that is taking a very long time to execute?

1 "thrill seeking" visitor to the system requirements web page. Just a joke as sometimes I wonder if I am the only one who attempts to review system requirements before installing...

Apparently so... the visitor count said 000001.

Out of curiosity, I checked the IBM web site and found this about Windows 7: 8.5 and higher clients are supported on Windows 7 Professional, Windows 7 Enterprise, or Windows 7 Ultimate. Note that Home Edition is not listed. 8.1 and older don't list Windows 7 at all. Therefore, clients prior to 8.5 a...

Parallel Job Developer's Guide wrote:When you are reading files, you can use a reject link as a destination for rows that do not match the expected column definitions.

Try going into the stage and changing the reject mode.

Craig, Windows 7 Home Edition is not supported for client or server, but there are other editions of Windows 7 that are supported for the newer Info Server clients, again not servers. Definitely no version of Windows 7 is supported for DS 7.x as most likely Windows 7 didn't even exist back then...

You could also using Information Analyzer. If you don't have it, maybe ask for a trial.

Technically, I suppose you could take pipeline1 and copy part of it into a Lookup stage as the reference link. My opinion is that the proper way is what you mentioned already using 2 jobs plus a sequence job. It would depend on your reason or if you're just curious.

RCP works, why not use it?

Just a guess without searching, have you tried changing the data type in the job design before it hits the ODBC stage (avoiding the cast)?

Man, Remove Duplicates stage won't capture duplicate records; it will only eliminate them.

Hint: It's referenced in one of the links I posted above.