DSXchange

There is no mechanism for customising job status. Yes you can use triggers, but you also have to either explicitly handle failures (Failure trigger) or disable the sequence's automatic handling of failed activities (a compile option on the Job Properties page). Routine and Execute Command activities...

I would not recommend any blog site to provide complete and accurate installation instructions. Get your information direct from IBM. Version 8.7: http://pic.dhe.ibm.com/infocenter/iisinfsv/v8r7/index.jsp Version 9.1: http://pic.dhe.ibm.com/infocenter/iisinfsv/v9r1/index.jsp In each case there's a m...

You do have to install four tiers. However this can involve one, two, three or four machines (and therefore installations). If your Engine, Services and Repository tiers are all to be on the same machine, you can install them all in one go. The Client tier, of course, must be installed on Windows. T...

Schema file?

Sort by date, use variables to identify whether the current pair of dates are contiguous, if not generate the intermediate dates.

Do feel free to experiment, as you seem to have done (because you've marked this thread as Resolved). One convention we have at DSXchange is to make a post indicating HOW a thread was resolved. You might help some other newbie.

DSJobInvocationId tries to get the invocation ID of the current job (that is, the sequence from which the job is being invoked). If the sequence is not multi-instance, this attempt is doomed. If you're not invoking from a sequence, then you're breaking a different rule; the invocation ID is not avai...

You can get a training class on Programming with DataStage BASIC, which has a comprehensive treatment of working with BASIC routines, from DSXchange

http://www.dsxchange.com springs to mind! :wink: Otherwise there's no single link or manual of which I'm aware; you will need to trawl through Information Center and developerWorks articles to gather all of the information you seek. And, if you're on version 8.7 or later and using the DataStage Ope...

How do you know that the file has to be split into four? The original requirement, it seems to me, to be files containing 100 records each. If you're going to go with splitting the file in that way, how will you pick up the appropriate file to run on each iteration? Are you familiar with the StartLo...

The original question has got nothing whatsoever to do with IADB. It relates to a directory used by QualityStage.

An IA Data Administrator can clear unneeded tables from IADB from the Console. It does not require a DBA.

Put some DSLogInfo() calls in to report what the SQL statement is, and what the exit status of each db2 command is. Check that DB2INSTANCE is correctly set. Try using both db2 commands in a single call to DSExecute. Call DSExecute("UNIX", Command1 : " && " : Command2, Out...

Sequential File stage has the ability to generate the file name into an output column.

Please post the entirety of the error message, as I asked.

If you're using an Oracle Connector stage you might be able to change the Error in Size Mismatch property from Yes to No (you'll get a warning instead). Make sure that the metadata in the job matches the metadata in the table. Ideally re-import the table definition (use the Connector Import Wizard) ...