DSXchange

kennyapril wrote:When you give a stage variable as svrejectflag does it reject the records which we described in the stage variable.

No.

But it does give you a good basis on which to construct constraint expressions to handle the rows that are "good" and those which you wish to dispose of differently.

Then the hashed file was not populated correctly. Check your work. Also you should use consistent column naming.

This is an incomplete solution unless you can guarantee that Person_name is not null in every other row. Otherwise you should check all five fields.

I have no direct experience (only done clean installs so far), but the Installation manual for 8.5 says you can. My first upgrade is in January but the repository, services and engine tiers are all on one machine in this case.

It's actually the column derivation for Column%%85 that's the problem. Look in the generated Transformer code (in the 'RT_BP4/JOB.663627415.DT.1567449740.TRANS2' file) to find to which column the Column%%85 token is mapped, then look at that column derivation in the job.

Can you do something with the OCCURS operator (for example value OCCURS < 4)?

DataStage is documented as supporting at most one OCCURS DEPENDING ON clause.

You're correct - I misunderstood your question. Quote is, as far as I am aware, limited to a single character, though this can be any single character. You may need to read your file with Quote=none, then strip the multi-character quotes in a subsequent stage, such as a Transformer. This is a very u...

Make both data types Char. Char(2) and Char(10). Do not use VarChar.

Now re-read the original requirement, which was for "/" delimiters!

Your shared library search path is not being correctly adjusted for the location of the callable Transformer code. Check in the job log for the environment variable that contains your shared library search path (one of LD_LIBRARY_PATH, SHLIB_PATH or LIBPATH).

Can your test machine "see" HT2 machine? Is port #21 open?

Further, the link row count is only the number of rows sent - no information exists in the link row count about how many of these rows were successfully inserted/updated. The only guaranteed method is to compare before and after images of the table.

Consider using Field Delimiter String property.

That's because, with E: as the location of projects, E: becomes your currently logged drive when using a project.