DSXchange

Pass them HOW? For example are they contained in sharp signs (#)? ... The parameters are contained as "$#" (Environmental Variable). I am going to Job Properties and added the Environmental variable by clicking "Add Environmental Variable". Then I go to Oracle Connector stage an...

Ray, I just noticed one strange issue, If I create the parameters at Job level and then if I pass them to Oracle connector stage, it is working. But if i define the parameters at Project level and then pass the environmental variables to Oracle Connector stage, then i am getting the error. Thanks Ma...

Hello Ray, The operating system is 64 bit and the error is Error Oracle_Connector_0: The connector could not establish connection to Oracle server UATDWTGT. Method: OCISessionBegin:OCI_CRED_RDBMS, Error code: 1017, Error message ORA-01017: invalid username/password; logon denied. (CC_OraConnection::...

Hey Priyadarshil, I am about to post my comment. I did the same, i passed the values instead of parameters and it is working fine. How to overcome this issue? I can not use the hard coded values. I have to use the parameters. If you have information or solution, kindly pass it to me. I really apprec...

Hello All, I recently installed the Datstage 8.5 Server on UNIX platform (Sun Solaris Operating system). When i try to run the job with Oracle Connector stage, i am getting the below error. Even when i try to view the data i am getting this error. Error Oracle_Connector_0: The connector could not es...

All, I want to unlock all the datastage processes running in my box. So i started with the command $DSHOME/bin/dssh but i got the below error when i am using $DSHOME/bin/dssh. Error: ------- ld.so.1: uvsh: fatal: libdsplugin.so: open failed: No such file or directory Killed What does it mean, Could ...

Thanks i got the solution

Hello All, I have gone through couple of posts of dscmdexport and i got how to use it. I can take export of my projects from command line using dscmdexport by using the following syntax. C:\Progra~1\Ascential\DataStage7.5.1\dscmdexport.exe /H=Host /U=Uid /P=Passed Project1 F:\DSX\backup.dsx Now, i w...

Hi,

I have a scenario where i need to find the all jobs which are using a particular oracle table either as source or target.

Eg: I have a table called EMP, now i would like to know all the jobs which are using EMP table. Is there any way to find out?

Thanks in advance
Madhu

Nor should it. INSERT INTO table(col1,col2) VALUES (123, "XYZ "); will preserve the trailing spaces, because they are part of the data . DataStage b ... Ray, I am hardcoding it as "not validate" in the transformer.!! when i load using upsert method, then it is loading as not val...

Hi, I have a varchar field of length 2000 and i am hardcoding the value as 'not valid' in the transformer. Now, when i am loading to the table using Loading method as "LOAD", it is behaving as char i.e it is taking the length as 2000, but when i am loading using UPSERT menthod, its going f...

Hi, I have job like CFF ==> Transformer ==> Oracle Enterprise Stage One Source column is coming as CHAR 2 with two spaces as value and i am loding the same to oracle using load option. The oracle is trimming the spaces and loading as null value.. then i added a environmental variable APT_ORACLE_PRES...

Thanks a ton guys..!!

Hi All, I have to get the list of job names from a particular category and put them into a sequential file. I have written a routine $ INCLUDE DSINCLUDE JOBCONTROL.H *---- Start Processing *---- Fectch Job Parameters sleep 20 var1 = 'TARGET_RI_FILES\CLAIMS\INST_CLAIM' strFileName = '/tmp' : "/&...

I have two jobs. I am running the first job in four nodes and loading the intermediate results to dataset. Now i am using this dataset in my second job for loading the data to DB2. As per performance consideration, my team lead asked to run the job in 2 nodes, but the dataset which i am using has ru...