DSXchange

Hi, I had tried based on errors some of the following. I am getting following details when executing in Unix shell prompt. $ liborchdb2opaix3.so exec(): 0509-036 Cannot load program liborchdb2opaix3.so because of the following errors: 0509-151 The program does not have an entry point or the o_snentr...

Hi,
I am able to check in administrator tool that "APT_COMPILER= /usr/vacpp/bin/xlC_r" and APT_LINKER is also set to same.

Can you tell me where the wrong goes.

Thanks
Bhargava

Hi Ray, I am able to view my client tool administrator. I dont have access to server. Here what I found is "LIBPATH=/usr/lib". If I want it to work what else do I need to do? Here I am having my source database is DB2, and my target is sequential file. Can you tell me what are all the sett...

If I am trying which cc and which gcc commands I am getting following information. $ which cc which: 0652-141 There is no cc in /usr/bin /etc /usr/sbin /usr/ucb /home/bhi/bin /usr/bin/X11 /sbin . /home/bhi/sqllib/bin /home/bhi/sqllib/adm /home/bhi/sqllib/misc. $ which gcc which: 0652-141 There is no...

As I tried the commands, I got following results. $ lslpp -l | grep xlc $ find / -name gcc -print 2>/dev/null /usr/local/bin/gcc /usr/local/lib/gcc /usr/local/libexec/gcc Is this the meaning of where my c++ compiler is installed? If so Is this in the correct path or not? What is xlc? Thanks Kavuri

Hi,
what is this xlc compiler? and How it is going to affect DataStage jobs? How to find I am having a xlc compiler?. If it is there, then what should I do to alleviate the problem?

Thanks
Kavuri

Hi, while I am trying to view the data in DB2 UDB enterprise stage, I am getting following error. ##E TOSH 000205 10:40:55(007) <main_program> PATH search failure: ##E TOSH 000000 10:40:55(008) <main_program> Error loading "orchdb2op": Could not load "orchdb2op": 0509-022 Cannot ...

Hi, I am getting following error while compiling in transformer stage. Can anybody give me a hint what is the problem Ascential DataStage(tm) Enterprise Edition 7.5.1A Copyright (c) 2004, 1997-2004 Ascential Software Corporation. All Rights Reserved ##I TUTL 000031 10:22:38(001) <main_program> The o...

we have recreated the .odbc.ini and uvodbc.config files . It solved our problem.

Thanks
Kavuri

1) I need a parameter i.e Is this to represent a table name? If so suppose if I give the paramemter name as "tmp_new_table", then the temporary tables should be something like "tmp_new_table1", "tmp_new_table2"..... That too these tables all are need to be created on th...

Hi, while I am trying to connect to db2 server by using ODBC table definition to load columns in Designer, I am getting the following problem. DSR.MetaGeta(GET.TABLES)(SQLConnect('bhi','bhi')): BCI Error: SQLSTATE=IM997,CODE=0,[DataStage][SQL Client]An illegal configuration option was found Can anyb...

Hi, I am having a job which is running for multiple plans. In this process we need to create temporary tables for each plan. Based on the values on temporary tables we need to update a lookup table. here my problem is 1) How to create temporary tables based on plans, because plans are not fixed. At ...

I am trying to import through ODBC Table Definitions.

Thanks
Kavuri

Hi My server name as host name I had given the same value in IP address field. Let me say my server name is "bhargava" I had given "IpAddress=bhargava". Is there any problem? I am trying to import metadata from both Manager as well as designer. Anywhere I am unable to get it. Tha...

Hi, Even though I am working on EE. My DataStage EE and DB2 are on the same server containing 4 processors. But here I am working with a simple process to import metadata. I am giving the configuration here. Please let me know the problem. [bhi] Driver=/XXXXXXX/XXXXXXXXX/ascential/Ascential/DataStag...