DSXchange

Thank you all..

Issue got resolved, data is not accepting into table.

Hi Friends, In DataStage 8.5 server jobs, 1> when stage variable condition is falling, rows are getting dropped insteand of going to reject link (which is connect to DRS stage, database sql server). if i remove DRS stage and place sequential file, then rows are going to reject link. Thanks in advanc...

HI, We are upgrading from DataStage7.5.2 to 8.5 on windows server. I have exported job from DataStage manager tool by enabling a> job design and b> job executables. which was exported successfully. Now the problem is while importing to Datastage8.5 we are facing below issue: !!!!Error while deleting...

Hi Arvind, I have checked log files created during installation : please find below error along with query. ````````````````````````````````````````````` Caused by: java.sql.SQLException: [IBM][SQLServer JDBC Driver][SQLServer]Invalid column name 'ABBREVIATION_XMETA'. ```````````````````````````````...

Hi Aravind,

xmeta is having sysadmin server roles, additionally dbcreator also.

Could you suggest us , can we go ahead by skipping this issue.

Thanks in advance.

Hi Friends, We are installing DataStage8.5 on Window2008 SQLservers as database. Please find below issue occuring after giving XMETA details. Issue: -------- com.ibm.is.install.exception.InstallException: CDIIN3231E: Error Executing SQL statement CREATE TRIGGER ASCLHist_Term_U ON ASCLModel_xmetagen_...

HI Ray,


this cmd is available on my client system.. InformationServer/Clients/Classic>

if i want to import dsx file from server machine(linux box) can you plz specify exact cmd and location where to execute it..

Thanks you in advance..

Hi, i have tried dscmdimport in Informationserver/Server/Projects/projectfolder ../../DSEngine/bin/dssh dscmdimport /D=serverIP:9080 /U=username /P=password /NUA dstage filename.dsx received below error msg: verb dscmdimport is not in your VOC folder. Can i add dscmdimport in VOC file by following b...

HI , I have logged as dsadm user.. Then went to /opt/IBM/Informationserver/ASBNode/bin folder and executed the DSXImportService cmd. executable's parent directory= means /opt/IBM/Informationserver/ASBNode/bin need to add in PATH variable? i have tried dscmdimport.exe in Informationserver/Server/Proj...

Hey we don't have Datastage admin .. we are only taking care of it.. so please let me know ...

In the mean time.. VOC file is having rwxrwxr-x permission .. so ihave changed it to 777... let me try again and will let you know..,

Any suggestion we will be greatly helpfull...

Yes folder has one hidden file..

Foder permission are: rwxrwxr-x

Yes User has 777 permissions...

1> our server is located at onsite and clients are installed on our Desktops.. so we are using VPN to establish connection..., We are trying to get one remote desktop .. it's in process...,

2> Yes , i am unchecking Perform Impact analysis box while doing import..

I ran with isadmin & wasadmin users... but received error msg for both users.

from Admin client.. Permission.. tab.
-----------------------------------------

isadmin ---- Datastage & QualityStage Administrator.
wasadmin---- Datastage & QualityStage Administartor.

it has 2 files Data.30 & OVER.30 files with rw-rw-r-- permissions..