DSXchange

Hi All, I am loading tha data into dataset with more than 250 columns. I got the error like Requseted size is "23.........".But actual size is "13.....". Does is there any limitaion for dataset interms of using number of coumns? Does we need to use any environmental variable to a...

May be it is due to configaration file and partition technique you are using for creating dataset.
make sure same config file and partion technique should be there while making dataset and reading datset as well.

Hi ,

It seems DSN Issue.
DSN name which you are using should be registered in service control file along with IP address of your server.

Regards,
Sankar.

Hi All,


Do you have any idea how to read indexed files using datastage.
Indexed files are generated from "Mainframe".
Please let me know.

Regards,
Sankar.

Hi All,

Can you please suggest me how to read indexed files using datastage.


Regards,
Sankar.

Hi , Teradata enterprise stage is like fast load in teradata. For fast load in teradata, Target table must be empty and constraints free and it won't allow any index other than primary index. in fast laod we can do insert only. Where as in mload , we can load data even though it has data in target t...

Hi , There is XML Input and Out put stages are there in "REALTIME" Tab. Using those stages we can retrive data from XML Sources. these links may help ful to you. http://download.boulder.ibm.com/ibmdl/pub/software/dw/dm/db2/bestpractices/DB2BP_XML_0508I.pdf http://www.ibm.com/developerworks...

Hi dsex,


Can you please send the link to down load Visual Studio 2003 C++ compiler.
I tried from Microsoft site .But it is not available .


Thanks in advance.

Hi Ray, I have tried with re-installation of MKSTOOLKIT. and i have changed the path of INCLUDE and LIB Environment variable to 1) C:\Program Files\Microsoft.NET\SDK\v1.1\include\ C:\Program Files\Microsoft.NET\SDK\v1.1\Lib\ 2) C:\Program Files\Microsoft Visual Studio .NET 2003\Vc7\include\ C:\Progr...

Hi Arndw, Your Assumption is right. I ran the "CXX" command from command prompt. It is showing following output. NuTCRACKER not properly installed. The pathname: C:/PROGRA~1/MKSTOO~1/include is missing from the 'INCLUDE' environment variable. Shell i have to re-install MKSTOOLKIT again ?

Hi arndw,

I ran the command "cxx" from my command line .It is just showing pop-up and closing with in fraction of seconds.
I am not able to recognise that.

Hi Arndw, Thanks for you response. when i ran this command 1)"C:/Ascential/DataStage/Projects/AC/RT_BP1.O/V0S1_TEST_TFM_Transformer_1.tmp.o" It is showing can't find the file when i ran this command 2)"IC:/Ascential/DataStage/PXEngine/include -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c &...

Hi ArnDW,


Thanks for your response.

Your assumption is right !.

I have tried to execute compile command from command line.

But it is not working .

That means my c++ compiler not installed properly?

(or)

I have installed wrong version of c++ compiler ?

Hi Experts, Thanks for your resonse. I have installed datastage in my PC. First i have installed compiler then i have installed datastage server. By default compiler variables in DATASTAGE ADMINISTRATOR are coming like this. APT_COMPILEOPT--------->W/TP -W/EHa -APT_USE_ANSI_IOSTREAMS -c APT_COMPILER...

Hi All, I have installed datastage 7.5x2 in my system.But Transformer stage is not compiling even though i have installed Microsoft .net 2003 and visual studio 2005 version. Shell i have to include any variables? Please suggest me. I am getting following error. ##I TOSH 000002 17:59:52(001) <main_pr...