DSXchange

thanks Micheal,

I was about to do that test to see if I could add c++ compiler after the fact by updating the LIB and INCLUDE path after I've reinstalled and it is working. Well, it's always a learning curve and i really appreciate your help.

aggie

hi guys, I have my c++ compiler working. This is what i ended up doing, 1) Downloaded .NET 2008 Visual Studio, installed it 2) uninstalled IIS 3) reintalled IIS 4) Add PATH to LIB and INCLUDE system variable (WIN) 5) do not need to change the APT_COMPILER_OPT and APT_LINKEROPT var. All working now :...

no problem. I am taking the step to uninstall and reinstall.
-aggie

Can I add the compiler after the fact?

I installed MS Visual Studio C++ 2008, but still have issues.

that's what I am doing now, define the columns for records from row 11 onward. This resulted in a set of warnings in the log.
I guess I can downgrade the warnings. But I was hoping there're other options.

thx guys.

aggie

Can you tell me where to get the c++ compiler and which ENV variables I need to update. What to update to?

I have installed Information Server 8.1 on win xp.

thx,
aggie

Can someone tell me what this error is about. I got it every time I use a Transformer stage. It shows when I compile the job. ##W IIS-DSEE-TOSH-00049 21:35:47(007) <main_program> Parameter specified but not used in flow: DSPXWorkingDir ##E IIS-DSEE-TBLD-00076 21:35:48(000) <main_program> Error when ...

Hi guys, I was trying to restructure rows to columns. I used PIVOT stage but was not getting the results I want. This is what I tried to do. SOURCE contains 5 cols in a csv file (see below) Val1 VAl2 Val3 Val4 ID 1 2 3 4 DESC A B C D Expected Result: 2 columns: ID and DESC (see below) ID DESC 1 A 2 ...

hi guys, I need your help on how to skip reading the first 10 rows of a sequential file. I have a csv file, the first 10 records are metadata, the rest of the file is data records. Metadata have different field format from non-metadata. I try to read in the data, but not the metadata using sequentia...

DRS can read and write CLOB datatype stored in database. In DRS stage, the datatype for the CLOB field is LongVarChar. That's how datastage handle it, as far as what I have been able to do to take CLOB data from one database source to another.

the DRS stage supports CLOB. You define it as LongVarChar with a lenght. The lenght is used to allocate memory to hold the CLOB data, as it implies, it could use up a lot of memory.

-aggie

hi guys,

thanks for all your inputs. I got Information Server and Datastage installed successfully on xp, finally. My issue was the ID I used didn't have complete write permission. After that was resolved, the installation went well.

Aggie

you need to make sure the repository option is checked on install

I noticed that the checkbox next to it was grey out, I was not able to check it. does it mean my license file is missing the authorization.

thx again.

I got a license file for Datastage, Quality Stage and IA version 8.x. I need to install the above products in an xp machine for the first time and set up the development environment. But so far it has not been successful. I noticed that when I installed the software, it was not installing the metada...

hi ray, I did the same too.

I added the set of users on win xp. Do they all need to have administrator role. by the way, I hae service pack 3 win xp, does it matter?

did your install.exe install DB2 metadata for you as well?

thx. I am going to try again tonight.