DSXchange

If you always have all 3 elements, just add a tr command to the sequential stage to filter out all <lf> characters, then define your source file as having no line terminators. If the "<" character doesn't show up in the data I would use that as the column delimiter, declare 4 varchar columns (the fi...

What happens when you remove the '+' sign from the copybook?

Does the '+' mean an explicit character in the data?

Remove both level 05 items

What is the base year for the last format? You could use ICONV() to get the components, but need to know the offset. BadInternalDate = ICONV(In.Column,'D MDY') Month = OCONV(BadInternalDate,'DM') Day = OCONV(BadInternalDate,'DD') Year = OCONV(BadInternalDate,'DY') + E...

Even though the parameters you've changed are rather odd they won't affect this issue. What platform are you on?

There are 3 calls you need to do, each is a function.
1. JobHandle variable from DSAttachJob({YourJobName})
2. Use that handle in the call to DSGetLinkInfo()
3. Close the handle with DSDetachJob()

See what configuration changes you have made, could you post the differences shown by "smat -t" ?

lokesh_chopade wrote:...There is no problem with lookup. ...

Humour me please, set the lookup reference link(s) to "entire" partitioning and see if a multinode configuration works.

I suppose my earlier post got cut off at whatever the 'premium poster' limit of words is, so you didn't see all that I wrote. You can find out how many rows went down a particular link using the DSGetLinkInfo() routine, which you can set up and call from within a user activity stage in a sequence. W...

If your job delivers different results in a 1 node than in any multinode configuration you have made design mistakes. Most likely (as per my previous post) in lookup stages. So, as per my previous post, do you have lookups? If so, is the reference link set to "entire" partitioning or have you ensure...

[sarcasm]Your system clock is set too slow [/sarcasm] On a more serious note - did you use search to find the hundreds of posts regarding timeout issues? If you did and couldn't find anything matching your particular problem, you would get more help if you added explanations and details of your issue.

Change the settings for the actual job, not any of the instances - that should work for you. Remember, setting the project wide defaults only works for new jobs, existing job will retain their previous settings.

I'm not sure what the previous poster meant about data always having to be partitioned. In most cases the default partitioning and default configuration file works just fine and the developer is not forced to think about the partitioning with regards to performance. Only when doing such things as lo...

Yes, you can do it. You cannot use the Job Activity stage to do this, but you can utilize a command stage and issue a dsjob command with the appropriate parameters, including specifying which project the job is in.

But the original poster didn't want to abort the first job, just not execute the second one - otherwise it would have been simple to put a limit of 1 row on the exception link and trigger an immediate failure.