DSXchange

You need to check the valid cvobminations of options with Oracle. I don't have the documentation at the moment but I think if this is causing and error you need to "disable constraints" option turned on in the Oracle stage when you have Parallel = True in the load options.

Incase anyone else is having this problem I don't think there is a perfecty fix as the cause of the error is a tar command in the PX install script. (cd /tmp/dsinstall/unpack/parallel_extender; /bin/gzip -c -d linux.tgz) | (cd /dstage/Ascential/DataStage/DSEngine/PXEngine.752.11; /bin/tar xfo -) Alt...

I'm having the same problem installing on Linux and am pretty sure it is because _POSIX_CHOWN_RESTRICTED is set by default. Unfortuantely I don't know how to change this value and although I have spent a few hours seaching for the exact sytax I can't find it. I find suggestions but mostly they don't...

I think you might have mistaken the inverted quote for a single quote.

'install.sh' - not correct
`install.sh` - correct

Before I waste my time can anyone confirm that DS EE 7.5.2 will work with MS Visual C++ Express 2005 and the SDK Toolkit? From all the posts I have seen on DSXchange everyone says to use MS C++ 2003 but I can't find a download for that anymore. I have tried with 2005 already and it has not worked bu...

Thanks.

p.s. what's RMM?

Given a job name is it possible and if so what is the BASIC code to find out what the "type" of job it is from within a routine.

i.e. is it a Server Job, an Enterprise Job or a Sequence Job.

Thanks, Nick.

If the tables are not in the same database load them both into temp staging tables in the same database and perform join in there.

You have to sign up to view the premium content - follow the link through the icon that blocks the content

you need to have error handling in your script so that it return non-zero return code - then datastage will understand this as an aborted script and stop before running the job.

i.e.

EXIT 1

create a routine with the following code with one input arg called "aSearchString" Then you can open the routine in designer or manager and use the "TEST" functionality to find what you are looking for. COL_HEADING = @FM COL_HEADING := "JOB ID JOB CATEGORY JOB NAME" : @...

Are the two tables in the same database? If so join in the database first. If they are not it is more difficult. Are those the only two key fields or are there more key fields that you could join on but which would return multiple records for the same keys? If so you could join on the other keys pas...

Is the physical implementation of the oracle stage/virtual dataset and the lookup stage very different from the lookup fileset and the lookup stage?

For the above I mean in terms of what happens when the job runs not how one implements this in the job.

i guess i was talking about the virtual dataset. Forgetting the overhead in creating this virtual dataset or the overhead creating the lookup fileset, once you had them is there a large performance differnece between performing lookups on the virtual dataset rather than the lookup fileset? 1) With s...

When I have a lookup stage with reference link direct to Oracle stage what exactly happens in the background? Does this simply create a temporay lookup fileset which is then loaded into memory in "entire" mode on all nodes? or Does it create partitioned lookup filesets? Or does it not real...