DSXchange

Not sure this matters but transfer which direction - get or put? Hmmm... even if it does work, probably not going to work as you would like, on whichever side is the target you'll put everything in one file. AFAIK, there is no direct equivalent to the mput or mget of regular ftp in the stage. To emu...

XP is not a supported operating system for the server components.

kollurianu wrote:Error:Missing reject link. Value of property 'Reject Mode' for 'Complex_Flat_File_21' requires an output reject link from the stage'.

Did you have one? An actual reject link from the stage? The error indicates that answer is 'no'...

Need more details. Are you getting multiple lines that will always come in fours and you always want lines two and three from each group of four or is there more to it than that? I suspect your example is too simplistic and want to double-check before giving you a matching too simplistic answer.

sanjumsm wrote:I wanted to use APT_ISVALID_75COMPAT parameter but unfortunately i can't see that in environment parameter list.

If you've applied the 'fix' that added that option and you still don't see it in the list, I would simply add it manually - type it in by hand. See if it helps.

When Server jobs blow up, the "active" stage always reports the error... meaning that would typically be the transformer.

You might also google for "Operation must use an updateable query", it looks like there are plenty of discussions of this error out there.

Yup, it really depends on what you need to do with this batch number other than simply increment it.

ray.wurlod wrote:I guess the health care industry might work more with masked data and generated test data than many other industries, at least in development environments.

True, but I would imagine the Banking industry has similar privacy concerns...

austin_316 wrote:This can be done using before job sub routine. You can fetch the value and pass it as a paramter to the job.

No, it can't.

You just type it in.

You can't do things like "SELECT" before sql, where would the results go? You need to do "before things" like alter the session or truncate a table, to name a couple of options off the top of my head. Forget the before SQL error and tell us what you are trying to accomplish inste...

True, between HIPAA, PHI & PII there's plenty of privacy issues to be aware of in the Healthcare industry. The people you work for will make sure you understand what those are. But bottom line, that doesn't mean there are any real "technical" differences or magical methodologies that y...

Already done did that.

chulett wrote:You can view it in UNIX, you'd just need to enclose the filename (spaces and all) in single quotes to do so.

Missing a wee bit of information. Start by telling us what exact platform your server is running on - you've marked it as Windows but it looks like UNIX, so which UNIX flavor? And is it 32 or 64 bit? What compiler did you install? What compiler/linker settings are you using? I'd also be curious if y...