DSXchange

Thanks for the quick answer Mike. I tryed this solution, but the user is allways the same user (dsadmin) and on the Information Server Console we are getting the rigth user names.

Do you know another option?

Thanks.

Hi,

I'm wondering if you can let me know a way (if exists) to see the users names that are working on DataStage without use the Information Server Administrator tool and without admin rights.

Thanks in advance!!

Hi,

Sainath: Yes we have enabled NLS and set the same encoding we have in the oracle database UTF-8

Chulett: On the table definition we have Datatype = Char and Lenght = 39

Thanks for your answers.

Hi all, we are importing a table definition from an Oracle DB using the Oracle enterprise stage of Datastage 8.1 The weird thing is that in oracle the column if VARCHAR2(13) and in Datastage the column has the size multiplied by 3 = 39. In Datastage the column is CHAR(39). The same is happening with...

Hi all, We are trying to do a direct load from a DataSet to Oracle. When we have record on the DataSet the job finish ok, but we are facing below error when the DataSet generated from previous job doesn't have any record. SQL*Loader-500: Unable to open file (\.\pipe\ora.64020.600000.fifo.0)SQL*Loade...

We are using Oracle Enterprise Stage and have this error: "Oracle: Access to sys.dba_data_files is required but is not available; please see your database administrator for select privileges. " However, when we Load with ODBC Enterprise with same user, the load is correct. So we are wonder...

Thanks for the reply ray.

Is Xlc the only c compiler that can be used with AIX? Do you know if there is another freeware c compiler that we can use with AIX for DataStage?

Hi experts, We installed IS8 using the XLC evaluation license and everything was ok. After 60 days we got the license error when we tried to compile parallel jobs. We have uninstalled XLC compiler and installed gcc/g++ version 4.2.3 and changed the next values: APT_COMPILER: /usr/bin/g++ APT_LINKER:...

Hi, I have built a paralell routine with the following c code: #include "stdio.h" #include "stdlib.h" } char * NextRunKey(char * inString) { char buffer[20]; FILE *Test; char * key = buffer; int aux; if((Test = fopen(inString,"r")) == NULL){ return "File not Exists...

Hi Chulett!!!

DataStage Patches.

Thanks.

Hi,

it's possible to know the patches installed on the DataStage server? Where is this information available?

Thanks in advance.

Hi All, We have different Datastage environments. We have an error that is only happening in one environment (production). We think it may be due to a corrupted job. Based on this, we have tried to recompile the job, and it did not work. We have tried also to import the job from the previous stage (...

You need to export this stage to you palette. When you click right mouse button on your processing tab of your pattete, you would get a new pop out menu out of which you shoud select the 'Customization' option. then a new window would be opened and from the left hand side, you have to select the bas...

I deleted the job from my project and I imported from another project and still not working,when I run the job get in a loop and not finish, then I have to kill the process. My job has one basic transformer and another transformer, it is a paralel job.

I've tried this option and doesn't work. Do you have any other solution?
Thanks