DSXchange

Can you please also output Len(Fmt(DSLink8.PROCESS_DT, "L####/##/##")) and Quote(Fmt(DSLink8.PROCESS_DT, "L####/##/##")) so we can be sure there are no non-printing characters? Although theoretically unnecessary, try being specific about the format in the Iconv() function. Iconv(Fmt(DSLink8.PROCESS_...

HKEY_LOCAL_MACHINE\Software\Ascential Software\DataStage Client\CurrentVersion\GenCodeRootLoc Good luck getting permission to change the Registry! If they allow that, ask them why the default folder (a specific folder on the C: drive) can not be made writable. You will lose this registry setting whe...

Preserve the control script. Examine it to see whether the correct table (and owner name, if relevant) is being specified. Check that this table does actually exist in the schema to which sqlldr is connected.

Did they suggest when the fix for auto-purge with multiple instance jobs would be made available?

It would be a better learning experience were you to explain why.

It is simply not possible for a rejected row also to be transmitted to the main output because, if it does not match the metadata, it can not be parsed and therefore can not be imported. Please verify - indeed, prove - your assertion, by posting the record schema and one or two sample rows.

You have not provided enough information. What do you mean by "currupted"? Why do you say that this is so? Who is "somebody" and what did they do? What symptoms exist? What error codes are generated? (Please post exact error messages.) Without that information your question falls into the "my car wo...

Your constraint expression is not correct. If the lookup fails, columns from Lkp will return NULL. Using NULL in a comparison is not defined. A better constraint expression would be Not(IsNull(Lkp.Col1)). You don't need to check Col2, and you don't need to check that the returned values are the same...

It is possible, but you need to change some Registry entries. If "they" won't let you write to C: drive I can't see them letting you change the Registry.

ExecSH can not be called via a Routine activity, because ExecSH is a before/after subroutine and Routine activities can only call routines whose type is transform function. Please verify what routine the Routine activity is calling, and post the code for it (you can right click on the Routine activi...

Do you even understand what this routine does? Is there a specification? If you understand what it does you should at least be able to suggest where it needs changing. I accept that you may not have skills in the language DataStage BASIC, but you'd better get some if this is the kind of thing you're...

They are using a routine for generating a ERR_ID.This routine interacts with the data base evokes a sequence and gets the value from it and assigns it to the column. Please find the code below: If IsNull(Db2GetMaxColVal($p_TargetServerNm, $p_TargetUserNm, $p_TargetUserPwd, 'Err_Id', 'Etl_Job_Err_Lo...

The missing command is dsjob, based on your earlier posts.

Also please advise what stage type you are using. The answer may be different depending on which it is. I assume, from your subject line, that it's the Orcle Enterprise stage. But please verify.

Change the job that it runs to constrain the output from the Transformer stage with @INROWNUM = 1. This code is an example of a consultancy company creating copies of the supplied routines of DataStage (and charging you for the privilege). There is much that is inefficient about the code, but I have...