DSXchange

Stephan's approach has the additional benefit that these sub-folders can then be referenced as custom folders by Version Control for DataStage.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

The message says it all. You're trying to load a value into a column but that value violates the data type requirement of that column. For example, you may be trying to load "FRED" into a column whose data type is Integer. The UV stage enforces data types. If the key comprises one or more columns, d...

You can create a job sequence with a WaitForFile activity that awaits the arrival of the file generated by, and transferred from, the DataStage job on the mainframe.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

It would be really useful if these white papers were on the Ascential web site.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

That could be an incomplete installation, or a version mismatch of the JVM (Java virtual machine), or something strange happening in Windows. What version of Windows are you running? I think you're going to need to get your support provider to help on this one.

[?] I really can't see what any of your requirements has to do with DataStage. You're really just after help constructing SQL statements.

I second Ken's diagnosis. Can you post your sorting criteria and the contents of the Inputs grid of the Aggregator stage?

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518

When you compile a server job from Designer, the actual work is performed by a "helper subroutine" on the DataStage server machine. Exactly how this is done is not documented, and there is no command line interface provided to it. Check out CompileAll for DataStage (which you can get for free from t...

That's going to depend on what kind of UV file you've created! By and large the structure is intended to look after itself, and does a pretty good job of it. For dynamic hashed files (the default type) you can inspect the file with the following command, which is executed from the TCL prompt (or the...

DateGenericIsDate expects delimiters in the date. But it could be adapted. You can construct a routine something like the following, and use that routine directly in an expression (such as a stage variable derivation expression or an output column derivation). FUNCTION IsYMDDate(TheString) $COPYRIGH...

quote: Originally posted by rubakuma [br]I am loading a text file to SQL Server. One of the fields in text file, say VoidIndicator. If VoidIndicator "V" then the record is populated into SQL Server. I need to know the number of rejected rows ie) number of rows with VoidIndicator = "V". How do I do t...

For everyone else's benefit, TJ's point is that in version 6.0 use of shared containers is limited to multi-CPU (SMP) systems; it is not supported on MPP clusters. [:0]

Colour coding of jobs is possible in DS 6.0 in Designer. You can set the colours for links to show you whether they're waiting, running, finished, aborted and a couple of other possibilities. Tools > Options > Graphical Performance Monitor to set colours. Diagram > Show Performance Statistics to sho...

Good point. As one of the original contributors to DSX (and T4DS) and as a resident of Australia (and thus aware of the rather unique laws we have on privacy) I will assure you that my details have not been on-sold by the folks at DCS-Strategies who host these sites. At the same time, it's a great i...

ExecSH (or ExecDOS) as a before-stage or before-job subroutine:
echo ",,,,,," >> #filename#

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518