DSXchange

Or simply use the Stored Procedure stage.

Instead of the size, if anyone suggests about scenario where no. of rows in the file increases abruptly over some specified number, that could be also helpful. Check out the DSGetLinkInfo function for a way a routine can check the number of records down a link from another job, say from one that do...

There's more to an MI job than just checking that box. How about explaining what kind of job this is? Where are you using the DSJobInvocationId macro and why?

Sounds like more of the same problem you posted earlier. Did you ask about getting your ulimit raised?

Read the documentation for the Field() function, you can use it to get the 2nd field from your semi-colon delimited string.

Then, as noted, you need to determine what's different in the production environment. Something obviously is.

You get this where? Is this a Sequence job or your own job control or ...? Also note there's no reason to "set" a parameter using an environment variable, it will inherit it automatically. That's the whole point, after all.

i have also looked in the RT_BP2927 file of the job. nothing there on line 122. Just an FYI, that's not where it noted that line 122 was a problem: Program "DSP.Open": Line 122, Exception raised in GCI subroutine Since we don't have access to the source for DSP.Open you need to look for o...

chulett am using in my home i have installed in my own tell how should i correct all the mistakes hey u said u know how to coreect the error can u pls say me clearly how to slove the problem am using dadstage ee in my home am using xp os server job is running perfect in parallel job when am using t...

Don't put quotes around the commands.

Who installed DataStage for you? Talk to them about the compiler. I assume this happens to anyone / any job with a transformer stage, yes?

First suggestion - try searching the forums for the actual phrase "occurs depending on" as you're not the first person to ask questions of this nature.

OK... basic stuff here... do you have a supported C++ compiler installed and configured properly on the DataStage server?

What did you find when you searched for "No DataStage credentials were found" in the forums here?

What are your data types in the job? Unsupported types are listed in the OCI pdf documentation, btw.