DSXchange

Pavan_Yelugula wrote:...doesn't seems to be working...

Could you narrow down what isn't working? Is it the call giving an error or that the env variable isn't being changed? Add a call to DSLogWarn (I don't recall the API name) to see if the routine is actually being entered.

No, 60K shouldn't cause the transformer to hiccup. You can try to trace the core file with dbx, but that takes a bit of skill and practice. If we approach the error from the other end - what are you doing in your transform stage that is not merely passing through values and could cause problems? Ext...

What about "GetEnvironment('$APT_MIN_TRANSPORT_BLOCK_SIZE')"

What NLS setting is your db2? What NLS is your SQL Server? What NLS specifications did you give in the corresponding stages in DataStage?

I don't understand what your last post means. Since you don't specify LastRunDate as a parameter in your UtilityRunJob call, it isn't passed to any other jobs. I thought that this was your problem?

Since you don't pass LastRunDate as a parameter to the child job, it will use the default value.

Once again, this is a perfect example of a case where you should be using a sequence job.

There are different algorithms to subtract 15 months. I like to use days, so 15 months would be 365 days plus 3 months, 3/12 of 365 is 91 days so I would subtract 465 days. Assuming the current date is in internal format, that would be "@DATE-465". It gets a bit more complicatedif you wish...

Which stage is generating the error? If a transform, what is your OCONV function? [edited] - I just saw the "BCIPUT", which tells me which stage. What data types do you have - the error means that the contents of a field did not convert to the target data type. Since the fields will be sto...

Use the Job type expressly designed to do this. The Job Sequence.

Ram, please, please don't use all UPPERCASE in your post, it makes it very difficult to read and understand and nowadays it also means you are SHOUTING. According to the docs, the APT_ORACLE_NO_OPS is for AIX systems which don't have the Oracle Parallel Server installed. Is this the case for you? If...

How does "DEV" relate to "D:/IBM_DQS_Config/Dataset/"?

My guess was that the wrong sequence is being called, which is why I suggested creating a copy and running that. I agree with Craig, I don't see how a normal run call to DSExecute could generate a validation run.

Mea Culpa, my fault in assuming that this was PX problem. I've never used TX so cannot help, sorry.

"-bash: orchadmin command not found" This is standard and basic UNIX error message, it means that you either specifed a complete path to the "orchadmin" executable but that it is incorrect, or that you specified no path and do not have your PATH environment variable set correctl...

You sem to have run out of disk space in your Dataset directory at runtime. Increase the space or use an additional mount point with space for your datasets.