DSXchange

But what happens when you process the 101st Type B ?

I'd recommend separate DataStage jobs for each step. The results of Step 1 are stored in a file (text file, hashed file, doesn't really matter) which becomes the input for Step 4 and Step 5. You didn't specify what Step 2 and Step 3 do, it may be needed there too. Wrap a job sequence around the lot,...

Of course there is, and you do it the same way you'd do it with SQL. Insert the first batch of rows, with suitable default values for those columns to be loaded in the second pass. In the second pass, update the rows with appropriate column values, but only for the columns you need to update. In thi...

Not sure what you mean by "link". In DataStage, there is no awareness of relationships between tables, though this information is captured when you import a table definition. Effectively you have two choices. You can update both tables in the one job, putting the same value into column A in each tab...

If you don't have the Parallel Extender software installed, the answer is a definite NO. If you do have the Parallel Extender software installed, the answer is still, as far as I am aware, NO. What you could do, on the other hand, is to effect parallelism in your server job by using parallel streams...

Take a look at how these stages are set up. Updates and inserts are handled on the Inputs tab of the stage. This means that they would occur first. Selects occur on the Outputs tab. This means that, if the stage has inputs and outputs, the Select operation occurs last. I read between the lines in yo...

You're right, not simple. Where are you going to keep your flags? Does the on/off setting affect the location of a field in the text file record? I'd probably consider a routine, with two arguments, one of them being a dynamic array of your column data values and the other being a 163-character stri...

I've just tried exactly the same thing, but did not get the error. DS 7.1, Informix CLI stage connecting to Informix 9.31. View Data was totally successful. It seems odd that you can view the tables - and, presumably, import them - but not view the data. Can you try the import data again, but this t...

You haven't provided nearly enough information to allow accurate diagnosis. For example: What stage type are you using? If DRS, what access protocol (DB Type setting) are you using? Can you view the table from the DataStage server machine using any different software? Are all the settings (parameter...

If the file already exists at the destination, MOVE will be trying to prompt for an "OK to overwrite" response (which you can't provide). Get around this by specifying the /Y switch. Otherwise, if the file is still open for reading or for writing by another process, MOVE will not succeed. In this ca...

Welcome aboard! :D I'm not sure what you're asking here. The Aggregator stage tries as much as possible to do all its work in memory, so the concept of a folder doesn't really come into the discussion. Are you asking about tuning the amount of memory used by the Aggregator stage? If so, can you plea...

You've made the statement of the problem too complex. What you need are separate sequences. You can initialize them how you will. You can create your sequences in stage variables, or use a routine such as KeyMgtGetNextValueConcurrent from the SDK, using a separate sequence name for each ITEM_TYPE. I...

I also have no great preference. In my projects I generally arrange for the hashed files to be in a directory (or sometimes more than one, functionally grouped). This means that the project directory itself doesn't grow out of control! However, I also arrange for VOC pointers to exist so that UniVer...

Welcome aboard! :D "DDMY" will be sufficient with Iconv(). See Date Conversion Demystified to learn why this is. Therefore your expression can be @DATE > Iconv(Ln_Histor_Data_In.FICHE_DEBUT_VALIDITE_CH, "DDMY") And @DATE < Iconv(Ln_Histor_Data_In.FICHE_FIN_VALIDITE_CH, "DD...

Informix ODBC drivers are notoriously finicky about matching versions. Check with your support provider, or with IBM (who now own Informix IDS), about whether you're using a correct version of the ODBC driver for your version of the database.