DSXchange

That would do it.

You can try to use "MCP" conversion, but there is a risk that you'll lose uniqueness. Better would be to find out what the non-printing characters are, and convert these to explicit printable characters. Something like Convert(Char(254):Char(253):Char(252):Char(251...

It's always better to know the cause of warnings and to eliminate them where possible. Sometimes time pressure to get a result means that you take a short cut, such as implementing a message handler. Don't forget to promote the message handler into test and production environments if it is your choi...

smitageorge wrote:I dont have any duplicates in the lookup stream,but there are duplicates in the source.

Oh, yes you do! Further, it's on the first processing node (number 0) in your configuration file. Otherwise DataStage would not have reported "lkp_group,0: Ignoring duplicate entry at table record 3"

Use stage variables to identify the group and the first value of CA in each group, and set a flag if a different CA value is found in the same group. Keep a list of groups and flags, then post-process the data so that groups can be kept or rejected.

Could be worth disabling combination to be certain, but I feel that your "failed lookup" rule is Fail.
If the data type is string, make sure that there is no extraneous white space in the lookup data (key) or in the stream data (lookup value).

If you used Entire when loading Lookup File Sets, then you must specify Entire when using them. Or (Auto). Or get the warning.

Simply have another link from the Transformer stage to a Hashed File stage. With this you can write whatever rows you like into the hashed file (not "hash" file) subject to a constraint expression on this link.

Welcome aboard. And now a reprimand. Do not hijack threads. Start a new topic (see the "New Topic" button?). Your question is unrelated to the topic of this thread. Hijacked threads affect the efficacy of the Search mechanism. A second reprimand. Your question has been answered in the past. Try Sear...

Not really out of the box. The SDK routine is very specific about format. The function, however, is very easy, provided you specify the format in a manner expected by Iconv() - that is, "DDMY", "DMDY" or "DYMD". FUNCTION IsValidDate(TheDate, Format) If UnAssigned(Format) Or IsNull...

Talk to IBM about the Information Integrator product.

You MUST use separate Hashed File stages, one for the lookup, one for the update. This is because a passive stage can not open its output until all its inputs are closed. Do NOT use read cache or write cache. Do use "lock for update" when performing lookups; this will set a record level lock that wi...

The easiest way to determine whether there are any, but not what they are, is to apply Oconv(TheString, "MCP"), which converts any non-printing characters to period ("."). Perhaps capture this into a sequential file while you are investigating.

Does the executing user have UPDATE privilege on the table in question? Is any Informix error code reported (perhaps as DBMSCODE)?

We need to see your code for GetParameter (which is not one of the built-in functions). It is in this routine that the actual error is occurring. In GetParameter you need DSAttachJob() as Arnd mentioned and also DSDetachJob() so as to avoid job locked errors. Further, DSExecute() takes four argument...