DSXchange

What exact 8.x version / patch level of DataStage are you running?

I'm in the same boat as Craig. Yes, have written it, but no, cannot share. This is because the code was written at a client site while the client was paying for my time; thus the code doesn't belong to me any more. And just in case it wasn't obvious, yes this is exactly the same reason for my answe...

[groan]

So... your target instances were 11g instances?

As noted, you have not given the appropriate "all privileges" to your user, luckily what exactly is needed is fully documented.

Google comes up with all kinds of results when you search for "Insufficient system resources exist to complete the requested service". FYI.

StringToDate() is a PX function so no good in a Server job. For that you'll probably need the IConv/OConv tag team but that can depend on what you mean by "date". What's your target?

Can't help with the C code but still wondering if you can't simply do your check pre-call and pass the result in? And in a way this really isn't a "lookup" in the sense most might think but rather more of a simple existence check with no additional information being 'looked up'. Can't imag...

Why in the world use 'a C program' and reinvent the wheel? Why not simply use a Lookup stage?

Seems like you might not be aware that ETLStats is a pre-built package of jobs / scripts that Kim Duke create and donated to the community via his website. You'll probably need / want to tweak or extend it and you may have issues with 8.x jobs but at least it will give you a huge leg up with your 'u...

Start here:

##E IIS-DSEE-TFEV-00026 16:59:32(010) <transform> Error when checking composite operator: Setting null to this non-nullable field: GWM_ENTITY_TYP_CD.

Look again, if it is truly not there then perhaps it was something added in a later version / patch, in which case I would check with your official support provider.

Yes! :D No can do.

krishna81 wrote:For chulett C is Complex

That I know. What I was asking was: what is the Complexity of your Flat File? What was driving you to using the CFF stage in other words.

And yet the topic has been marked as 'Resolved'. Did you get this worked out?