DSXchange

Yes, you're calling a server function from a parallel Transformer stage. This is not permitted. Yes, you're calculating something every row that doesn't need to be calculated, because it's already in a system variable. Yes, if you must calculate something yourself, you could simply initialize a stag...

Makes sense. As far as I am aware, the C.539 in the error message relates to column #539.

Does the file perhaps have a field delimiter character in the data at or near line number 1,918,715 ?

You are trying to be too clever. Create separate indexes on Eff_Start_Dt and Eff_End_Dt. You can test your queries (as to whether they will use indexes) using the EXPLAIN keyword, for example in the Adminsitrator client Command window. SELECT COUNT(*) FROM table WHERE CURRENT_DATE BETWEEN Ef...

For a few cents per day you CAN view premium content. It's how this site partially funds its bandwidth charges. You can declare a dimensioned array using a DIMENSION statement. You then, of course, need to keep track of which element is being used for each job, so perhaps an array with two dimensio...

It shouldn't be that hard. It's made that hard by the database vendors' insistence on different formats for Timestamp. What's wrong with following the ISO 8601 standard, I wonder? At least why can't they all recognize this one standard, in addition to their own idiosyncrasies? However, as DSguruji s...

Provided that you can source an ODBC driver for SQLite that runs on UNIX it's definitely possible.

You could get this with much less effort by interrogating the @OUTROWNUM system variable for link DSLink10.

Is it possible that you have tried to select the 16th column from a table that only has 15 columns defined?

The Sort stage is far easier. It generates the "key is changed" value for you. All you have to do is to provide a column into which it can put this value. Any size of integer will do; the value is 0 or 1.

The Itanium versions of DataStage are 64-bit capable. You don't need to make any changes.

7.5 is more diligent about reporting these conditions.

You could perhaps introduce the sort ahead of the BuildOp, or use an explicit Sort stage after it. The explicit Sort stage might even specify "Don't sort (previously sorted)" if applicable.

While being aware of the Drop... properties that Uma suggests, which all default to False, why don't you experiment? There is a match for Key column where value is one of 5,6,7,8. The Compare stage is not positional - it requires the Key column to match and then performs a comparison on all change c...

Use a job parameter to contain the entire IN list. Your query then looks like: SELECT POLICY ,DEC (SUM (TBASICPRM), 12,2) FROM CMIDBO.PREMTRAN WHERE COMPANY = 1 AND PRODUCT IN ('COM' , 'FRM') AND POLICY IN (#PoliciesList#) GROUP BY POLICY WITH UR ; Populate the IN lis...

Using the Administrator client, any user can determine the location of a project. This is reported in the status bar when a project is selected. On the server, location of a project is recorded in the hashed file UV.ACCOUNT and in the system table UV_SCHEMA. You can access both of these from the Dat...

Are there commas in the data (in quoted character strings) or only as field delimiters?