DSXchange

No. And yes. Because, in version 8, QualityStage and DataStage are the same piece (ignoring licensing) you can use a DataStage Transformer stage to apply IsValid() functions or other techniques to e ... There is a rule set Vdate to validate date..so I was wondering if we can validate date field usi...

Hello All,
Is it possible to perform datatype validations in quality stage like date and int field validations?

Thanks,

Ho All, I am trying to implement SCD type 1 and 2 using SCD stage.I have input sequential file,dimensional tab;e as seq file and inserts and updates for dimension table and fact table are captured in sequential file.For dimensional update file,only inserts are captured without updates.What must be t...

Thanks very much for your help.I uninstalled datastage,MSVC and installed again.Now the problem is solved.

ArndW wrote:The "cxx" script and compiler has nothing to do with DataStage; so you need to fix that first. Perhaps a compiler reinstall? Or MS Support? Or just look at the script and see where it references a cxx ...

I installed the mks tool kit again but even then i get the same error message...

ArndW wrote:And have you fixed your path to correct the problem? ...

I fixed the path to C:\Program Files\MKS Toolkit\etc but even then I get the same error message.I checked for the file cxx.xxg in this folder,it is missing.

Also, manually enter the command cxx -O -IC:/Ascential/DataStage/PXEngine/include -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c C:/Ascential/DataStage/Projects/ram/RT_BP1.O/V0S6_test_tx_Trans ...[/quote] I executed the command cxx -O -IC:/Ascential/DataStage/PXEngine/include -W/TP -W/EHa -DAPT_USE_ANSI_...

What values do the following environment variables in the project have? APT_COMPILER APT_COMPILE_OPTIONS APT_LINKER APT_LINKER_OPTIONS ... Hi Ray, The values for compiler environment variables are as below APT_COMPILER=cxx APT_COMPILEOPT=-W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c APT_LINKER=cxx APT_L...

I tried to compile parallel job which has row gen-->transformer-->peek and iam getting the following error msg Output from transformer compilation follows: ##I TFCN 000001 22:36:11(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5 Copyright (c) 2004, 1997-2004 Ascential Software Cor...

Hi, when Iam writing to a decimal field space is inserted before actual value.Can you please help me with this.

Thank you very much guys for your help.Its working fine now.I exported all the environmental variables and that solved the problem...

I tried even ./orchadmin.It doesnt work:(

I tried to delete the .ds file by going to the path ~/IBM/InformationServer/PXEngine/bin which has the orchadmin file.I tried to execute the orchadmin command from here to delete the file orchadmin delete filename.ds but I am geting the error orchadmin not found.But when I do the ls command i can se...

I wrote a shell script to delete dataset. a=`cat Rejects.txt|wc -l`; if [ $a -ne 0] then `rm Result.txt'; exit 1; fi; When i execute this script from command line it works fine but not from the after job sub routine.After job subroutine ran without error but the file is not deleted.I am using execut...

If you want to delete it programatically use this command in a command stage in sequence / after job subroutine.
where $DSHOME is the home directory of your DataStage installation.[/quote]

Thanks for your reply.How can i find the DSHOME directory?