DSXchange

Then perhaps Right('000000000000':Trim(In.AD-ACCT-ID),12) would work.

In other words, anything like a 'parameter within a parameter' is not supported.

clarcombe wrote:It is very strange. I have done the following
rownumber : no xpath
fields : /code, /libelle etc

Ummm... yah, sorry, was thinking of a different problem when I posted that - that was some bum advice.

[waves hands mysteriously] These aren't the droids you're looking for.

Of course it would be best to wait and not even start the second job until the first has finished, but that's not what the poster is asking how to do.

Hmmm... we did this using Perl writting to standard out.

StringToDate(<FieldName>,"%YYYY-%MM-%DD") says what your source data looks like, not the target. And that's 10 characters, hence the error using that with your 8 character source.

Of course there could be 'resource allocation problem' in the future, it's not like your server has infinite processing power and resources. As Arnd notes, pay more attention to exactly what you're asking the server to do.

b) His post. Like a bump. :roll: a) Looks to me that, without the file assignment, it created a directory with that name in the Engine directory which I find both interesting and... dangerous. That should be pointed elsewhere using the syntax as noted, somewhere where there's plenty of scratch space...

8 dot what? Zero or one? And what exactly does 'unable to see' mean - no jobs show there or the logs are always empty? You get errors? Something else entirely?

ps. Repeating your subject for the 'Additional info' doesn't really help.

From what I've seen, you can do anything there with an 'external' source that writes to standard out. As noted though, stick with the database stages to read tables, multiple or not.

So... something mysteriously wrong with 'the tns name' caused the job to not compile? I find that hard to believe but as long as it is resolved for you...

That should be fine parameterizing the port address but as noted that doesn't seem to be your problem.

Your support provider?

mikesherm wrote:The client I'm working at has only purchased QualityStage. It appears that the Rowgenerator Stage is a Datastage specific stage.

In that case, you should probably post in the QualityStage forum, that would probably help keep your answers confined to the proper product.

Sorry, but what is "the red box"? What exactly are you trying to parameterize?