DSXchange

Thanks Kandy/sandy and Ray , I tested the job and if I don't provide any length to varchar field it reads the entire column data.



Thanks,
Raju

Thanks ray for the reply. If I don't provide any length to the varchar field in datastage, what is the maximum it takes is it ( 255 ) or is it going to read entire data from the column as you said it is a text field with out trimming or dropping any data from the column.


Thanks,
Raju

Hi , I have a file created by a server job with data type integer(10) and while I'm designing a parallel job I mentioned it as varchar(255), my question is what is the maximum varchar length I can give in datastage. Because when ever I import a meta data it gives me varchar(255) , is varchar(255) ma...

Thanks Every one

Hi, I have a parallel job and I'm writting data to sequential file and it had a field sv9 with char(10) data type and in the field properties I mentioned Null value as 'NULLNULLNU' to get rid of the waring When validating export schema: At field "sv9": "null_field" length (4) mus...

Thanks Chulett and Hester for helping me out and understanding about configuration file more clearly and correctly

Thanks chulett

Hi, I have a parallel job and the job is running fine if I don't sort the data and If I sort the data then the job is aborting with the below error APT_CombinedOperatorController,1: Fatal Error: Tsort merger aborting: Scratch space full I checked the space that I'm using $ df -P /opt/IBM/Information...

Hi I have a server job with two active stages transformers and the first transformer stage had a complex logic like calling routines and 80 stage variables where in second transfromer is having less logic it had 4 stage variables and writing to a sequential file. The first transformer has 5 outputs ...

Thanks Ray

Hi, We got a trail version of the C++ compiler and the code is working now. My first question is can we compile the code in development and run in production box with out C++ installed and my second question is what are the draw backs if we are using a trial version and not the actual license versio...

Hi chulett

Thanks for the reply. So I cann't compile my job outside the etl server in some other server



Thanks,
Raju,

Hi, Can I compile my DataStage job outside of datastage designer in some other box using some other C++ compiler. Because the C++ compiler is going to cost around $ 10, 000 . Can I use compiler like example g++ . If I can compile in some other box using different compiler please let me know, how to ...

Thanks Chulett

Hi, I found there are C compiler in the server $ /usr/sbin/swlist -l product | grep -i compiler COMPLIBS B.11.31 Compiler Support Libraries PHCO_39115 1.0 Linker/Compiler/Unwind ENG Manpage Patch PHSS_38155 1.0 bundled PA C compiler on IPF But the online Datastage site recommends - 64-bit HP-UX 11i ...