DSXchange

When a job is re-compiled and no changes have been made to a Transformer stage that has previously been compiled successfully, the Transformer stage is not re-compiled. This may be what you are seeing. There is a Force Compile option in the menu if you want to force re-compilation of the Transformer...

The first character in the first line is Ctrl-T. (This shows as 20 in the raw string.) Is there any reason this should be there? It's interfering with the import operator generating a numeric data type.

You need to find out, obviously, how it was converted to Cyrillic characters in the first place (nothing unexpected should happen in ETL). The short answer is that there are character maps between the outside world and DataStage, that convert from and to the external character set. There is no mecha...

Structure of the various types of records is partially documented for programmers in header files such as DSD_RTSTATUS.H and DSD_CONST.H. You can learn by inspecting these. Other than that, the only way to discover the various structures is by inspection using UniVerse-style non-SQL commands such as...

Welcome aboard. Your explanation is too simplistic nor differentiates between Merge and Join.

Please use correct English spelling, so as to minimize hardship of those whose first language is not English.

1) Individually per field. RI checks using a lookup against (an image of) the target parent table.

2) Not null. Possibly replacing null with default value ("in-band null").

Then life becomes a little simpler. Fragment your date into year, month and day and adjust each portion before re-assembling your date. Add 1 to year if month >= 7. Add 6 to month if month <= 6 or subtract 6 from month otherwise. Based on the new month calculate the final day of that month. A Field(...

1. No. There isn't. This is and always has been deliberate policy by the vendor. Further, it's not all done with DataStage BASIC language. Any aspect needing direct memory management is written in C, as are some of the routines for other tasks such as accessing sequential files using the STREAMS I/O...

Surely 06/30/yy + 6 months is 12/30/yy ? Or do you require this only for the last day of the month?

Welcome aboard. One of the options in the Sort stage is to perform a "unique" sort, which removes duplicates. But that only gives you the unique values - the Sort stage can not, by itself, send the duplicates to a separate output. There are several techniques - the one explained in the previous post...

Please delete your duplicate post on this topic. There are three possible stage types, comparable in terms of efficiency but subtly different in their method of operation. Sounds like you are interested in keeping both source records; that will affect your choice between Change Capture, Difference ...

What exact version of DataStage? I can not reproduce on 7.5.2 on a Windows platform. Does reinstating the quote character magically reinstate the link definition?

Are you trying to use BCI functions anywhere in the job? If so you will need to purchase a license, as indicated. If not, harangue your support provider; the drivers that ship with DataStage are licensed for use with DataStage stages, which includes DRS.

$PROJDEF is not substituted in View Data, but is substituted when the job runs. I have just proven that - I received the same message that you posted when using View Data but, when I ran the job, the message was Message: EnvVarParamTest..TGT_BIOS_C069_OUTNA_HEADER_PART_OWNDELTFILE.TGT_BIOSFILE_DATA:...

Please verify that the name of your job is BIOS_OUTNA_OWNDELT_FILE_GENERATION, the name of your Sequential File stage is TGT_BIOS_C069_OUTNA_HEADER_PART_OWNDELTFILE, and the name of the input link is TGT_BIOSFILE_DATA (just so we can be sure we're all talking about the same component). Can you also ...