DSXchange

Is there a way to generate negative surrogate keys in Datastage?

I tried $APT_DISABLE_COMBINATION (set to True) in the job and re-ran . It gave the same error.

The Oracle sequence is working fine in the database.

Hi I am getting this following error when I use the Surrogate Key Generator , Database option using Oracle DB sequence. I used Decimal, Number, Integer, BigInt datatypes, but nothing helped. APT_CombinedOperatorController,0: Sequence <<SequenceName>> returned invalid next value: 1387369372. Please a...

Actually, I was able to use the IF statement. There was a syntax error, which was causing the job to fail . Thanks!

How do I execute stored procedures on conditions in Server Job , ODBC stage? If statements are giving me errors.

Deleting the Aggregator and adding a new one seem to work, but still looking for other options..bcoz I have close to 100 jobs that need to be modified :(

Hi , I am unable to map/drag columns in Aggregator stage from Input to output. This is the error I get. An unexpected error has occured in a call to the Stage Server column object. (ValidateDerivation) I searched online and it says this happens when using dual monitors and goes away when switched to...

Microsoft Visual Studio 2005 Express Edition C++:
Windows 2003 R2 Enterprise SP2

Thanks for your response. Yes I should have included all the information in my original post. Sorry. all settings seemed to be correct from what i see. I must have missed something that is why I am getting an error. Not sure what I missed checking. Here are environment variables: APT_COMPILEOPT = -W...

Yes, chulett, I did search existing posts..they all said to check the compiler...and I have checked it and everything is set up correctly.
Opened a service ticket already, they were not able to figure it out yet, so thought will try it here again.

Hi , I am unable to compile jobs with transformers. below is from the compilation output. Thanks in advance. ##W IIS-DSEE-TOSH-00049 18:12:06(000) <main_program> Parameter specified but not used in flow: DSPXWorkingDir ##E IIS-DSEE-TBLD-00076 18:12:09(000) <main_program> Error when checking composit...

Found it @
\IBM\InformationServer\Clients\Classic

i am unable to find this file...anyone knows the location of this executable?

Can jobs be restored from osh scripts?

Did anyone try restoring a Datastage project from backups in Windows? Can please someone point me to any documentation?
Thanks in advance