DSXchange

I used a turn around solution for this. AS i went through the Oracle enterprise stage in the documentation of Information Server 8.1 , it was talking about loading the data from a dataset while creating the table. So i made 2 jobs where in the first job unloads the data from SQL server and the secon...

I used a turn around solution for this. AS i went through the Oracle enterprise stage in the documentation of Information Server 8.1 , it was talking about loading the data from a dataset while creating the table. So i made 2 jobs where in the first job unloads the data from SQL server and the secon...

well i did for the oracle log file, but it doesnot show the DDL for table creation . oits only giving the insert details.

Do you think i need to check for that else where?

Thanks

Hi All, I am trying to create a oracle table before loading the data. i have to set one of the cloumns as primary keys while doing so. I am using Oracle Enterprise Stage and in the properties tab i have set the create primary column to True. The jobs successfully completes with creating the table an...

Oops my bad...
I'm sorry Craig i dint realise you had given the solution of fixing our dsenv file.

I shall change that one and check if it works and will let you know the outcome..

Sorry about it once again...

Thanks

Well in development server we did the upgrade first and there it is working fine. Well over there we installed the 8.1 without NLS and the dsenv file is exactly same as the one in development and we have not been facing any issues in development waht so ever. Any help on how we could fix the dsenv t...

Sure the dsenv file is as described below #!/bin/sh #################################################################### # # dsenv - DataStage environment file # # Licensed Materials - Property of IBM (c) Copyright IBM Corp. 1997, 2007 All Rights Reserved. # This is unpublished proprietary source co...

It throws the same error...

Hi All, We recently upgraded our datastage from 8.01 to 8.1. Well when we installed 8.01 we did not install NLS , but right now we have installed 8.1 with NLS as well. Guess this could be causing our issue connecting to Oracle. we have diabled NLS in the uvconfig file and also restared the datastage...

Yes PXEngine does point to PXEngine.752.1

the orchadmin commands are working right now .
Thanks everyone for all your help and guidance.

Thanks

i did and looks like the library object it is looking for exists in the different path than specified for $APT_ORCHHOME we have different PXEngine directpries out here like PXEngine PXEngine.751.1 PXEngine.752.1 this library object is present in this directory PXEngine.752.1 now my question is is it...

Hi , I have included the path you discussed into my dsenv file . but still when i execute the orchadmin commands i'm getting the following error orchadmin: error while loading shared libraries: liborchgenerali686.so: cannot open shared object file: No such file or directory could somebody shed some ...

Now as i have in my example have 2 sort stages before the join stages (one for each input link to join stage) my understanding is join stage will not insert any tsort operators. I'm sorry if i'm being really difficult in understanding. If so then having explicit sort stages before the join stage wou...

Sorry if i am reopening the topic even if is it is not posted by me . but since i had a similar doubt and i was going through this post , i'm doing so ... Lets say i do a order by clause in my sql query to sort the columns needed to join and now pass this data through the sort stage where i partitio...

This is what i am getting after setting the $APT_DISABLE_COMBINATION to true main_program: This step has 2 datasets: ds0: {/DataStage/data/DEV/SCD/ISS_INSERTS.ds [pp] eSame->eCollectAny op0[1p] (parallel Data_Set_0)} ds1: {op0[1p] (parallel Data_Set_0) [pp] eSame->eCollectAny op1[1p] (parallel DB2_U...